SLA Setup Details R12

 
  select *
   FROM xla_prod_acct_headers  pah,
           xla_event_classes_tl   ecl,
           xla_event_types_tl     etl,
           xla_lookups            xlk
     WHERE     pah.application_id = ecl.application_id
           AND pah.entity_code = ecl.entity_code
           AND pah.event_class_code = ecl.event_class_code
           AND ecl.language = USERENV ('LANG')
           AND pah.application_id = etl.application_id
           AND pah.entity_code = etl.entity_code
           AND pah.event_class_code = etl.event_class_code
           AND pah.event_type_code = etl.event_type_code
           AND etl.language = USERENV ('LANG')
           AND xlk.lookup_code(+) = pah.validation_status_code
           AND xlk.lookup_type(+) = 'XLA_COMPILE_STATUS_TYPE';