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_00222_AAD_S_000005_PKG dependencies on AR_CUST_TRX_LINES_L_V

Line 68321: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

68317: FROM (
68318: SELECT xet.event_id event_id
68319: , l4.line_number line_number
68320: , CASE r
68321: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
68322: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
68323: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
68324: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
68325: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 68322: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

68318: SELECT xet.event_id event_id
68319: , l4.line_number line_number
68320: , CASE r
68321: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
68322: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
68323: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
68324: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
68325: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
68326: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 68323: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

68319: , l4.line_number line_number
68320: , CASE r
68321: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
68322: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
68323: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
68324: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
68325: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
68326: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
68327: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 68324: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

68320: , CASE r
68321: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
68322: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
68323: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
68324: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
68325: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
68326: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
68327: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
68328: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 68325: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

68321: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
68322: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
68323: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
68324: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
68325: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
68326: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
68327: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
68328: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
68329: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 68389: , AR_CUST_TRX_LINES_L_V l4

68385: END source_value
68386: , null source_meaning
68387: FROM xla_events_gt xet
68388: , AR_CUST_TRX_LINES_BASE_V l3
68389: , AR_CUST_TRX_LINES_L_V l4
68390: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
68391: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
68392: AND xet.event_class_code = C_EVENT_CLASS_CODE
68393: AND l3.event_id = xet.event_id

Line 68537: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

68533: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
68534: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68535: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
68536:
68537: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
68538: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
68539: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
68540: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68541: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 68538: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

68534: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
68535: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
68536:
68537: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
68538: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
68539: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
68540: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68541: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
68542: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 68539: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

68535: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
68536:
68537: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
68538: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
68539: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
68540: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68541: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
68542: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68543: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 68540: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

68536:
68537: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
68538: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
68539: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
68540: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68541: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
68542: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68543: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68544: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 68541: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

68537: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
68538: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
68539: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
68540: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68541: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
68542: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68543: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68544: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68545: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 68656: , AR_CUST_TRX_LINES_L_V l4

68652: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
68653: , l3.TRX_LINE_ACCTD_AMT source_41
68654: FROM xla_events_gt xet
68655: , AR_CUST_TRX_LINES_BASE_V l3
68656: , AR_CUST_TRX_LINES_L_V l4
68657: WHERE xet.event_id between x_first_event_id and x_last_event_id
68658: and xet.event_date between p_pad_start_date and p_pad_end_date
68659: and xet.event_class_code = C_EVENT_CLASS_CODE
68660: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 71299: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

71295: FROM (
71296: SELECT xet.event_id event_id
71297: , l4.line_number line_number
71298: , CASE r
71299: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
71300: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
71301: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
71302: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
71303: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 71300: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

71296: SELECT xet.event_id event_id
71297: , l4.line_number line_number
71298: , CASE r
71299: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
71300: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
71301: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
71302: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
71303: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
71304: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 71301: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

71297: , l4.line_number line_number
71298: , CASE r
71299: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
71300: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
71301: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
71302: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
71303: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
71304: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
71305: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 71302: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

71298: , CASE r
71299: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
71300: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
71301: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
71302: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
71303: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
71304: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
71305: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
71306: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 71303: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

71299: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
71300: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
71301: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
71302: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
71303: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
71304: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
71305: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
71306: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
71307: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 71308: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

71304: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
71305: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
71306: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
71307: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
71308: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
71309:
71310: ELSE null
71311: END object_name
71312: , CASE r

Line 71372: , AR_CUST_TRX_LINES_L_V l4

71368: END source_value
71369: , null source_meaning
71370: FROM xla_events_gt xet
71371: , AR_CUST_TRX_LINES_BASE_V l3
71372: , AR_CUST_TRX_LINES_L_V l4
71373: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
71374: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
71375: AND xet.event_class_code = C_EVENT_CLASS_CODE
71376: AND l3.event_id = xet.event_id

Line 71520: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

71516: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
71517: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71518: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
71519:
71520: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
71521: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
71522: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
71523: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71524: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 71521: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

71517: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
71518: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
71519:
71520: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
71521: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
71522: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
71523: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71524: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
71525: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 71522: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

71518: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
71519:
71520: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
71521: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
71522: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
71523: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71524: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
71525: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
71526: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 71523: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

71519:
71520: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
71521: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
71522: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
71523: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71524: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
71525: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
71526: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
71527: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 71524: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

71520: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
71521: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
71522: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
71523: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71524: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
71525: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
71526: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
71527: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71528: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 71529: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

71525: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
71526: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
71527: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71528: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
71529: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
71530:
71531: l_array_source_3 t_array_source_3;
71532: l_array_source_30 t_array_source_30;
71533: l_array_source_31 t_array_source_31;

Line 71642: , AR_CUST_TRX_LINES_L_V l4

71638: , l3.TRX_LINE_ACCTD_AMT source_41
71639: , l4.TRX_TAX_LINE_ID source_55
71640: FROM xla_events_gt xet
71641: , AR_CUST_TRX_LINES_BASE_V l3
71642: , AR_CUST_TRX_LINES_L_V l4
71643: WHERE xet.event_id between x_first_event_id and x_last_event_id
71644: and xet.event_date between p_pad_start_date and p_pad_end_date
71645: and xet.event_class_code = C_EVENT_CLASS_CODE
71646: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 72780: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

72776: FROM (
72777: SELECT xet.event_id event_id
72778: , l4.line_number line_number
72779: , CASE r
72780: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
72781: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
72782: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72783: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72784: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 72781: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

72777: SELECT xet.event_id event_id
72778: , l4.line_number line_number
72779: , CASE r
72780: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
72781: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
72782: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72783: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72784: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72785: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 72782: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

72778: , l4.line_number line_number
72779: , CASE r
72780: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
72781: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
72782: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72783: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72784: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72785: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72786: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 72783: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

72779: , CASE r
72780: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
72781: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
72782: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72783: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72784: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72785: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72786: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72787: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 72784: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

72780: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
72781: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
72782: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72783: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72784: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72785: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72786: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72787: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72788: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 72848: , AR_CUST_TRX_LINES_L_V l4

72844: END source_value
72845: , null source_meaning
72846: FROM xla_events_gt xet
72847: , AR_CUST_TRX_LINES_BASE_V l3
72848: , AR_CUST_TRX_LINES_L_V l4
72849: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
72850: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72851: AND xet.event_class_code = C_EVENT_CLASS_CODE
72852: AND l3.event_id = xet.event_id

Line 72996: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

72992: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
72993: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72994: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72995:
72996: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72997: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72998: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72999: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73000: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 72997: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

72993: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72994: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72995:
72996: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72997: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72998: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72999: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73000: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73001: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 72998: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

72994: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72995:
72996: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72997: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72998: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72999: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73000: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73001: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73002: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 72999: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

72995:
72996: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72997: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72998: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72999: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73000: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73001: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73002: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73003: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 73000: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

72996: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72997: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72998: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72999: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73000: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73001: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73002: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73003: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73004: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 73115: , AR_CUST_TRX_LINES_L_V l4

73111: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
73112: , l3.TRX_LINE_ACCTD_AMT source_41
73113: FROM xla_events_gt xet
73114: , AR_CUST_TRX_LINES_BASE_V l3
73115: , AR_CUST_TRX_LINES_L_V l4
73116: WHERE xet.event_id between x_first_event_id and x_last_event_id
73117: and xet.event_date between p_pad_start_date and p_pad_end_date
73118: and xet.event_class_code = C_EVENT_CLASS_CODE
73119: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 74026: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

74022: FROM (
74023: SELECT xet.event_id event_id
74024: , l4.line_number line_number
74025: , CASE r
74026: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74027: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74028: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74029: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74030: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 74027: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

74023: SELECT xet.event_id event_id
74024: , l4.line_number line_number
74025: , CASE r
74026: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74027: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74028: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74029: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74030: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74031: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74028: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

74024: , l4.line_number line_number
74025: , CASE r
74026: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74027: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74028: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74029: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74030: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74031: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74032: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74029: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

74025: , CASE r
74026: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74027: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74028: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74029: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74030: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74031: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74032: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74033: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74030: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

74026: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74027: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74028: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74029: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74030: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74031: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74032: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74033: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74034: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74094: , AR_CUST_TRX_LINES_L_V l4

74090: END source_value
74091: , null source_meaning
74092: FROM xla_events_gt xet
74093: , AR_CUST_TRX_LINES_BASE_V l3
74094: , AR_CUST_TRX_LINES_L_V l4
74095: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
74096: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74097: AND xet.event_class_code = C_EVENT_CLASS_CODE
74098: AND l3.event_id = xet.event_id

Line 74242: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

74238: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74239: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74240: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74241:
74242: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74243: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74244: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74245: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74246: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 74243: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

74239: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74240: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74241:
74242: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74243: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74244: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74245: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74246: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74247: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 74244: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

74240: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74241:
74242: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74243: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74244: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74245: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74246: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74247: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74248: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 74245: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

74241:
74242: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74243: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74244: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74245: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74246: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74247: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74248: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
74249: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 74246: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

74242: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74243: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74244: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74245: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74246: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74247: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74248: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
74249: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74250: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 74361: , AR_CUST_TRX_LINES_L_V l4

74357: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
74358: , l3.TRX_LINE_ACCTD_AMT source_41
74359: FROM xla_events_gt xet
74360: , AR_CUST_TRX_LINES_BASE_V l3
74361: , AR_CUST_TRX_LINES_L_V l4
74362: WHERE xet.event_id between x_first_event_id and x_last_event_id
74363: and xet.event_date between p_pad_start_date and p_pad_end_date
74364: and xet.event_class_code = C_EVENT_CLASS_CODE
74365: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 75283: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

75279: SELECT xet.event_id event_id
75280: , l4.line_number line_number
75281: , CASE r
75282: WHEN 1 THEN 'FV_XLA_AR_REF_V'
75283: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
75284: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75285: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75286: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75287: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'

Line 75284: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

75280: , l4.line_number line_number
75281: , CASE r
75282: WHEN 1 THEN 'FV_XLA_AR_REF_V'
75283: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
75284: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75285: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75286: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75287: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
75288: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 75285: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

75281: , CASE r
75282: WHEN 1 THEN 'FV_XLA_AR_REF_V'
75283: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
75284: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75285: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75286: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75287: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
75288: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75289: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 75286: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

75282: WHEN 1 THEN 'FV_XLA_AR_REF_V'
75283: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
75284: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75285: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75286: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75287: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
75288: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75289: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75290: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 75287: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'

75283: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
75284: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75285: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75286: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75287: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
75288: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75289: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75290: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
75291: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 75292: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'

75288: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75289: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75290: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
75291: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
75292: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
75293: WHEN 12 THEN 'FV_XLA_AR_REF_V'
75294: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'
75295:
75296: ELSE null

Line 75370: , AR_CUST_TRX_LINES_L_V l4

75366: END source_value
75367: , null source_meaning
75368: FROM xla_events_gt xet
75369: , AR_CUST_TRX_LINES_BASE_V l3
75370: , AR_CUST_TRX_LINES_L_V l4
75371: , FV_XLA_AR_REF_V l6
75372: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
75373: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75374: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 75522: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

75518: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75519: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
75520:
75521: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75522: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75523: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75524: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75525: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75526: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 75523: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

75519: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
75520:
75521: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75522: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75523: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75524: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75525: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75526: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75527: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 75524: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

75520:
75521: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75522: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75523: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75524: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75525: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75526: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75527: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75528: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 75525: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

75521: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75522: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75523: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75524: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75525: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75526: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75527: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75528: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75529: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 75526: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

75522: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75523: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75524: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75525: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75526: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75527: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75528: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75529: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75530: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 75531: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

75527: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75528: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75529: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75530: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75531: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
75532: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75533: TYPE t_array_source_66 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
75534:
75535: l_array_source_3 t_array_source_3;

Line 75656: , AR_CUST_TRX_LINES_L_V l4

75652: , l6.FEDERAL_ACCOUNT_VALID_FLAG source_56
75653: , l3.ROUNDING_CORRECTION_FLAG source_66
75654: FROM xla_events_gt xet
75655: , AR_CUST_TRX_LINES_BASE_V l3
75656: , AR_CUST_TRX_LINES_L_V l4
75657: , FV_XLA_AR_REF_V l6
75658: WHERE xet.event_id between x_first_event_id and x_last_event_id
75659: and xet.event_date between p_pad_start_date and p_pad_end_date
75660: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 78739: WHEN 22 THEN 'AR_CUST_TRX_LINES_L_V'

78735: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
78736: WHEN 19 THEN 'AR_DISTRIBUTIONS_BASE_V'
78737: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
78738: WHEN 21 THEN 'AR_DISTRIBUTIONS_BASE_V'
78739: WHEN 22 THEN 'AR_CUST_TRX_LINES_L_V'
78740: WHEN 23 THEN 'AR_CUST_TRX_LINES_L_V'
78741: WHEN 24 THEN 'AR_CUST_TRX_LINES_L_V'
78742: WHEN 25 THEN 'FV_XLA_AR_REF_V'
78743: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 78740: WHEN 23 THEN 'AR_CUST_TRX_LINES_L_V'

78736: WHEN 19 THEN 'AR_DISTRIBUTIONS_BASE_V'
78737: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
78738: WHEN 21 THEN 'AR_DISTRIBUTIONS_BASE_V'
78739: WHEN 22 THEN 'AR_CUST_TRX_LINES_L_V'
78740: WHEN 23 THEN 'AR_CUST_TRX_LINES_L_V'
78741: WHEN 24 THEN 'AR_CUST_TRX_LINES_L_V'
78742: WHEN 25 THEN 'FV_XLA_AR_REF_V'
78743: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
78744: WHEN 27 THEN 'AR_TRANSACTIONS_S_V'

Line 78741: WHEN 24 THEN 'AR_CUST_TRX_LINES_L_V'

78737: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
78738: WHEN 21 THEN 'AR_DISTRIBUTIONS_BASE_V'
78739: WHEN 22 THEN 'AR_CUST_TRX_LINES_L_V'
78740: WHEN 23 THEN 'AR_CUST_TRX_LINES_L_V'
78741: WHEN 24 THEN 'AR_CUST_TRX_LINES_L_V'
78742: WHEN 25 THEN 'FV_XLA_AR_REF_V'
78743: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
78744: WHEN 27 THEN 'AR_TRANSACTIONS_S_V'
78745: WHEN 28 THEN 'AR_TRANSACTIONS_S_V'

Line 78931: , AR_CUST_TRX_LINES_L_V l3

78927: END source_value
78928: , null source_meaning
78929: FROM xla_events_gt xet
78930: , AR_BILL_TO_CUSTOMERS_S_V l1
78931: , AR_CUST_TRX_LINES_L_V l3
78932: , AR_DISTRIBUTIONS_BASE_V l4
78933: , AR_DISTRIBUTIONS_L_V l5
78934: , AR_RECEIVABLES_TRX_ACT_S_V l7
78935: , AR_TRANSACTIONS_S_V l10

Line 79120: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

79116: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79117: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79118: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79119: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79120: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79121: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79122: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79123: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 79121: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

79117: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79118: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79119: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79120: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79121: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79122: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79123: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79125: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 79122: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

79118: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79119: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79120: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79121: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79122: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79123: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79125: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79126: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79321: , AR_CUST_TRX_LINES_L_V l3

79317: , l4.DIST_TO_CUR_CONVERSION_TYPE source_70
79318: , l5.DIST_SOURCE_TABLE source_71
79319: FROM xla_events_gt xet
79320: , AR_BILL_TO_CUSTOMERS_S_V l1
79321: , AR_CUST_TRX_LINES_L_V l3
79322: , AR_DISTRIBUTIONS_BASE_V l4
79323: , AR_DISTRIBUTIONS_L_V l5
79324: , AR_RECEIVABLES_TRX_ACT_S_V l7
79325: , AR_TRANSACTIONS_S_V l10