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_09000_AAD_S_000015_PKG dependencies on XLA_EVENTS_GT

Line 6650: FROM xla_events_gt xet

6646:
6647: ELSE null
6648: END source_value
6649: , null source_meaning
6650: FROM xla_events_gt xet
6651: , DPP_XLA_INV_HEADERS_V h1
6652: ,(select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
6653: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6654: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 6768: FROM xla_events_gt xet

6764:
6765: ELSE null
6766: END source_value
6767: , null source_meaning
6768: FROM xla_events_gt xet
6769: , DPP_XLA_INV_LINES_V l2
6770: , (select rownum r from all_objects where rownum <= 5 and owner = p_apps_owner)
6771: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6772: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 6965: FROM xla_events_gt xet

6961: , h1.PP_ACCRUAL_CCID source_4
6962: , h1.PP_COST_ADJ_CCID source_8
6963: , h1.DISTRIBUTION_TYPE source_10
6964: , h1.TRANSFER_TO_GL_INDICATOR source_18
6965: FROM xla_events_gt xet
6966: , DPP_XLA_INV_HEADERS_V h1
6967: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
6968: and xet.event_class_code = C_EVENT_CLASS_CODE
6969: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 7010: FROM xla_events_gt xet

7006: , l2.DISTRIBUTION_IDENTIFIER source_9
7007: , l2.ENTERED_AMOUNT source_11
7008: , l2.CURRENCY_CODE source_12
7009: , l2.ACCOUNTED_AMOUNT source_13
7010: FROM xla_events_gt xet
7011: , DPP_XLA_INV_LINES_V l2
7012: WHERE xet.event_id between x_first_event_id and x_last_event_id
7013: and xet.event_date between p_pad_start_date and p_pad_end_date
7014: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 7820: FROM xla_events_gt xet

7816:
7817: ELSE null
7818: END source_value
7819: , null source_meaning
7820: FROM xla_events_gt xet
7821: , DPP_XLA_CLAIM_HEADERS_V h1
7822: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
7823: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7824: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 7942: FROM xla_events_gt xet

7938:
7939: ELSE null
7940: END source_value
7941: , null source_meaning
7942: FROM xla_events_gt xet
7943: , DPP_XLA_CLAIM_LINES_V l2
7944: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
7945: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7946: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 8148: FROM xla_events_gt xet

8144: , h1.DISTRIBUTION_TYPE source_10
8145: , h1.PARTY_ID source_14
8146: , h1.PARTY_SITE_ID source_15
8147: , h1.PARTY_TYPE source_16
8148: FROM xla_events_gt xet
8149: , DPP_XLA_CLAIM_HEADERS_V h1
8150: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
8151: and xet.event_type_code = C_EVENT_TYPE_CODE
8152: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 8194: FROM xla_events_gt xet

8190: , l2.DISTRIBUTION_IDENTIFIER source_9
8191: , l2.ENTERED_AMOUNT source_11
8192: , l2.CURRENCY_CODE source_12
8193: , l2.ACCOUNTED_AMOUNT source_13
8194: FROM xla_events_gt xet
8195: , DPP_XLA_CLAIM_LINES_V l2
8196: WHERE xet.event_id between x_first_event_id and x_last_event_id
8197: and xet.event_date between p_pad_start_date and p_pad_end_date
8198: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 9009: FROM xla_events_gt xet

9005:
9006: ELSE null
9007: END source_value
9008: , null source_meaning
9009: FROM xla_events_gt xet
9010: , DPP_XLA_CLAIM_HEADERS_V h1
9011: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
9012: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9013: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 9121: FROM xla_events_gt xet

9117:
9118: ELSE null
9119: END source_value
9120: , null source_meaning
9121: FROM xla_events_gt xet
9122: , DPP_XLA_CLAIM_LINES_V l2
9123: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
9124: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9125: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 9320: FROM xla_events_gt xet

9316: , h1.DISTRIBUTION_TYPE source_10
9317: , h1.PARTY_ID source_14
9318: , h1.PARTY_SITE_ID source_15
9319: , h1.PARTY_TYPE source_16
9320: FROM xla_events_gt xet
9321: , DPP_XLA_CLAIM_HEADERS_V h1
9322: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
9323: and xet.event_type_code = C_EVENT_TYPE_CODE
9324: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 9364: FROM xla_events_gt xet

9360: , l2.DISTRIBUTION_IDENTIFIER source_9
9361: , l2.ENTERED_AMOUNT source_11
9362: , l2.CURRENCY_CODE source_12
9363: , l2.ACCOUNTED_AMOUNT source_13
9364: FROM xla_events_gt xet
9365: , DPP_XLA_CLAIM_LINES_V l2
9366: WHERE xet.event_id between x_first_event_id and x_last_event_id
9367: and xet.event_date between p_pad_start_date and p_pad_end_date
9368: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 10177: FROM xla_events_gt xet

10173:
10174: ELSE null
10175: END source_value
10176: , null source_meaning
10177: FROM xla_events_gt xet
10178: , DPP_XLA_CLAIM_HEADERS_V h1
10179: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
10180: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
10181: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 10299: FROM xla_events_gt xet

10295:
10296: ELSE null
10297: END source_value
10298: , null source_meaning
10299: FROM xla_events_gt xet
10300: , DPP_XLA_CLAIM_LINES_V l2
10301: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
10302: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
10303: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 10505: FROM xla_events_gt xet

10501: , h1.DISTRIBUTION_TYPE source_10
10502: , h1.PARTY_ID source_14
10503: , h1.PARTY_SITE_ID source_15
10504: , h1.PARTY_TYPE source_16
10505: FROM xla_events_gt xet
10506: , DPP_XLA_CLAIM_HEADERS_V h1
10507: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
10508: and xet.event_type_code = C_EVENT_TYPE_CODE
10509: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 10551: FROM xla_events_gt xet

10547: , l2.DISTRIBUTION_IDENTIFIER source_9
10548: , l2.ENTERED_AMOUNT source_11
10549: , l2.CURRENCY_CODE source_12
10550: , l2.ACCOUNTED_AMOUNT source_13
10551: FROM xla_events_gt xet
10552: , DPP_XLA_CLAIM_LINES_V l2
10553: WHERE xet.event_id between x_first_event_id and x_last_event_id
10554: and xet.event_date between p_pad_start_date and p_pad_end_date
10555: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 11371: FROM xla_events_gt xet

11367:
11368: ELSE null
11369: END source_value
11370: , null source_meaning
11371: FROM xla_events_gt xet
11372: , DPP_XLA_CLAIM_HEADERS_V h1
11373: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
11374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11375: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 11493: FROM xla_events_gt xet

11489:
11490: ELSE null
11491: END source_value
11492: , null source_meaning
11493: FROM xla_events_gt xet
11494: , DPP_XLA_CLAIM_LINES_V l2
11495: ,(select rownum r from all_objects where rownum <= 6 and owner = p_apps_owner)
11496: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11497: AND xet.event_type_code = C_EVENT_TYPE_CODE

Line 11699: FROM xla_events_gt xet

11695: , h1.DISTRIBUTION_TYPE source_10
11696: , h1.PARTY_ID source_14
11697: , h1.PARTY_SITE_ID source_15
11698: , h1.PARTY_TYPE source_16
11699: FROM xla_events_gt xet
11700: , DPP_XLA_CLAIM_HEADERS_V h1
11701: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
11702: and xet.event_type_code = C_EVENT_TYPE_CODE
11703: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 11745: FROM xla_events_gt xet

11741: , l2.DISTRIBUTION_IDENTIFIER source_9
11742: , l2.ENTERED_AMOUNT source_11
11743: , l2.CURRENCY_CODE source_12
11744: , l2.ACCOUNTED_AMOUNT source_13
11745: FROM xla_events_gt xet
11746: , DPP_XLA_CLAIM_LINES_V l2
11747: WHERE xet.event_id between x_first_event_id and x_last_event_id
11748: and xet.event_date between p_pad_start_date and p_pad_end_date
11749: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 12653: (p_msg => '# of events in xla_events_gt: '

12649: ,p_level => C_LEVEL_STATEMENT
12650: ,p_module => l_log_module);
12651:
12652: trace
12653: (p_msg => '# of events in xla_events_gt: '
12654: ||xla_context_pkg.get_event_count_context
12655: ,p_level => C_LEVEL_STATEMENT
12656: ,p_module => l_log_module);
12657: