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

Line 69546: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

69542: FROM (
69543: SELECT xet.event_id event_id
69544: , l4.line_number line_number
69545: , CASE r
69546: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
69547: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
69548: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69549: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69550: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 69547: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

69543: SELECT xet.event_id event_id
69544: , l4.line_number line_number
69545: , CASE r
69546: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
69547: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
69548: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69549: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69550: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69551: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 69548: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

69544: , l4.line_number line_number
69545: , CASE r
69546: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
69547: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
69548: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69549: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69550: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69551: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69552: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 69549: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

69545: , CASE r
69546: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
69547: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
69548: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69549: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69550: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69551: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69552: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
69553: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 69550: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

69546: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
69547: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
69548: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69549: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69550: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69551: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69552: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
69553: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
69554: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 69614: , AR_CUST_TRX_LINES_L_V l4

69610: END source_value
69611: , null source_meaning
69612: FROM xla_events_gt xet
69613: , AR_CUST_TRX_LINES_BASE_V l3
69614: , AR_CUST_TRX_LINES_L_V l4
69615: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
69616: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69617: AND xet.event_class_code = C_EVENT_CLASS_CODE
69618: AND l3.event_id = xet.event_id

Line 69764: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

69760: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
69761: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69762: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69763:
69764: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69765: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69766: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69767: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69768: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 69765: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

69761: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
69762: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69763:
69764: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69765: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69766: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69767: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69768: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69769: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 69766: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

69762: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69763:
69764: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69765: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69766: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69767: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69768: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69769: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69770: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 69767: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

69763:
69764: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69765: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69766: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69767: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69768: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69769: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69770: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69771: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 69768: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

69764: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69765: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69766: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69767: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69768: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69769: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69770: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69771: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69772: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 69887: , AR_CUST_TRX_LINES_L_V l4

69883: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
69884: , l3.TRX_LINE_ACCTD_AMT source_63
69885: FROM xla_events_gt xet
69886: , AR_CUST_TRX_LINES_BASE_V l3
69887: , AR_CUST_TRX_LINES_L_V l4
69888: WHERE xet.event_id between x_first_event_id and x_last_event_id
69889: and xet.event_date between p_pad_start_date and p_pad_end_date
69890: and xet.event_class_code = C_EVENT_CLASS_CODE
69891: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 74363: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

74359: FROM (
74360: SELECT xet.event_id event_id
74361: , l4.line_number line_number
74362: , CASE r
74363: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74364: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74365: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74366: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74367: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 74364: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

74360: SELECT xet.event_id event_id
74361: , l4.line_number line_number
74362: , CASE r
74363: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74364: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74365: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74366: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74367: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74368: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74365: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

74361: , l4.line_number line_number
74362: , CASE r
74363: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74364: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74365: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74366: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74367: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74368: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74369: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74366: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

74362: , CASE r
74363: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74364: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74365: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74366: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74367: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74368: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74369: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74370: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74367: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

74363: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74364: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74365: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74366: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74367: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74368: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74369: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74370: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74371: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74372: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

74368: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74369: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74370: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74371: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74372: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
74373:
74374: ELSE null
74375: END object_name
74376: , CASE r

Line 74436: , AR_CUST_TRX_LINES_L_V l4

74432: END source_value
74433: , null source_meaning
74434: FROM xla_events_gt xet
74435: , AR_CUST_TRX_LINES_BASE_V l3
74436: , AR_CUST_TRX_LINES_L_V l4
74437: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
74438: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
74439: AND xet.event_class_code = C_EVENT_CLASS_CODE
74440: AND l3.event_id = xet.event_id

Line 74586: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

74582: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
74583: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74584: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74585:
74586: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74587: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74588: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74589: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74590: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 74587: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

74583: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
74584: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74585:
74586: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74587: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74588: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74589: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74590: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74591: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 74588: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

74584: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74585:
74586: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74587: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74588: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74589: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74590: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74591: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74592: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 74589: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

74585:
74586: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74587: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74588: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74589: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74590: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74591: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74592: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
74593: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 74590: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

74586: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
74587: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
74588: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74589: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74590: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74591: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74592: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
74593: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74594: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 74595: TYPE t_array_source_97 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

74591: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74592: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
74593: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74594: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
74595: TYPE t_array_source_97 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
74596:
74597: l_array_source_3 t_array_source_3;
74598: l_array_source_4 t_array_source_4;
74599: l_array_source_5 t_array_source_5;

Line 74712: , AR_CUST_TRX_LINES_L_V l4

74708: , l3.TRX_LINE_ACCTD_AMT source_63
74709: , l4.TRX_TAX_LINE_ID source_97
74710: FROM xla_events_gt xet
74711: , AR_CUST_TRX_LINES_BASE_V l3
74712: , AR_CUST_TRX_LINES_L_V l4
74713: WHERE xet.event_id between x_first_event_id and x_last_event_id
74714: and xet.event_date between p_pad_start_date and p_pad_end_date
74715: and xet.event_class_code = C_EVENT_CLASS_CODE
74716: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 75876: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

75872: FROM (
75873: SELECT xet.event_id event_id
75874: , l4.line_number line_number
75875: , CASE r
75876: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
75877: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
75878: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75879: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75880: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 75877: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

75873: SELECT xet.event_id event_id
75874: , l4.line_number line_number
75875: , CASE r
75876: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
75877: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
75878: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75879: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75880: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75881: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 75878: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

75874: , l4.line_number line_number
75875: , CASE r
75876: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
75877: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
75878: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75879: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75880: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75881: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
75882: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 75879: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

75875: , CASE r
75876: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
75877: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
75878: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75879: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75880: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75881: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
75882: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75883: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 75880: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

75876: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
75877: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
75878: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75879: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75880: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75881: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
75882: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75883: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75884: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 75944: , AR_CUST_TRX_LINES_L_V l4

75940: END source_value
75941: , null source_meaning
75942: FROM xla_events_gt xet
75943: , AR_CUST_TRX_LINES_BASE_V l3
75944: , AR_CUST_TRX_LINES_L_V l4
75945: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
75946: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
75947: AND xet.event_class_code = C_EVENT_CLASS_CODE
75948: AND l3.event_id = xet.event_id

Line 76094: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

76090: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
76091: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76092: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76093:
76094: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76095: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76096: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76097: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76098: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 76095: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

76091: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
76092: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76093:
76094: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76095: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76096: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76097: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76098: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76099: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 76096: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

76092: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76093:
76094: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76095: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76096: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76097: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76098: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76099: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76100: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 76097: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

76093:
76094: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76095: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76096: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76097: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76098: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76099: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76100: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76101: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 76098: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

76094: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76095: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76096: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76097: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76098: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76099: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76100: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76101: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76102: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 76217: , AR_CUST_TRX_LINES_L_V l4

76213: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
76214: , l3.TRX_LINE_ACCTD_AMT source_63
76215: FROM xla_events_gt xet
76216: , AR_CUST_TRX_LINES_BASE_V l3
76217: , AR_CUST_TRX_LINES_L_V l4
76218: WHERE xet.event_id between x_first_event_id and x_last_event_id
76219: and xet.event_date between p_pad_start_date and p_pad_end_date
76220: and xet.event_class_code = C_EVENT_CLASS_CODE
76221: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 78975: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

78971: FROM (
78972: SELECT xet.event_id event_id
78973: , l4.line_number line_number
78974: , CASE r
78975: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
78976: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
78977: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
78978: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
78979: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 78976: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

78972: SELECT xet.event_id event_id
78973: , l4.line_number line_number
78974: , CASE r
78975: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
78976: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
78977: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
78978: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
78979: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
78980: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 78977: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

78973: , l4.line_number line_number
78974: , CASE r
78975: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
78976: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
78977: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
78978: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
78979: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
78980: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
78981: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 78978: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

78974: , CASE r
78975: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
78976: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
78977: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
78978: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
78979: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
78980: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
78981: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
78982: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 78979: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

78975: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
78976: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
78977: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
78978: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
78979: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
78980: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
78981: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
78982: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
78983: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 79043: , AR_CUST_TRX_LINES_L_V l4

79039: END source_value
79040: , null source_meaning
79041: FROM xla_events_gt xet
79042: , AR_CUST_TRX_LINES_BASE_V l3
79043: , AR_CUST_TRX_LINES_L_V l4
79044: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
79045: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79046: AND xet.event_class_code = C_EVENT_CLASS_CODE
79047: AND l3.event_id = xet.event_id

Line 79193: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

79189: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
79190: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79191: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79192:
79193: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
79194: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79195: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79196: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79197: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 79194: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

79190: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79191: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79192:
79193: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
79194: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79195: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79196: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79197: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
79198: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 79195: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

79191: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
79192:
79193: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
79194: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79195: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79196: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79197: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
79198: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79199: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 79196: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

79192:
79193: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
79194: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79195: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79196: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79197: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
79198: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79199: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79200: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79197: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

79193: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
79194: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79195: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79196: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79197: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
79198: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79199: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79200: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79201: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 79316: , AR_CUST_TRX_LINES_L_V l4

79312: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_62
79313: , l3.TRX_LINE_ACCTD_AMT source_63
79314: FROM xla_events_gt xet
79315: , AR_CUST_TRX_LINES_BASE_V l3
79316: , AR_CUST_TRX_LINES_L_V l4
79317: WHERE xet.event_id between x_first_event_id and x_last_event_id
79318: and xet.event_date between p_pad_start_date and p_pad_end_date
79319: and xet.event_class_code = C_EVENT_CLASS_CODE
79320: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 80253: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

80249: FROM (
80250: SELECT xet.event_id event_id
80251: , l4.line_number line_number
80252: , CASE r
80253: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
80254: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
80255: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
80256: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
80257: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 80254: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

80250: SELECT xet.event_id event_id
80251: , l4.line_number line_number
80252: , CASE r
80253: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
80254: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
80255: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
80256: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
80257: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
80258: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 80255: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

80251: , l4.line_number line_number
80252: , CASE r
80253: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
80254: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
80255: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
80256: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
80257: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
80258: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
80259: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 80256: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

80252: , CASE r
80253: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
80254: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
80255: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
80256: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
80257: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
80258: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
80259: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
80260: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 80257: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

80253: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
80254: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
80255: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
80256: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
80257: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
80258: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
80259: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
80260: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
80261: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 80262: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

80258: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
80259: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
80260: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
80261: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
80262: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
80263: WHEN 11 THEN 'AR_CUST_TRX_LINES_BASE_V'
80264:
80265: ELSE null
80266: END object_name

Line 80331: , AR_CUST_TRX_LINES_L_V l4

80327: END source_value
80328: , null source_meaning
80329: FROM xla_events_gt xet
80330: , AR_CUST_TRX_LINES_BASE_V l3
80331: , AR_CUST_TRX_LINES_L_V l4
80332: , (select rownum r from all_objects where rownum <= 11 and owner = p_apps_owner)
80333: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80334: AND xet.event_class_code = C_EVENT_CLASS_CODE
80335: AND l3.event_id = xet.event_id

Line 80481: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

80477: TYPE t_array_source_51 IS TABLE OF AR_TRANSACTIONS_S_V.XLA_PARTY_TYPE%TYPE INDEX BY BINARY_INTEGER;
80478: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
80479: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
80480:
80481: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
80482: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
80483: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
80484: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80485: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 80482: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

80478: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
80479: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
80480:
80481: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
80482: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
80483: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
80484: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80485: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
80486: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 80483: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

80479: TYPE t_array_source_120 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
80480:
80481: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
80482: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
80483: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
80484: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80485: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
80486: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
80487: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 80484: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

80480:
80481: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
80482: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
80483: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
80484: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80485: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
80486: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
80487: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
80488: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 80485: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

80481: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
80482: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
80483: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
80484: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80485: TYPE t_array_source_58 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
80486: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
80487: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
80488: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80489: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 80490: TYPE t_array_source_97 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

80486: TYPE t_array_source_60 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
80487: TYPE t_array_source_61 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
80488: TYPE t_array_source_62 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
80489: TYPE t_array_source_63 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
80490: TYPE t_array_source_97 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
80491: TYPE t_array_source_98 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
80492:
80493: l_array_source_3 t_array_source_3;
80494: l_array_source_4 t_array_source_4;

Line 80610: , AR_CUST_TRX_LINES_L_V l4

80606: , l4.TRX_TAX_LINE_ID source_97
80607: , l3.ROUNDING_CORRECTION_FLAG source_98
80608: FROM xla_events_gt xet
80609: , AR_CUST_TRX_LINES_BASE_V l3
80610: , AR_CUST_TRX_LINES_L_V l4
80611: WHERE xet.event_id between x_first_event_id and x_last_event_id
80612: and xet.event_date between p_pad_start_date and p_pad_end_date
80613: and xet.event_class_code = C_EVENT_CLASS_CODE
80614: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 83414: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'

83410: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
83411: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
83412: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
83413: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
83414: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
83415: WHEN 18 THEN 'AR_CUST_TRX_LINES_L_V'
83416: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'
83417: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
83418: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'

Line 83415: WHEN 18 THEN 'AR_CUST_TRX_LINES_L_V'

83411: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
83412: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
83413: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
83414: WHEN 17 THEN 'AR_CUST_TRX_LINES_L_V'
83415: WHEN 18 THEN 'AR_CUST_TRX_LINES_L_V'
83416: WHEN 19 THEN 'AR_DISTRIBUTIONS_L_V'
83417: WHEN 20 THEN 'AR_DISTRIBUTIONS_BASE_V'
83418: WHEN 21 THEN 'AR_TRANSACTIONS_S_V'
83419: WHEN 22 THEN 'AR_TRANSACTIONS_S_V'

Line 83570: , AR_CUST_TRX_LINES_L_V l2

83566: ELSE null
83567: END source_value
83568: , null source_meaning
83569: FROM xla_events_gt xet
83570: , AR_CUST_TRX_LINES_L_V l2
83571: , AR_DISTRIBUTIONS_BASE_V l3
83572: , AR_DISTRIBUTIONS_L_V l4
83573: , AR_RECEIVABLES_TRX_ACT_S_V l7
83574: , AR_TRANSACTIONS_S_V l10

Line 83756: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

83752: TYPE t_array_source_46 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
83753: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83754: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83755: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83756: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
83757: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83758: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
83759: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83760: TYPE t_array_source_102 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 83757: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

83753: TYPE t_array_source_47 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83754: TYPE t_array_source_48 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83755: TYPE t_array_source_52 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
83756: TYPE t_array_source_56 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
83757: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
83758: TYPE t_array_source_99 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
83759: TYPE t_array_source_100 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
83760: TYPE t_array_source_102 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
83761: TYPE t_array_source_103 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;

Line 83949: , AR_CUST_TRX_LINES_L_V l2

83945: , l3.DIST_TO_CUR_CONVERSION_TYPE source_109
83946: , l3.DIST_TO_CUR_CONVERSION_RATE source_110
83947: , l4.DIST_SOURCE_TABLE source_111
83948: FROM xla_events_gt xet
83949: , AR_CUST_TRX_LINES_L_V l2
83950: , AR_DISTRIBUTIONS_BASE_V l3
83951: , AR_DISTRIBUTIONS_L_V l4
83952: , AR_RECEIVABLES_TRX_ACT_S_V l7
83953: , AR_TRANSACTIONS_S_V l10