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

Line 54585: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

54581: FROM (
54582: SELECT xet.event_id event_id
54583: , l4.line_number line_number
54584: , CASE r
54585: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
54586: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
54587: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54588: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54589: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 54586: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

54582: SELECT xet.event_id event_id
54583: , l4.line_number line_number
54584: , CASE r
54585: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
54586: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
54587: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54588: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54589: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54590: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 54587: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

54583: , l4.line_number line_number
54584: , CASE r
54585: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
54586: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
54587: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54588: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54589: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54590: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54591: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 54588: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

54584: , CASE r
54585: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
54586: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
54587: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54588: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54589: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54590: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54591: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
54592: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 54589: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

54585: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
54586: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
54587: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
54588: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
54589: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
54590: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
54591: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
54592: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
54593: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 54653: , AR_CUST_TRX_LINES_L_V l4

54649: END source_value
54650: , null source_meaning
54651: FROM xla_events_gt xet
54652: , AR_CUST_TRX_LINES_BASE_V l3
54653: , AR_CUST_TRX_LINES_L_V l4
54654: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
54655: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
54656: AND xet.event_class_code = C_EVENT_CLASS_CODE
54657: AND l3.event_id = xet.event_id

Line 54801: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

54797: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
54798: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54799: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54800:
54801: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54802: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54803: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54804: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54805: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 54802: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

54798: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
54799: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54800:
54801: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54802: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54803: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54804: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54805: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54806: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 54803: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

54799: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
54800:
54801: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54802: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54803: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54804: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54805: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54806: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54807: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 54804: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

54800:
54801: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54802: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54803: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54804: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54805: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54806: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54807: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
54808: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 54805: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

54801: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
54802: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
54803: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
54804: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54805: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
54806: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
54807: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
54808: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
54809: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 54920: , AR_CUST_TRX_LINES_L_V l4

54916: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
54917: , l3.TRX_LINE_ACCTD_AMT source_36
54918: FROM xla_events_gt xet
54919: , AR_CUST_TRX_LINES_BASE_V l3
54920: , AR_CUST_TRX_LINES_L_V l4
54921: WHERE xet.event_id between x_first_event_id and x_last_event_id
54922: and xet.event_date between p_pad_start_date and p_pad_end_date
54923: and xet.event_class_code = C_EVENT_CLASS_CODE
54924: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 57460: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

57456: FROM (
57457: SELECT xet.event_id event_id
57458: , l4.line_number line_number
57459: , CASE r
57460: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
57461: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
57462: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57463: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57464: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 57461: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

57457: SELECT xet.event_id event_id
57458: , l4.line_number line_number
57459: , CASE r
57460: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
57461: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
57462: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57463: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57464: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57465: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 57462: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

57458: , l4.line_number line_number
57459: , CASE r
57460: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
57461: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
57462: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57463: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57464: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57465: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57466: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 57463: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

57459: , CASE r
57460: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
57461: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
57462: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57463: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57464: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57465: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57466: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57467: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 57464: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

57460: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
57461: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
57462: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
57463: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
57464: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
57465: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57466: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57467: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
57468: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 57469: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

57465: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
57466: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
57467: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
57468: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
57469: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
57470:
57471: ELSE null
57472: END object_name
57473: , CASE r

Line 57533: , AR_CUST_TRX_LINES_L_V l4

57529: END source_value
57530: , null source_meaning
57531: FROM xla_events_gt xet
57532: , AR_CUST_TRX_LINES_BASE_V l3
57533: , AR_CUST_TRX_LINES_L_V l4
57534: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
57535: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
57536: AND xet.event_class_code = C_EVENT_CLASS_CODE
57537: AND l3.event_id = xet.event_id

Line 57683: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

57679: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
57680: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57681: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57682:
57683: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57684: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57685: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57686: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57687: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 57684: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

57680: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
57681: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57682:
57683: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57684: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57685: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57686: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57687: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57688: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 57685: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

57681: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
57682:
57683: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57684: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57685: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57686: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57687: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57688: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57689: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 57686: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

57682:
57683: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57684: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57685: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57686: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57687: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57688: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57689: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57690: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 57687: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

57683: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
57684: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
57685: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
57686: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57687: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
57688: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57689: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57690: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57691: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 57692: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

57688: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
57689: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
57690: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
57691: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
57692: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
57693:
57694: l_array_source_8 t_array_source_8;
57695: l_array_source_25 t_array_source_25;
57696: l_array_source_26 t_array_source_26;

Line 57809: , AR_CUST_TRX_LINES_L_V l4

57805: , l3.TRX_LINE_ACCTD_AMT source_36
57806: , l4.TRX_TAX_LINE_ID source_50
57807: FROM xla_events_gt xet
57808: , AR_CUST_TRX_LINES_BASE_V l3
57809: , AR_CUST_TRX_LINES_L_V l4
57810: WHERE xet.event_id between x_first_event_id and x_last_event_id
57811: and xet.event_date between p_pad_start_date and p_pad_end_date
57812: and xet.event_class_code = C_EVENT_CLASS_CODE
57813: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 58921: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

58917: FROM (
58918: SELECT xet.event_id event_id
58919: , l4.line_number line_number
58920: , CASE r
58921: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
58922: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
58923: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58924: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58925: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 58922: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

58918: SELECT xet.event_id event_id
58919: , l4.line_number line_number
58920: , CASE r
58921: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
58922: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
58923: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58924: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58925: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58926: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 58923: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

58919: , l4.line_number line_number
58920: , CASE r
58921: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
58922: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
58923: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58924: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58925: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58926: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58927: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 58924: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

58920: , CASE r
58921: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
58922: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
58923: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58924: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58925: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58926: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58927: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
58928: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 58925: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

58921: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
58922: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
58923: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
58924: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
58925: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
58926: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
58927: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
58928: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
58929: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 58989: , AR_CUST_TRX_LINES_L_V l4

58985: END source_value
58986: , null source_meaning
58987: FROM xla_events_gt xet
58988: , AR_CUST_TRX_LINES_BASE_V l3
58989: , AR_CUST_TRX_LINES_L_V l4
58990: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
58991: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
58992: AND xet.event_class_code = C_EVENT_CLASS_CODE
58993: AND l3.event_id = xet.event_id

Line 59137: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

59133: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
59134: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
59135: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
59136:
59137: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
59138: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
59139: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
59140: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
59141: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 59138: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

59134: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
59135: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
59136:
59137: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
59138: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
59139: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
59140: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
59141: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
59142: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 59139: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

59135: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
59136:
59137: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
59138: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
59139: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
59140: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
59141: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
59142: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
59143: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 59140: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

59136:
59137: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
59138: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
59139: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
59140: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
59141: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
59142: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
59143: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
59144: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 59141: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

59137: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
59138: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
59139: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
59140: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
59141: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
59142: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
59143: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
59144: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
59145: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 59256: , AR_CUST_TRX_LINES_L_V l4

59252: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
59253: , l3.TRX_LINE_ACCTD_AMT source_36
59254: FROM xla_events_gt xet
59255: , AR_CUST_TRX_LINES_BASE_V l3
59256: , AR_CUST_TRX_LINES_L_V l4
59257: WHERE xet.event_id between x_first_event_id and x_last_event_id
59258: and xet.event_date between p_pad_start_date and p_pad_end_date
59259: and xet.event_class_code = C_EVENT_CLASS_CODE
59260: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 60167: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

60163: FROM (
60164: SELECT xet.event_id event_id
60165: , l4.line_number line_number
60166: , CASE r
60167: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
60168: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
60169: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
60170: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
60171: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 60168: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

60164: SELECT xet.event_id event_id
60165: , l4.line_number line_number
60166: , CASE r
60167: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
60168: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
60169: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
60170: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
60171: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
60172: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 60169: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

60165: , l4.line_number line_number
60166: , CASE r
60167: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
60168: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
60169: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
60170: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
60171: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
60172: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
60173: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 60170: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

60166: , CASE r
60167: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
60168: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
60169: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
60170: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
60171: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
60172: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
60173: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
60174: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 60171: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

60167: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
60168: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
60169: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
60170: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
60171: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
60172: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
60173: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
60174: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
60175: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 60235: , AR_CUST_TRX_LINES_L_V l4

60231: END source_value
60232: , null source_meaning
60233: FROM xla_events_gt xet
60234: , AR_CUST_TRX_LINES_BASE_V l3
60235: , AR_CUST_TRX_LINES_L_V l4
60236: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
60237: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
60238: AND xet.event_class_code = C_EVENT_CLASS_CODE
60239: AND l3.event_id = xet.event_id

Line 60383: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

60379: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
60380: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60381: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60382:
60383: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60384: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60385: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60386: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60387: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 60384: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

60380: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
60381: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60382:
60383: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60384: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60385: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60386: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60387: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60388: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 60385: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

60381: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
60382:
60383: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60384: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60385: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60386: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60387: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60388: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60389: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 60386: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

60382:
60383: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60384: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60385: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60386: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60387: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60388: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60389: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
60390: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 60387: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

60383: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
60384: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
60385: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
60386: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60387: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
60388: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
60389: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
60390: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
60391: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 60502: , AR_CUST_TRX_LINES_L_V l4

60498: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_35
60499: , l3.TRX_LINE_ACCTD_AMT source_36
60500: FROM xla_events_gt xet
60501: , AR_CUST_TRX_LINES_BASE_V l3
60502: , AR_CUST_TRX_LINES_L_V l4
60503: WHERE xet.event_id between x_first_event_id and x_last_event_id
60504: and xet.event_date between p_pad_start_date and p_pad_end_date
60505: and xet.event_class_code = C_EVENT_CLASS_CODE
60506: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 61423: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

61419: FROM (
61420: SELECT xet.event_id event_id
61421: , l4.line_number line_number
61422: , CASE r
61423: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
61424: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
61425: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61426: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61427: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 61424: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

61420: SELECT xet.event_id event_id
61421: , l4.line_number line_number
61422: , CASE r
61423: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
61424: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
61425: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61426: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61427: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61428: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 61425: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

61421: , l4.line_number line_number
61422: , CASE r
61423: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
61424: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
61425: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61426: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61427: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61428: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61429: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 61426: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

61422: , CASE r
61423: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
61424: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
61425: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61426: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61427: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61428: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61429: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61430: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 61427: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

61423: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
61424: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
61425: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
61426: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
61427: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
61428: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61429: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61430: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61431: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 61432: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

61428: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
61429: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
61430: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
61431: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
61432: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
61433: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'
61434:
61435: ELSE null
61436: END object_name

Line 61501: , AR_CUST_TRX_LINES_L_V l4

61497: END source_value
61498: , null source_meaning
61499: FROM xla_events_gt xet
61500: , AR_CUST_TRX_LINES_BASE_V l3
61501: , AR_CUST_TRX_LINES_L_V l4
61502: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
61503: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
61504: AND xet.event_class_code = C_EVENT_CLASS_CODE
61505: AND l3.event_id = xet.event_id

Line 61651: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

61647: TYPE t_array_source_77 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
61648: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61649: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61650:
61651: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61652: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61653: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61654: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61655: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 61652: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

61648: TYPE t_array_source_78 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
61649: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61650:
61651: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61652: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61653: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61654: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61655: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61656: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 61653: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

61649: TYPE t_array_source_79 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
61650:
61651: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61652: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61653: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61654: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61655: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61656: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61657: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 61654: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

61650:
61651: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61652: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61653: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61654: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61655: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61656: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61657: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61658: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 61655: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

61651: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
61652: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
61653: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
61654: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61655: TYPE t_array_source_31 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
61656: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61657: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61658: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61659: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 61660: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

61656: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
61657: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
61658: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
61659: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
61660: TYPE t_array_source_50 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
61661: TYPE t_array_source_51 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
61662:
61663: l_array_source_8 t_array_source_8;
61664: l_array_source_25 t_array_source_25;

Line 61780: , AR_CUST_TRX_LINES_L_V l4

61776: , l4.TRX_TAX_LINE_ID source_50
61777: , l3.ROUNDING_CORRECTION_FLAG source_51
61778: FROM xla_events_gt xet
61779: , AR_CUST_TRX_LINES_BASE_V l3
61780: , AR_CUST_TRX_LINES_L_V l4
61781: WHERE xet.event_id between x_first_event_id and x_last_event_id
61782: and xet.event_date between p_pad_start_date and p_pad_end_date
61783: and xet.event_class_code = C_EVENT_CLASS_CODE
61784: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 64490: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

64486: SELECT xet.event_id event_id
64487: , l4.line_number line_number
64488: , CASE r
64489: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
64490: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
64491: WHEN 3 THEN 'AR_DISTRIBUTIONS_L_V'
64492: WHEN 4 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
64493: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
64494: WHEN 6 THEN 'AR_DISTRIBUTIONS_L_V'

Line 64501: WHEN 13 THEN 'AR_CUST_TRX_LINES_L_V'

64497: WHEN 9 THEN 'AR_DISTRIBUTIONS_BASE_V'
64498: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
64499: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
64500: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
64501: WHEN 13 THEN 'AR_CUST_TRX_LINES_L_V'
64502: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
64503: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'
64504: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64505: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 64502: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'

64498: WHEN 10 THEN 'AR_DISTRIBUTIONS_BASE_V'
64499: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
64500: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
64501: WHEN 13 THEN 'AR_CUST_TRX_LINES_L_V'
64502: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
64503: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'
64504: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64505: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64506: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'

Line 64503: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'

64499: WHEN 11 THEN 'AR_DISTRIBUTIONS_BASE_V'
64500: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
64501: WHEN 13 THEN 'AR_CUST_TRX_LINES_L_V'
64502: WHEN 14 THEN 'AR_CUST_TRX_LINES_L_V'
64503: WHEN 15 THEN 'AR_CUST_TRX_LINES_L_V'
64504: WHEN 16 THEN 'AR_DISTRIBUTIONS_L_V'
64505: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
64506: WHEN 18 THEN 'AR_TRANSACTIONS_S_V'
64507: WHEN 19 THEN 'AR_TRANSACTIONS_S_V'

Line 64651: , AR_CUST_TRX_LINES_L_V l2

64647: ELSE null
64648: END source_value
64649: , null source_meaning
64650: FROM xla_events_gt xet
64651: , AR_CUST_TRX_LINES_L_V l2
64652: , AR_DISTRIBUTIONS_BASE_V l3
64653: , AR_DISTRIBUTIONS_L_V l4
64654: , AR_RECEIVABLES_TRX_ACT_S_V l7
64655: , AR_TRANSACTIONS_S_V l10

Line 64822: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

64818: TYPE t_array_source_82 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
64819: TYPE t_array_source_83 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
64820:
64821: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
64822: TYPE t_array_source_14 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
64823: TYPE t_array_source_15 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
64824: TYPE t_array_source_16 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
64825: TYPE t_array_source_17 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
64826: TYPE t_array_source_18 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 64833: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

64829: TYPE t_array_source_21 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64830: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64831: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64832: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64833: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
64834: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
64835: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64836: TYPE t_array_source_54 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64837: TYPE t_array_source_55 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 64834: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

64830: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
64831: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64832: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64833: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
64834: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
64835: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64836: TYPE t_array_source_54 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64837: TYPE t_array_source_55 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64838: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 64835: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

64831: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64832: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
64833: TYPE t_array_source_28 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
64834: TYPE t_array_source_29 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
64835: TYPE t_array_source_30 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
64836: TYPE t_array_source_54 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
64837: TYPE t_array_source_55 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
64838: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
64839: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;

Line 65024: , AR_CUST_TRX_LINES_L_V l2

65020: , l3.DIST_TO_CUR_CONVERSION_TYPE source_67
65021: , l3.DIST_TO_CUR_CONVERSION_RATE source_68
65022: , l4.DIST_SOURCE_TABLE source_69
65023: FROM xla_events_gt xet
65024: , AR_CUST_TRX_LINES_L_V l2
65025: , AR_DISTRIBUTIONS_BASE_V l3
65026: , AR_DISTRIBUTIONS_L_V l4
65027: , AR_RECEIVABLES_TRX_ACT_S_V l7
65028: , AR_TRANSACTIONS_S_V l10