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 4962: FROM xla_ae_headers xah,xla_ae_lines xal

4958: SELECT count(1)
4959: INTO l_count
4960: FROM dual
4961: WHERE EXISTS (SELECT 1
4962: FROM xla_ae_headers xah,xla_ae_lines xal
4963: WHERE xah.application_id = g_application_id
4964: AND xah.entity_id = g_entity_id
4965: AND xah.application_id = xal.application_id
4966: AND xah.ae_header_id = xal.ae_header_id

Line 9528: xla_ae_headers xh

9524: DELETE FROM xla_distribution_links
9525: WHERE application_id= g_application_id and ae_header_id IN
9526: (SELECT xh.ae_header_id
9527: FROM xla_events_int_gt xeg,
9528: xla_ae_headers xh
9529: WHERE
9530: xh.event_id = xeg.event_id AND
9531: xh.application_id = g_application_id AND
9532: xh.accounting_entry_status_code IN ('D','R','RELATED_EVENT_ERROR','I','N')

Line 9552: xla_ae_headers xah

9548: WHERE ae_header_id IN
9549: (SELECT xah.ae_header_id
9550: FROM
9551: --xla_events xe, 9775727
9552: xla_ae_headers xah
9553: ,xla_events_int_gt xeg
9554: WHERE xah.event_id = xeg.event_id
9555: AND xah.application_id = g_application_id -- 8967771
9556: --AND xah.event_id = xe.event_id 9775727

Line 9577: xla_ae_headers xah

9573: WHERE ae_header_id IN
9574: (SELECT xah.ae_header_id
9575: FROM
9576: --xla_events xe, 9775727
9577: xla_ae_headers xah
9578: ,xla_events_int_gt xeg
9579: WHERE xah.event_id = xeg.event_id
9580: AND xah.application_id = g_application_id -- 8967771
9581: --AND xah.event_id = xe.event_id 9775727

Line 9602: xla_ae_headers xah

9598: WHERE ae_header_id IN
9599: (SELECT xah.ae_header_id
9600: FROM
9601: --xla_events xe, 9775727
9602: xla_ae_headers xah
9603: ,xla_events_int_gt xeg
9604: WHERE xah.event_id = xeg.event_id
9605: AND xah.application_id = g_application_id -- 8967771
9606: --AND xah.event_id = xe.event_id 9775727

Line 9628: xla_ae_headers xah

9624: WHERE ae_header_id IN
9625: (SELECT xah.ae_header_id
9626: FROM
9627: --xla_events xe, 9775727
9628: xla_ae_headers xah
9629: ,xla_events_int_gt xeg
9630: WHERE xah.event_id = xeg.event_id
9631: AND xah.application_id = g_application_id -- 8967771
9632: --AND xah.event_id = xe.event_id 9775727

Line 9653: xla_ae_headers xah

9649: WHERE ae_header_id IN
9650: (SELECT xah.ae_header_id
9651: FROM
9652: --xla_events xe, 9775727
9653: xla_ae_headers xah
9654: ,xla_events_int_gt xeg
9655: WHERE xah.event_id = xeg.event_id
9656: AND xah.application_id = g_application_id -- 8967771
9657: --AND xah.event_id = xe.event_id 9775727

Line 9679: xla_ae_headers xah

9675: AND ae_header_id IN
9676: (SELECT xah.ae_header_id
9677: FROM
9678: --xla_events xe, 9775727
9679: xla_ae_headers xah
9680: ,xla_events_int_gt xeg
9681: WHERE xah.event_id = xeg.event_id
9682: AND xah.application_id = g_application_id -- 8967771
9683: --AND xah.event_id = xe.event_id 9775727

Line 9696: -- Delete from xla_ae_headers

9692: ,p_module => l_log_module);
9693: END IF;
9694:
9695: --
9696: -- Delete from xla_ae_headers
9697: --
9698:
9699: DELETE FROM xla_ae_headers
9700: WHERE application_id = g_application_id

Line 9699: DELETE FROM xla_ae_headers

9695: --
9696: -- Delete from xla_ae_headers
9697: --
9698:
9699: DELETE FROM xla_ae_headers
9700: WHERE application_id = g_application_id
9701: AND ae_header_id IN
9702: (SELECT xah.ae_header_id
9703: FROM

Line 9705: xla_ae_headers xah

9701: AND ae_header_id IN
9702: (SELECT xah.ae_header_id
9703: FROM
9704: --xla_events xe, 9775727
9705: xla_ae_headers xah
9706: ,xla_events_int_gt xeg
9707: WHERE xah.event_id = xeg.event_id
9708: AND xah.application_id = g_application_id -- 8967771
9709: --AND xah.event_id = xe.event_id 9775727