eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00222_AAD_S_000005_PKG dependencies on AR_CUST_TRX_LINES_BASE_V

Line 68326: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

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

Line 68327: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

68323: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
68324: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
68325: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
68326: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
68327: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
68328: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
68329: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
68330:
68331: ELSE null

Line 68328: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

68324: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
68325: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
68326: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
68327: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
68328: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
68329: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
68330:
68331: ELSE null
68332: END object_name

Line 68329: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

68325: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
68326: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
68327: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
68328: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
68329: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
68330:
68331: ELSE null
68332: END object_name
68333: , CASE r

Line 68388: , AR_CUST_TRX_LINES_BASE_V l3

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

Line 68542: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

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

Line 68543: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

68539: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
68540: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68541: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
68542: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68543: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68544: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68545: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
68546:
68547: l_array_source_3 t_array_source_3;

Line 68544: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

68540: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68541: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
68542: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68543: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68544: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68545: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
68546:
68547: l_array_source_3 t_array_source_3;
68548: l_array_source_30 t_array_source_30;

Line 68545: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

68541: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
68542: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
68543: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
68544: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
68545: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
68546:
68547: l_array_source_3 t_array_source_3;
68548: l_array_source_30 t_array_source_30;
68549: l_array_source_31 t_array_source_31;

Line 68655: , AR_CUST_TRX_LINES_BASE_V l3

68651: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
68652: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
68653: , l3.TRX_LINE_ACCTD_AMT source_41
68654: FROM xla_events_gt xet
68655: , AR_CUST_TRX_LINES_BASE_V l3
68656: , AR_CUST_TRX_LINES_L_V l4
68657: WHERE xet.event_id between x_first_event_id and x_last_event_id
68658: and xet.event_date between p_pad_start_date and p_pad_end_date
68659: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 71304: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

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

Line 71305: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

71301: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
71302: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
71303: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
71304: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
71305: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
71306: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
71307: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
71308: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
71309:

Line 71306: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

71302: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
71303: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
71304: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
71305: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
71306: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
71307: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
71308: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
71309:
71310: ELSE null

Line 71307: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

71303: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
71304: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
71305: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
71306: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
71307: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
71308: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
71309:
71310: ELSE null
71311: END object_name

Line 71371: , AR_CUST_TRX_LINES_BASE_V l3

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

Line 71525: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

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

Line 71526: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

71522: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
71523: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71524: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
71525: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
71526: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
71527: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71528: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
71529: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
71530:

Line 71527: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

71523: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71524: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
71525: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
71526: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
71527: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
71528: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
71529: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
71530:
71531: l_array_source_3 t_array_source_3;

Line 71528: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

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

Line 71641: , AR_CUST_TRX_LINES_BASE_V l3

71637: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
71638: , l3.TRX_LINE_ACCTD_AMT source_41
71639: , l4.TRX_TAX_LINE_ID source_55
71640: FROM xla_events_gt xet
71641: , AR_CUST_TRX_LINES_BASE_V l3
71642: , AR_CUST_TRX_LINES_L_V l4
71643: WHERE xet.event_id between x_first_event_id and x_last_event_id
71644: and xet.event_date between p_pad_start_date and p_pad_end_date
71645: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 72785: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

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

Line 72786: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

72782: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72783: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72784: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72785: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72786: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72787: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72788: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
72789:
72790: ELSE null

Line 72787: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

72783: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72784: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72785: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72786: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72787: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72788: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
72789:
72790: ELSE null
72791: END object_name

Line 72788: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

72784: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72785: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72786: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72787: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72788: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
72789:
72790: ELSE null
72791: END object_name
72792: , CASE r

Line 72847: , AR_CUST_TRX_LINES_BASE_V l3

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

Line 73001: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

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

Line 73002: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

72998: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72999: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73000: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73001: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73002: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73003: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73004: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73005:
73006: l_array_source_3 t_array_source_3;

Line 73003: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

72999: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73000: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73001: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73002: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73003: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73004: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73005:
73006: l_array_source_3 t_array_source_3;
73007: l_array_source_30 t_array_source_30;

Line 73004: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

73000: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73001: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73002: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73003: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73004: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
73005:
73006: l_array_source_3 t_array_source_3;
73007: l_array_source_30 t_array_source_30;
73008: l_array_source_31 t_array_source_31;

Line 73114: , AR_CUST_TRX_LINES_BASE_V l3

73110: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
73111: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
73112: , l3.TRX_LINE_ACCTD_AMT source_41
73113: FROM xla_events_gt xet
73114: , AR_CUST_TRX_LINES_BASE_V l3
73115: , AR_CUST_TRX_LINES_L_V l4
73116: WHERE xet.event_id between x_first_event_id and x_last_event_id
73117: and xet.event_date between p_pad_start_date and p_pad_end_date
73118: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 74031: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

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

Line 74032: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

74028: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74029: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74030: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74031: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74032: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74033: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74034: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74035:
74036: ELSE null

Line 74033: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

74029: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74030: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74031: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74032: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74033: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74034: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74035:
74036: ELSE null
74037: END object_name

Line 74034: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

74030: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74031: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74032: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74033: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74034: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
74035:
74036: ELSE null
74037: END object_name
74038: , CASE r

Line 74093: , AR_CUST_TRX_LINES_BASE_V l3

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

Line 74247: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

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

Line 74248: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

74244: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
74245: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74246: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74247: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74248: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
74249: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74250: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
74251:
74252: l_array_source_3 t_array_source_3;

Line 74249: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

74245: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74246: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74247: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74248: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
74249: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74250: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
74251:
74252: l_array_source_3 t_array_source_3;
74253: l_array_source_30 t_array_source_30;

Line 74250: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

74246: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
74247: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
74248: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
74249: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
74250: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
74251:
74252: l_array_source_3 t_array_source_3;
74253: l_array_source_30 t_array_source_30;
74254: l_array_source_31 t_array_source_31;

Line 74360: , AR_CUST_TRX_LINES_BASE_V l3

74356: , l3.TRX_LINE_CUR_CONVERSION_RATE source_39
74357: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_40
74358: , l3.TRX_LINE_ACCTD_AMT source_41
74359: FROM xla_events_gt xet
74360: , AR_CUST_TRX_LINES_BASE_V l3
74361: , AR_CUST_TRX_LINES_L_V l4
74362: WHERE xet.event_id between x_first_event_id and x_last_event_id
74363: and xet.event_date between p_pad_start_date and p_pad_end_date
74364: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 75288: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

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

Line 75289: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

75285: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75286: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75287: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
75288: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75289: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75290: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
75291: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
75292: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
75293: WHEN 12 THEN 'FV_XLA_AR_REF_V'

Line 75290: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

75286: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
75287: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
75288: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
75289: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
75290: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
75291: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
75292: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
75293: WHEN 12 THEN 'FV_XLA_AR_REF_V'
75294: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 75291: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'

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

Line 75294: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'

75290: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
75291: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
75292: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
75293: WHEN 12 THEN 'FV_XLA_AR_REF_V'
75294: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'
75295:
75296: ELSE null
75297: END object_name
75298: , CASE r

Line 75369: , AR_CUST_TRX_LINES_BASE_V l3

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

Line 75527: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

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

Line 75528: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

75524: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75525: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75526: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75527: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75528: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75529: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75530: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75531: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
75532: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 75529: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

75525: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75526: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75527: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75528: TYPE t_array_source_39 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75529: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75530: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75531: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
75532: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75533: TYPE t_array_source_66 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 75530: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

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

Line 75533: TYPE t_array_source_66 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;

75529: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75530: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
75531: TYPE t_array_source_55 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
75532: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
75533: TYPE t_array_source_66 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
75534:
75535: l_array_source_3 t_array_source_3;
75536: l_array_source_10 t_array_source_10;
75537: l_array_source_16 t_array_source_16;

Line 75655: , AR_CUST_TRX_LINES_BASE_V l3

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