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

Line 70442: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

70438: FROM (
70439: SELECT xet.event_id event_id
70440: , l4.line_number line_number
70441: , CASE r
70442: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
70443: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
70444: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
70445: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
70446: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 70443: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

70439: SELECT xet.event_id event_id
70440: , l4.line_number line_number
70441: , CASE r
70442: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
70443: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
70444: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
70445: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
70446: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
70447: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 70444: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

70440: , l4.line_number line_number
70441: , CASE r
70442: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
70443: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
70444: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
70445: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
70446: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
70447: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
70448: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 70445: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

70441: , CASE r
70442: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
70443: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
70444: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
70445: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
70446: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
70447: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
70448: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
70449: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 70446: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

70442: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
70443: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
70444: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
70445: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
70446: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
70447: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
70448: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
70449: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
70450: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 70510: , AR_CUST_TRX_LINES_L_V l4

70506: END source_value
70507: , null source_meaning
70508: FROM xla_events_gt xet
70509: , AR_CUST_TRX_LINES_BASE_V l3
70510: , AR_CUST_TRX_LINES_L_V l4
70511: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
70512: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
70513: AND xet.event_class_code = C_EVENT_CLASS_CODE
70514: AND l3.event_id = xet.event_id

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

70654: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
70655: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
70656: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
70657:
70658: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70659: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70660: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
70661: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70662: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

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

70655: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
70656: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
70657:
70658: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70659: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70660: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
70661: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70662: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70663: 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 70660: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

70656: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
70657:
70658: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70659: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70660: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
70661: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70662: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70663: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
70664: 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 70661: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

70657:
70658: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70659: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70660: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
70661: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70662: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70663: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
70664: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
70665: 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 70662: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

70658: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
70659: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
70660: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
70661: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70662: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
70663: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
70664: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
70665: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
70666: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 70777: , AR_CUST_TRX_LINES_L_V l4

70773: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
70774: , l3.TRX_LINE_ACCTD_AMT source_41
70775: FROM xla_events_gt xet
70776: , AR_CUST_TRX_LINES_BASE_V l3
70777: , AR_CUST_TRX_LINES_L_V l4
70778: WHERE xet.event_id between x_first_event_id and x_last_event_id
70779: and xet.event_date between p_pad_start_date and p_pad_end_date
70780: and xet.event_class_code = C_EVENT_CLASS_CODE
70781: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 73317: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

73313: FROM (
73314: SELECT xet.event_id event_id
73315: , l4.line_number line_number
73316: , CASE r
73317: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
73318: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
73319: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73320: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73321: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 73318: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

73314: SELECT xet.event_id event_id
73315: , l4.line_number line_number
73316: , CASE r
73317: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
73318: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
73319: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73320: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73321: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73322: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 73319: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

73315: , l4.line_number line_number
73316: , CASE r
73317: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
73318: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
73319: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73320: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73321: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73322: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73323: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 73320: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

73316: , CASE r
73317: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
73318: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
73319: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73320: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73321: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73322: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73323: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
73324: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 73321: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

73317: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
73318: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
73319: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73320: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73321: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73322: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73323: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
73324: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
73325: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 73326: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

73322: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73323: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
73324: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
73325: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
73326: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
73327:
73328: ELSE null
73329: END object_name
73330: , CASE r

Line 73390: , AR_CUST_TRX_LINES_L_V l4

73386: END source_value
73387: , null source_meaning
73388: FROM xla_events_gt xet
73389: , AR_CUST_TRX_LINES_BASE_V l3
73390: , AR_CUST_TRX_LINES_L_V l4
73391: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
73392: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73393: AND xet.event_class_code = C_EVENT_CLASS_CODE
73394: AND l3.event_id = xet.event_id

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

73536: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73537: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73538: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73539:
73540: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73541: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73542: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73543: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73544: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

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

73537: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73538: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73539:
73540: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73541: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73542: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73543: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73544: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73545: 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 73542: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

73538: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73539:
73540: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73541: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73542: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73543: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73544: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73545: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73546: 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 73543: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

73539:
73540: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73541: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73542: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73543: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73544: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73545: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73546: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73547: 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 73544: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

73540: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73541: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73542: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73543: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73544: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73545: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73546: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73547: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73548: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

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

73545: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73546: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73547: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73548: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73549: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
73550:
73551: l_array_source_16 t_array_source_16;
73552: l_array_source_30 t_array_source_30;
73553: l_array_source_31 t_array_source_31;

Line 73666: , AR_CUST_TRX_LINES_L_V l4

73662: , l3.TRX_LINE_ACCTD_AMT source_41
73663: , l4.TRX_TAX_LINE_ID source_55
73664: FROM xla_events_gt xet
73665: , AR_CUST_TRX_LINES_BASE_V l3
73666: , AR_CUST_TRX_LINES_L_V l4
73667: WHERE xet.event_id between x_first_event_id and x_last_event_id
73668: and xet.event_date between p_pad_start_date and p_pad_end_date
73669: and xet.event_class_code = C_EVENT_CLASS_CODE
73670: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 74778: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

74774: FROM (
74775: SELECT xet.event_id event_id
74776: , l4.line_number line_number
74777: , CASE r
74778: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74779: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74780: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74781: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74782: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 74779: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

74775: SELECT xet.event_id event_id
74776: , l4.line_number line_number
74777: , CASE r
74778: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74779: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74780: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74781: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74782: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74783: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74780: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

74776: , l4.line_number line_number
74777: , CASE r
74778: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74779: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74780: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74781: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74782: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74783: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74784: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74781: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

74777: , CASE r
74778: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74779: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74780: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74781: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74782: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74783: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74784: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74785: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74782: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

74778: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74779: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74780: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74781: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74782: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74783: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74784: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74785: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74786: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74846: , AR_CUST_TRX_LINES_L_V l4

74842: END source_value
74843: , null source_meaning
74844: FROM xla_events_gt xet
74845: , AR_CUST_TRX_LINES_BASE_V l3
74846: , AR_CUST_TRX_LINES_L_V l4
74847: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
74848: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74849: AND xet.event_class_code = C_EVENT_CLASS_CODE
74850: AND l3.event_id = xet.event_id

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

74990: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74991: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74992: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74993:
74994: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74995: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

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

74991: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74992: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74993:
74994: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74995: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74999: 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 74996: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

74992: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74993:
74994: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74995: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75000: 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 74997: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

74993:
74994: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74995: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75000: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75001: 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 74998: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

74994: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74995: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74998: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74999: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75000: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75001: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 75113: , AR_CUST_TRX_LINES_L_V l4

75109: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
75110: , l3.TRX_LINE_ACCTD_AMT source_41
75111: FROM xla_events_gt xet
75112: , AR_CUST_TRX_LINES_BASE_V l3
75113: , AR_CUST_TRX_LINES_L_V l4
75114: WHERE xet.event_id between x_first_event_id and x_last_event_id
75115: and xet.event_date between p_pad_start_date and p_pad_end_date
75116: and xet.event_class_code = C_EVENT_CLASS_CODE
75117: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 76024: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

76020: FROM (
76021: SELECT xet.event_id event_id
76022: , l4.line_number line_number
76023: , CASE r
76024: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
76025: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
76026: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76027: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76028: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 76025: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

76021: SELECT xet.event_id event_id
76022: , l4.line_number line_number
76023: , CASE r
76024: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
76025: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
76026: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76027: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76028: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76029: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 76026: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

76022: , l4.line_number line_number
76023: , CASE r
76024: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
76025: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
76026: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76027: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76028: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76029: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
76030: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 76027: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

76023: , CASE r
76024: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
76025: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
76026: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76027: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76028: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76029: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
76030: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76031: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 76028: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

76024: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
76025: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
76026: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76027: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76028: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76029: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
76030: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76031: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76032: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 76092: , AR_CUST_TRX_LINES_L_V l4

76088: END source_value
76089: , null source_meaning
76090: FROM xla_events_gt xet
76091: , AR_CUST_TRX_LINES_BASE_V l3
76092: , AR_CUST_TRX_LINES_L_V l4
76093: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
76094: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76095: AND xet.event_class_code = C_EVENT_CLASS_CODE
76096: AND l3.event_id = xet.event_id

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

76236: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76237: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76238: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76239:
76240: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76241: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76242: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76243: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76244: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

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

76237: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76238: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76239:
76240: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76241: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76242: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76243: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76244: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76245: 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 76242: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

76238: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76239:
76240: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76241: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76242: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76243: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76244: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76245: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76246: 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 76243: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

76239:
76240: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76241: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76242: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76243: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76244: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76245: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76246: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76247: 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 76244: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

76240: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76241: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76242: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76243: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76244: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76245: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76246: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76247: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76248: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 76359: , AR_CUST_TRX_LINES_L_V l4

76355: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
76356: , l3.TRX_LINE_ACCTD_AMT source_41
76357: FROM xla_events_gt xet
76358: , AR_CUST_TRX_LINES_BASE_V l3
76359: , AR_CUST_TRX_LINES_L_V l4
76360: WHERE xet.event_id between x_first_event_id and x_last_event_id
76361: and xet.event_date between p_pad_start_date and p_pad_end_date
76362: and xet.event_class_code = C_EVENT_CLASS_CODE
76363: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 77285: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

77281: FROM (
77282: SELECT xet.event_id event_id
77283: , l4.line_number line_number
77284: , CASE r
77285: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
77286: WHEN 2 THEN 'FV_XLA_AR_REF_V'
77287: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
77288: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
77289: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 77287: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

77283: , l4.line_number line_number
77284: , CASE r
77285: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
77286: WHEN 2 THEN 'FV_XLA_AR_REF_V'
77287: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
77288: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
77289: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
77290: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
77291: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 77288: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

77284: , CASE r
77285: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
77286: WHEN 2 THEN 'FV_XLA_AR_REF_V'
77287: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
77288: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
77289: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
77290: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
77291: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
77292: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 77289: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

77285: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
77286: WHEN 2 THEN 'FV_XLA_AR_REF_V'
77287: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
77288: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
77289: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
77290: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
77291: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
77292: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
77293: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 77290: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'

77286: WHEN 2 THEN 'FV_XLA_AR_REF_V'
77287: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
77288: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
77289: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
77290: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
77291: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
77292: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
77293: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
77294: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 77295: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'

77291: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
77292: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
77293: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
77294: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
77295: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
77296: WHEN 12 THEN 'FV_XLA_AR_REF_V'
77297: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'
77298:
77299: ELSE null

Line 77373: , AR_CUST_TRX_LINES_L_V l4

77369: END source_value
77370: , null source_meaning
77371: FROM xla_events_gt xet
77372: , AR_CUST_TRX_LINES_BASE_V l3
77373: , AR_CUST_TRX_LINES_L_V l4
77374: , FV_XLA_AR_REF_V l6
77375: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
77376: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77377: AND xet.event_class_code = C_EVENT_CLASS_CODE

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

77521: TYPE t_array_source_83 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77522: TYPE t_array_source_84 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
77523: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77524:
77525: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
77526: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77527: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77528: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
77529: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

77523: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77524:
77525: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
77526: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77527: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77528: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
77529: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77530: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
77531: 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 77528: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

77524:
77525: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
77526: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77527: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77528: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
77529: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77530: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
77531: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77532: 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 77529: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

77525: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
77526: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77527: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77528: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
77529: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77530: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
77531: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77532: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77533: 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 77530: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

77526: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77527: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
77528: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
77529: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77530: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
77531: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77532: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77533: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77534: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

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

77531: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77532: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77533: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77534: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77535: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77536: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
77537: TYPE t_array_source_66 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
77538:
77539: l_array_source_6 t_array_source_6;

Line 77662: , AR_CUST_TRX_LINES_L_V l4

77658: , l6.FEDERAL_ACCOUNT_VALID_FLAG source_56
77659: , l3.ROUNDING_CORRECTION_FLAG source_66
77660: FROM xla_events_gt xet
77661: , AR_CUST_TRX_LINES_BASE_V l3
77662: , AR_CUST_TRX_LINES_L_V l4
77663: , FV_XLA_AR_REF_V l6
77664: WHERE xet.event_id between x_first_event_id and x_last_event_id
77665: and xet.event_date between p_pad_start_date and p_pad_end_date
77666: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 80757: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

80753: SELECT xet.event_id event_id
80754: , l5.line_number line_number
80755: , CASE r
80756: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
80757: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
80758: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80759: WHEN 4 THEN 'FV_XLA_AR_REF_V'
80760: WHEN 5 THEN 'FV_XLA_AR_REF_V'
80761: WHEN 6 THEN 'FV_XLA_AR_REF_V'

Line 80774: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'

80770: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
80771: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
80772: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
80773: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
80774: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
80775: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
80776: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
80777: WHEN 22 THEN 'FV_XLA_AR_REF_V'
80778: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 80775: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'

80771: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
80772: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
80773: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
80774: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
80775: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
80776: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
80777: WHEN 22 THEN 'FV_XLA_AR_REF_V'
80778: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'
80779: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'

Line 80776: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'

80772: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
80773: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
80774: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
80775: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
80776: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
80777: WHEN 22 THEN 'FV_XLA_AR_REF_V'
80778: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'
80779: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'
80780: WHEN 25 THEN 'AR_TRANSACTIONS_S_V'

Line 80954: , AR_CUST_TRX_LINES_L_V l3

80950: END source_value
80951: , null source_meaning
80952: FROM xla_events_gt xet
80953: , AR_BILL_TO_CUSTOMERS_S_V l1
80954: , AR_CUST_TRX_LINES_L_V l3
80955: , AR_DISTRIBUTIONS_BASE_V l4
80956: , AR_DISTRIBUTIONS_L_V l5
80957: , AR_RECEIVABLES_TRX_ACT_S_V l8
80958: , AR_TRANSACTIONS_S_V l11

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

81122: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
81123: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
81124:
81125: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
81126: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
81127: TYPE t_array_source_6 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
81128: TYPE t_array_source_7 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
81129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
81130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

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

81139: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
81140: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
81141: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81142: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
81143: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
81144: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
81145: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81146: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
81147: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

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

81140: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
81141: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81142: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
81143: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
81144: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
81145: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81146: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
81147: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
81148: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

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

81141: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81142: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
81143: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
81144: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
81145: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
81146: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
81147: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
81148: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
81149: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;

Line 81346: , AR_CUST_TRX_LINES_L_V l3

81342: , l4.DIST_TO_CUR_CONVERSION_TYPE source_74
81343: , l5.DIST_SOURCE_TABLE source_75
81344: FROM xla_events_gt xet
81345: , AR_BILL_TO_CUSTOMERS_S_V l1
81346: , AR_CUST_TRX_LINES_L_V l3
81347: , AR_DISTRIBUTIONS_BASE_V l4
81348: , AR_DISTRIBUTIONS_L_V l5
81349: , AR_RECEIVABLES_TRX_ACT_S_V l8
81350: , AR_TRANSACTIONS_S_V l11