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

Line 54314: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

54310: FROM (
54311: SELECT xet.event_id event_id
54312: , l4.line_number line_number
54313: , CASE r
54314: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
54315: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
54316: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54317: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54318: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 54315: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

54311: SELECT xet.event_id event_id
54312: , l4.line_number line_number
54313: , CASE r
54314: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
54315: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
54316: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54317: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54318: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54319: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 54316: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

54312: , l4.line_number line_number
54313: , CASE r
54314: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
54315: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
54316: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54317: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54318: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54319: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54320: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 54317: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

54313: , CASE r
54314: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
54315: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
54316: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54317: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54318: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54319: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54320: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
54321: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 54318: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

54314: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
54315: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
54316: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54317: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54318: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54319: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54320: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
54321: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
54322: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 54382: , AR_CUST_TRX_LINES_L_V l4

54378: END source_value
54379: , null source_meaning
54380: FROM xla_events_gt xet
54381: , AR_CUST_TRX_LINES_BASE_V l3
54382: , AR_CUST_TRX_LINES_L_V l4
54383: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
54384: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54385: AND xet.event_class_code = C_EVENT_CLASS_CODE
54386: AND l3.event_id = xet.event_id

Line 54530: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

54526: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
54527: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54528: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54529:
54530: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54531: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54532: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54533: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54534: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 54531: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

54527: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54528: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54529:
54530: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54531: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54532: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54533: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54534: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54535: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 54532: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

54528: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54529:
54530: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54531: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54532: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54533: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54534: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54535: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54536: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 54533: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

54529:
54530: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54531: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54532: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54533: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54534: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54535: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54536: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
54537: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 54534: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

54530: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54531: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54532: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54533: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54534: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54535: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54536: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
54537: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54538: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 54649: , AR_CUST_TRX_LINES_L_V l4

54645: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
54646: , l3.TRX_LINE_ACCTD_AMT source_34
54647: FROM xla_events_gt xet
54648: , AR_CUST_TRX_LINES_BASE_V l3
54649: , AR_CUST_TRX_LINES_L_V l4
54650: WHERE xet.event_id between x_first_event_id and x_last_event_id
54651: and xet.event_date between p_pad_start_date and p_pad_end_date
54652: and xet.event_class_code = C_EVENT_CLASS_CODE
54653: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 57189: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

57185: FROM (
57186: SELECT xet.event_id event_id
57187: , l4.line_number line_number
57188: , CASE r
57189: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
57190: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
57191: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57192: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57193: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 57190: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

57186: SELECT xet.event_id event_id
57187: , l4.line_number line_number
57188: , CASE r
57189: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
57190: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
57191: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57192: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57193: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57194: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 57191: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

57187: , l4.line_number line_number
57188: , CASE r
57189: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
57190: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
57191: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57192: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57193: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57194: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57195: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 57192: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

57188: , CASE r
57189: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
57190: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
57191: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57192: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57193: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57194: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57195: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57196: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 57193: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

57189: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
57190: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
57191: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57192: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57193: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57194: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57195: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57196: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
57197: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 57198: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

57194: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57195: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57196: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
57197: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
57198: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
57199:
57200: ELSE null
57201: END object_name
57202: , CASE r

Line 57262: , AR_CUST_TRX_LINES_L_V l4

57258: END source_value
57259: , null source_meaning
57260: FROM xla_events_gt xet
57261: , AR_CUST_TRX_LINES_BASE_V l3
57262: , AR_CUST_TRX_LINES_L_V l4
57263: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
57264: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57265: AND xet.event_class_code = C_EVENT_CLASS_CODE
57266: AND l3.event_id = xet.event_id

Line 57412: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

57408: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57409: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57411:
57412: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 57413: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

57409: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57410: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57411:
57412: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 57414: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

57410: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57411:
57412: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 57415: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

57411:
57412: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 57416: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

57412: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57413: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57414: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57415: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57416: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57417: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 57421: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

57417: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57418: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57419: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57420: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
57421: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
57422:
57423: l_array_source_9 t_array_source_9;
57424: l_array_source_23 t_array_source_23;
57425: l_array_source_24 t_array_source_24;

Line 57538: , AR_CUST_TRX_LINES_L_V l4

57534: , l3.TRX_LINE_ACCTD_AMT source_34
57535: , l4.TRX_TAX_LINE_ID source_48
57536: FROM xla_events_gt xet
57537: , AR_CUST_TRX_LINES_BASE_V l3
57538: , AR_CUST_TRX_LINES_L_V l4
57539: WHERE xet.event_id between x_first_event_id and x_last_event_id
57540: and xet.event_date between p_pad_start_date and p_pad_end_date
57541: and xet.event_class_code = C_EVENT_CLASS_CODE
57542: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 58650: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

58646: FROM (
58647: SELECT xet.event_id event_id
58648: , l4.line_number line_number
58649: , CASE r
58650: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
58651: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
58652: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58653: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58654: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 58651: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

58647: SELECT xet.event_id event_id
58648: , l4.line_number line_number
58649: , CASE r
58650: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
58651: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
58652: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58653: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58654: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58655: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 58652: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

58648: , l4.line_number line_number
58649: , CASE r
58650: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
58651: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
58652: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58653: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58654: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58655: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58656: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 58653: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

58649: , CASE r
58650: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
58651: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
58652: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58653: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58654: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58655: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58656: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
58657: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 58654: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

58650: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
58651: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
58652: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58653: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58654: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58655: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58656: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
58657: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
58658: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 58718: , AR_CUST_TRX_LINES_L_V l4

58714: END source_value
58715: , null source_meaning
58716: FROM xla_events_gt xet
58717: , AR_CUST_TRX_LINES_BASE_V l3
58718: , AR_CUST_TRX_LINES_L_V l4
58719: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
58720: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58721: AND xet.event_class_code = C_EVENT_CLASS_CODE
58722: AND l3.event_id = xet.event_id

Line 58866: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

58862: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
58863: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
58864: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
58865:
58866: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
58867: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58868: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
58869: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
58870: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 58867: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

58863: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
58864: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
58865:
58866: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
58867: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58868: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
58869: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
58870: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
58871: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 58868: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

58864: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
58865:
58866: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
58867: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58868: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
58869: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
58870: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
58871: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
58872: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 58869: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

58865:
58866: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
58867: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58868: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
58869: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
58870: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
58871: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
58872: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
58873: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 58870: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

58866: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
58867: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
58868: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
58869: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
58870: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
58871: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
58872: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
58873: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
58874: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 58985: , AR_CUST_TRX_LINES_L_V l4

58981: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
58982: , l3.TRX_LINE_ACCTD_AMT source_34
58983: FROM xla_events_gt xet
58984: , AR_CUST_TRX_LINES_BASE_V l3
58985: , AR_CUST_TRX_LINES_L_V l4
58986: WHERE xet.event_id between x_first_event_id and x_last_event_id
58987: and xet.event_date between p_pad_start_date and p_pad_end_date
58988: and xet.event_class_code = C_EVENT_CLASS_CODE
58989: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 59896: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

59892: FROM (
59893: SELECT xet.event_id event_id
59894: , l4.line_number line_number
59895: , CASE r
59896: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
59897: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
59898: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
59899: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
59900: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 59897: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

59893: SELECT xet.event_id event_id
59894: , l4.line_number line_number
59895: , CASE r
59896: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
59897: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
59898: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
59899: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
59900: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
59901: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 59898: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

59894: , l4.line_number line_number
59895: , CASE r
59896: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
59897: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
59898: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
59899: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
59900: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
59901: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
59902: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 59899: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

59895: , CASE r
59896: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
59897: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
59898: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
59899: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
59900: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
59901: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
59902: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
59903: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 59900: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

59896: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
59897: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
59898: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
59899: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
59900: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
59901: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
59902: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
59903: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
59904: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 59964: , AR_CUST_TRX_LINES_L_V l4

59960: END source_value
59961: , null source_meaning
59962: FROM xla_events_gt xet
59963: , AR_CUST_TRX_LINES_BASE_V l3
59964: , AR_CUST_TRX_LINES_L_V l4
59965: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
59966: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
59967: AND xet.event_class_code = C_EVENT_CLASS_CODE
59968: AND l3.event_id = xet.event_id

Line 60112: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

60108: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
60109: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60110: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60111:
60112: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60113: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60114: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60115: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60116: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 60113: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

60109: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60110: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60111:
60112: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60113: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60114: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60115: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60116: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60117: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 60114: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

60110: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60111:
60112: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60113: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60114: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60115: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60116: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60117: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60118: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 60115: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

60111:
60112: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60113: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60114: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60115: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60116: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60117: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60118: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
60119: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 60116: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

60112: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60113: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60114: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60115: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60116: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60117: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60118: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
60119: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60120: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 60231: , AR_CUST_TRX_LINES_L_V l4

60227: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_33
60228: , l3.TRX_LINE_ACCTD_AMT source_34
60229: FROM xla_events_gt xet
60230: , AR_CUST_TRX_LINES_BASE_V l3
60231: , AR_CUST_TRX_LINES_L_V l4
60232: WHERE xet.event_id between x_first_event_id and x_last_event_id
60233: and xet.event_date between p_pad_start_date and p_pad_end_date
60234: and xet.event_class_code = C_EVENT_CLASS_CODE
60235: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 61152: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

61148: FROM (
61149: SELECT xet.event_id event_id
61150: , l4.line_number line_number
61151: , CASE r
61152: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
61153: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
61154: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61155: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61156: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 61153: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

61149: SELECT xet.event_id event_id
61150: , l4.line_number line_number
61151: , CASE r
61152: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
61153: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
61154: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61155: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61156: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61157: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 61154: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

61150: , l4.line_number line_number
61151: , CASE r
61152: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
61153: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
61154: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61155: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61156: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61157: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61158: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 61155: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

61151: , CASE r
61152: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
61153: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
61154: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61155: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61156: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61157: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61158: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61159: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 61156: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

61152: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
61153: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
61154: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61155: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61156: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61157: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61158: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61159: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61160: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 61161: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

61157: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61158: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61159: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61160: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
61161: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
61162: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'
61163:
61164: ELSE null
61165: END object_name

Line 61230: , AR_CUST_TRX_LINES_L_V l4

61226: END source_value
61227: , null source_meaning
61228: FROM xla_events_gt xet
61229: , AR_CUST_TRX_LINES_BASE_V l3
61230: , AR_CUST_TRX_LINES_L_V l4
61231: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
61232: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61233: AND xet.event_class_code = C_EVENT_CLASS_CODE
61234: AND l3.event_id = xet.event_id

Line 61380: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

61376: TYPE t_array_source_75 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61377: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61378: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61379:
61380: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61381: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61382: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61383: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61384: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 61381: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

61377: TYPE t_array_source_76 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61378: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61379:
61380: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61381: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61382: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61383: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61384: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61385: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 61382: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

61378: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61379:
61380: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61381: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61382: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61383: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61384: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61385: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61386: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 61383: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

61379:
61380: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61381: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61382: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61383: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61384: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61385: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61386: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61387: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 61384: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

61380: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61381: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61382: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61383: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61384: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61385: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61386: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61387: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61388: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 61389: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

61385: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61386: TYPE t_array_source_32 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61387: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61388: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
61389: TYPE t_array_source_48 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
61390: TYPE t_array_source_49 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
61391:
61392: l_array_source_9 t_array_source_9;
61393: l_array_source_23 t_array_source_23;

Line 61509: , AR_CUST_TRX_LINES_L_V l4

61505: , l4.TRX_TAX_LINE_ID source_48
61506: , l3.ROUNDING_CORRECTION_FLAG source_49
61507: FROM xla_events_gt xet
61508: , AR_CUST_TRX_LINES_BASE_V l3
61509: , AR_CUST_TRX_LINES_L_V l4
61510: WHERE xet.event_id between x_first_event_id and x_last_event_id
61511: and xet.event_date between p_pad_start_date and p_pad_end_date
61512: and xet.event_class_code = C_EVENT_CLASS_CODE
61513: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 64209: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

64205: SELECT xet.event_id event_id
64206: , l4.line_number line_number
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'

Line 64220: WHEN 13 THEN 'AR_CUST_TRX_LINES_L_V'

64216: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
64217: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
64218: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
64219: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
64220: WHEN 13 THEN 'AR_CUST_TRX_LINES_L_V'
64221: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
64222: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'
64223: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64224: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64221: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'

64217: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
64218: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
64219: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
64220: WHEN 13 THEN 'AR_CUST_TRX_LINES_L_V'
64221: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
64222: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'
64223: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64224: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64225: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'

Line 64222: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'

64218: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
64219: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
64220: WHEN 13 THEN 'AR_CUST_TRX_LINES_L_V'
64221: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
64222: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'
64223: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64224: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64225: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'
64226: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'

Line 64370: , AR_CUST_TRX_LINES_L_V l2

64366: ELSE null
64367: END source_value
64368: , null source_meaning
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

Line 64539: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

64535: TYPE t_array_source_80 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64536: TYPE t_array_source_81 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
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;

Line 64550: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

64546: TYPE t_array_source_19 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64547: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64548: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64549: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64550: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
64551: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
64552: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64553: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64554: TYPE t_array_source_53 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 64551: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

64547: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64548: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64549: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64550: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
64551: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
64552: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64553: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64554: TYPE t_array_source_53 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64555: TYPE t_array_source_57 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 64552: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

64548: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64549: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64550: TYPE t_array_source_26 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
64551: TYPE t_array_source_27 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
64552: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64553: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64554: TYPE t_array_source_53 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64555: TYPE t_array_source_57 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
64556: TYPE t_array_source_58 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;

Line 64737: , AR_CUST_TRX_LINES_L_V l2

64733: , l3.DIST_TO_CUR_CONVERSION_TYPE source_65
64734: , l3.DIST_TO_CUR_CONVERSION_RATE source_66
64735: , l4.DIST_SOURCE_TABLE source_67
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