[Home] [Help]
52778: SELECT xet.event_id event_id
52779: , 0 line_number
52780: , CASE r
52781: WHEN 1 THEN 'AR_TRANSACTIONS_S_V'
52782: WHEN 2 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
52783: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
52784: WHEN 4 THEN 'AR_BILL_TO_SITE_USES_S_V'
52785: WHEN 5 THEN 'AR_TRANSACTIONS_S_V'
52786: WHEN 6 THEN 'AR_ADJUSTMENTS_H_V'
52842: FROM xla_events_gt xet
52843: , AR_ADJUSTMENTS_H_V h1
52844: , AR_BILL_TO_CUSTOMERS_S_V h2
52845: , AR_BILL_TO_SITE_USES_S_V h3
52846: , AR_RECEIVABLES_TRX_ACT_S_V h6
52847: , AR_TRANSACTIONS_S_V h7
52848: ,(select rownum r from all_objects where rownum <= 8 and owner = p_apps_owner)
52849: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
52850: AND xet.event_class_code = C_EVENT_CLASS_CODE
53132: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
53133: --
53134:
53135: TYPE t_array_source_9 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_RECEIVABLE_CCID%TYPE INDEX BY BINARY_INTEGER;
53136: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
53137: TYPE t_array_source_23 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUST_ACCOUNT_ID%TYPE INDEX BY BINARY_INTEGER;
53138: TYPE t_array_source_24 IS TABLE OF AR_BILL_TO_SITE_USES_S_V.BILL_USES_SITE_USE_ID%TYPE INDEX BY BINARY_INTEGER;
53139: TYPE t_array_source_25 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
53140: TYPE t_array_source_71 IS TABLE OF AR_ADJUSTMENTS_H_V.ADJ_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
53212: FROM xla_events_gt xet
53213: , AR_ADJUSTMENTS_H_V h1
53214: , AR_BILL_TO_CUSTOMERS_S_V h2
53215: , AR_BILL_TO_SITE_USES_S_V h3
53216: , AR_RECEIVABLES_TRX_ACT_S_V h6
53217: , AR_TRANSACTIONS_S_V h7
53218: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
53219: and xet.event_class_code = C_EVENT_CLASS_CODE
53220: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
55566: , CASE r
55567: WHEN 1 THEN 'AR_CM_LINES_L_V'
55568: WHEN 2 THEN 'AR_DISTRIBUTIONS_L_V'
55569: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
55570: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
55571: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
55572: WHEN 6 THEN 'AR_CM_LINES_BASE_V'
55573: WHEN 7 THEN 'AR_CM_LINES_BASE_V'
55574: WHEN 8 THEN 'AR_CM_LINES_BASE_V'
55663: FROM xla_events_gt xet
55664: , AR_CM_LINES_BASE_V l3
55665: , AR_CM_LINES_L_V l4
55666: , AR_DISTRIBUTIONS_L_V l6
55667: , AR_RECEIVABLES_TRX_ACT_S_V l7
55668: , (select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
55669: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
55670: AND xet.event_class_code = C_EVENT_CLASS_CODE
55671: AND l3.event_id = xet.event_id
55819:
55820: TYPE t_array_source_2 IS TABLE OF AR_CM_LINES_L_V.CM_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
55821: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
55822: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
55823: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
55824: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
55825: TYPE t_array_source_35 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_IDENTIFER%TYPE INDEX BY BINARY_INTEGER;
55826: TYPE t_array_source_36 IS TABLE OF AR_CM_LINES_BASE_V.CM_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
55827: TYPE t_array_source_38 IS TABLE OF AR_CM_LINES_BASE_V.CM_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
55959: FROM xla_events_gt xet
55960: , AR_CM_LINES_BASE_V l3
55961: , AR_CM_LINES_L_V l4
55962: , AR_DISTRIBUTIONS_L_V l6
55963: , AR_RECEIVABLES_TRX_ACT_S_V l7
55964: WHERE xet.event_id between x_first_event_id and x_last_event_id
55965: and xet.event_date between p_pad_start_date and p_pad_end_date
55966: and xet.event_class_code = C_EVENT_CLASS_CODE
55967: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id
64207: , CASE r
64208: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64209: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
64210: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64211: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64212: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64213: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'
64214: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
64215: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
64369: FROM xla_events_gt xet
64370: , AR_CUST_TRX_LINES_L_V l2
64371: , AR_DISTRIBUTIONS_BASE_V l3
64372: , AR_DISTRIBUTIONS_L_V l4
64373: , AR_RECEIVABLES_TRX_ACT_S_V l7
64374: , AR_TRANSACTIONS_S_V l10
64375: , (select rownum r from all_objects where rownum <= 28 and owner = p_apps_owner)
64376: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
64377: AND xet.event_class_code = C_EVENT_CLASS_CODE
64537:
64538: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64539: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
64540: TYPE t_array_source_13 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64541: TYPE t_array_source_14 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64542: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64543: TYPE t_array_source_16 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64544: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;
64545: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
64736: FROM xla_events_gt xet
64737: , AR_CUST_TRX_LINES_L_V l2
64738: , AR_DISTRIBUTIONS_BASE_V l3
64739: , AR_DISTRIBUTIONS_L_V l4
64740: , AR_RECEIVABLES_TRX_ACT_S_V l7
64741: , AR_TRANSACTIONS_S_V l10
64742: WHERE xet.event_id between x_first_event_id and x_last_event_id
64743: and xet.event_date between p_pad_start_date and p_pad_end_date
64744: and xet.event_class_code = C_EVENT_CLASS_CODE