eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_EVENTS_PKG dependencies on XLA_AE_HEADERS

Line 8790: xla_ae_headers xh

8786: DELETE FROM xla_distribution_links
8787: WHERE application_id= g_application_id and ae_header_id IN
8788: (SELECT xh.ae_header_id
8789: FROM xla_events_int_gt xeg,
8790: xla_ae_headers xh
8791: WHERE
8792: xh.event_id = xeg.event_id AND
8793: xh.application_id = g_application_id AND
8794: xh.accounting_entry_status_code IN ('D','R','RELATED_EVENT_ERROR','I','N')

Line 8813: ,xla_ae_headers xah

8809: DELETE FROM xla_ae_segment_values
8810: WHERE ae_header_id IN
8811: (SELECT xah.ae_header_id
8812: FROM xla_events xe
8813: ,xla_ae_headers xah
8814: ,xla_events_int_gt xeg
8815: WHERE xe.application_id = xah.application_id
8816: AND xah.event_id = xe.event_id
8817: AND xeg.event_id = xe.event_id);

Line 8834: ,xla_ae_headers xah

8830: DELETE FROM xla_ae_line_acs
8831: WHERE ae_header_id IN
8832: (SELECT xah.ae_header_id
8833: FROM xla_events xe
8834: ,xla_ae_headers xah
8835: ,xla_events_int_gt xeg
8836: WHERE xe.application_id = xah.application_id
8837: AND xah.event_id = xe.event_id
8838: AND xeg.event_id = xe.event_id);

Line 8855: ,xla_ae_headers xah

8851: DELETE FROM xla_ae_header_acs
8852: WHERE ae_header_id IN
8853: (SELECT xah.ae_header_id
8854: FROM xla_events xe
8855: ,xla_ae_headers xah
8856: ,xla_events_int_gt xeg
8857: WHERE xe.application_id = xah.application_id
8858: AND xah.event_id = xe.event_id
8859: AND xeg.event_id = xe.event_id);

Line 8877: ,xla_ae_headers xah

8873: DELETE FROM xla_ae_line_details
8874: WHERE ae_header_id IN
8875: (SELECT xah.ae_header_id
8876: FROM xla_events xe
8877: ,xla_ae_headers xah
8878: ,xla_events_int_gt xeg
8879: WHERE xe.application_id = xah.application_id
8880: AND xah.event_id = xe.event_id
8881: AND xeg.event_id = xe.event_id);

Line 8898: ,xla_ae_headers xah

8894: DELETE FROM xla_ae_header_details
8895: WHERE ae_header_id IN
8896: (SELECT xah.ae_header_id
8897: FROM xla_events xe
8898: ,xla_ae_headers xah
8899: ,xla_events_int_gt xeg
8900: WHERE xe.application_id = xah.application_id
8901: AND xah.event_id = xe.event_id
8902: AND xeg.event_id = xe.event_id);

Line 8920: ,xla_ae_headers xah

8916: WHERE application_id = g_application_id
8917: AND ae_header_id IN
8918: (SELECT xah.ae_header_id
8919: FROM xla_events xe
8920: ,xla_ae_headers xah
8921: ,xla_events_int_gt xeg
8922: WHERE xe.application_id = xah.application_id
8923: AND xe.application_id = g_application_id
8924: AND xah.application_id = g_application_id

Line 8936: -- Delete from xla_ae_headers

8932: ,p_module => l_log_module);
8933: END IF;
8934:
8935: --
8936: -- Delete from xla_ae_headers
8937: --
8938:
8939: DELETE FROM xla_ae_headers
8940: WHERE application_id = g_application_id

Line 8939: DELETE FROM xla_ae_headers

8935: --
8936: -- Delete from xla_ae_headers
8937: --
8938:
8939: DELETE FROM xla_ae_headers
8940: WHERE application_id = g_application_id
8941: AND ae_header_id IN
8942: (SELECT xah.ae_header_id
8943: FROM xla_events xe

Line 8944: ,xla_ae_headers xah

8940: WHERE application_id = g_application_id
8941: AND ae_header_id IN
8942: (SELECT xah.ae_header_id
8943: FROM xla_events xe
8944: ,xla_ae_headers xah
8945: ,xla_events_int_gt xeg
8946: WHERE xe.application_id = xah.application_id
8947: AND xah.event_id = xe.event_id
8948: AND xeg.event_id = xe.event_id);