DBA Data[Home] [Help]

APPS.XLA_00222_AAD_S_000004_PKG dependencies on XLA_EVENTS_GT

Line 20921: FROM xla_events_gt xet

20917:
20918: ELSE null
20919: END source_value
20920: , null source_meaning
20921: FROM xla_events_gt xet
20922: , AR_CASH_RECEIPTS_H_V h1
20923: ,(select rownum r from all_objects where rownum <= 4 and owner = p_apps_owner)
20924: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
20925: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 21068: FROM xla_events_gt xet

21064:
21065: ELSE null
21066: END source_value
21067: , null source_meaning
21068: FROM xla_events_gt xet
21069: , AR_DISTRIBUTIONS_BASE_V l2
21070: , AR_DISTRIBUTIONS_L_V l3
21071: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
21072: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 21277: FROM xla_events_gt xet

21273: , h1.RCT_DOC_SEQUENCE_CATEGORY source_37
21274: , h1.RCT_DOC_SEQUENCE_ID source_38
21275: , h1.RCT_DOC_SEQUENCE_VALUE source_39
21276: , h1.RCT_TRX_ACCT_REVERSAL source_41
21277: FROM xla_events_gt xet
21278: , AR_CASH_RECEIPTS_H_V h1
21279: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
21280: and xet.event_class_code = C_EVENT_CLASS_CODE
21281: and xet.event_status_code <> 'N' AND h1.event_id (+) = xet.event_id

Line 21328: FROM xla_events_gt xet

21324: , l2.DIST_TO_CUR_CONVERSION_DATE source_13
21325: , l2.DIST_CUR_CONVERSION_RATE source_14
21326: , l2.DIST_CUR_CONVERSION_TYPE source_15
21327: , l2.DIST_TO_ACCTD_AMT source_16
21328: FROM xla_events_gt xet
21329: , AR_DISTRIBUTIONS_BASE_V l2
21330: , AR_DISTRIBUTIONS_L_V l3
21331: WHERE xet.event_id between x_first_event_id and x_last_event_id
21332: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 22353: FROM xla_events_gt xet

22349:
22350: ELSE null
22351: END source_value
22352: , null source_meaning
22353: FROM xla_events_gt xet
22354: , AR_CASH_RECEIPTS_H_V h1
22355: , AR_RCT_SITE_USES_H_V h5
22356: , AR_REMIT_BANK_ACCT_H_V h7
22357: , AR_SYSTEM_PARAM_H_V h8

Line 22597: FROM xla_events_gt xet

22593:
22594: ELSE null
22595: END source_value
22596: , null source_meaning
22597: FROM xla_events_gt xet
22598: , AR_CUST_TRX_LINES_L_V l2
22599: , AR_DISTRIBUTIONS_BASE_V l3
22600: , AR_DISTRIBUTIONS_L_V l4
22601: , AR_RECEIVABLES_TRX_ACT_S_V l6

Line 22872: FROM xla_events_gt xet

22868: , h1.RCT_DOC_SEQUENCE_CATEGORY source_37
22869: , h1.RCT_DOC_SEQUENCE_ID source_38
22870: , h1.RCT_DOC_SEQUENCE_VALUE source_39
22871: , h1.RCT_TRX_ACCT_REVERSAL source_41
22872: FROM xla_events_gt xet
22873: , AR_CASH_RECEIPTS_H_V h1
22874: , AR_RCT_SITE_USES_H_V h5
22875: , AR_REMIT_BANK_ACCT_H_V h7
22876: , AR_SYSTEM_PARAM_H_V h8

Line 22947: FROM xla_events_gt xet

22943: , l3.DIST_TO_CUR_CONVERSION_RATE source_30
22944: , l3.DIST_TO_CUR_CONVERSION_TYPE source_31
22945: , l6.REC_ACT_TYPE source_32
22946: , l4.DIST_SOURCE_TABLE source_33
22947: FROM xla_events_gt xet
22948: , AR_CUST_TRX_LINES_L_V l2
22949: , AR_DISTRIBUTIONS_BASE_V l3
22950: , AR_DISTRIBUTIONS_L_V l4
22951: , AR_RECEIVABLES_TRX_ACT_S_V l6

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

24714: ,p_level => C_LEVEL_STATEMENT
24715: ,p_module => l_log_module);
24716:
24717: trace
24718: (p_msg => '# of events in xla_events_gt: '
24719: ||xla_context_pkg.get_event_count_context
24720: ,p_level => C_LEVEL_STATEMENT
24721: ,p_module => l_log_module);
24722: