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

Line 69201: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

69197: FROM (
69198: SELECT xet.event_id event_id
69199: , l4.line_number line_number
69200: , CASE r
69201: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
69202: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
69203: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69204: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69205: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 69202: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

69198: SELECT xet.event_id event_id
69199: , l4.line_number line_number
69200: , CASE r
69201: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
69202: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
69203: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69204: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69205: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69206: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 69203: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

69199: , l4.line_number line_number
69200: , CASE r
69201: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
69202: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
69203: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69204: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69205: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69206: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69207: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 69204: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

69200: , CASE r
69201: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
69202: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
69203: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69204: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69205: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69206: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69207: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
69208: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 69205: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

69201: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
69202: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
69203: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
69204: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
69205: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
69206: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
69207: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
69208: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
69209: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 69269: , AR_CUST_TRX_LINES_L_V l4

69265: END source_value
69266: , null source_meaning
69267: FROM xla_events_gt xet
69268: , AR_CUST_TRX_LINES_BASE_V l3
69269: , AR_CUST_TRX_LINES_L_V l4
69270: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
69271: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
69272: AND xet.event_class_code = C_EVENT_CLASS_CODE
69273: AND l3.event_id = xet.event_id

Line 69417: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

69413: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
69414: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69415: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69416:
69417: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69418: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69419: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69420: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69421: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 69418: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

69414: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
69415: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69416:
69417: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69418: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69419: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69420: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69421: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69422: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 69419: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

69415: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
69416:
69417: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69418: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69419: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69420: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69421: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69422: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69423: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 69420: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

69416:
69417: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69418: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69419: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69420: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69421: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69422: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69423: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69424: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 69421: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

69417: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
69418: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
69419: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
69420: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69421: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
69422: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
69423: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
69424: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
69425: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 69536: , AR_CUST_TRX_LINES_L_V l4

69532: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
69533: , l3.TRX_LINE_ACCTD_AMT source_43
69534: FROM xla_events_gt xet
69535: , AR_CUST_TRX_LINES_BASE_V l3
69536: , AR_CUST_TRX_LINES_L_V l4
69537: WHERE xet.event_id between x_first_event_id and x_last_event_id
69538: and xet.event_date between p_pad_start_date and p_pad_end_date
69539: and xet.event_class_code = C_EVENT_CLASS_CODE
69540: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 72076: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

72072: FROM (
72073: SELECT xet.event_id event_id
72074: , l4.line_number line_number
72075: , CASE r
72076: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
72077: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
72078: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72079: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72080: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 72077: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

72073: SELECT xet.event_id event_id
72074: , l4.line_number line_number
72075: , CASE r
72076: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
72077: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
72078: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72079: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72080: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72081: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 72078: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

72074: , l4.line_number line_number
72075: , CASE r
72076: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
72077: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
72078: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72079: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72080: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72081: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72082: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 72079: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

72075: , CASE r
72076: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
72077: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
72078: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72079: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72080: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72081: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72082: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72083: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 72080: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

72076: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
72077: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
72078: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
72079: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
72080: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
72081: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72082: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72083: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72084: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 72085: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'

72081: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
72082: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
72083: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
72084: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
72085: WHEN 10 THEN 'AR_CUST_TRX_LINES_L_V'
72086:
72087: ELSE null
72088: END object_name
72089: , CASE r

Line 72149: , AR_CUST_TRX_LINES_L_V l4

72145: END source_value
72146: , null source_meaning
72147: FROM xla_events_gt xet
72148: , AR_CUST_TRX_LINES_BASE_V l3
72149: , AR_CUST_TRX_LINES_L_V l4
72150: , (select rownum r from all_objects where rownum <= 10 and owner = p_apps_owner)
72151: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
72152: AND xet.event_class_code = C_EVENT_CLASS_CODE
72153: AND l3.event_id = xet.event_id

Line 72299: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

72295: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
72296: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72297: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72298:
72299: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72300: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72301: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72302: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72303: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 72300: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

72296: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
72297: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72298:
72299: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72300: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72301: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72302: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72303: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72304: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 72301: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

72297: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
72298:
72299: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72300: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72301: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72302: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72303: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72304: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
72305: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 72302: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

72298:
72299: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72300: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72301: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72302: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72303: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72304: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
72305: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
72306: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 72303: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

72299: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
72300: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
72301: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
72302: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72303: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
72304: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
72305: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
72306: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72307: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 72308: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

72304: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
72305: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
72306: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
72307: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
72308: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
72309:
72310: l_array_source_8 t_array_source_8;
72311: l_array_source_32 t_array_source_32;
72312: l_array_source_33 t_array_source_33;

Line 72425: , AR_CUST_TRX_LINES_L_V l4

72421: , l3.TRX_LINE_ACCTD_AMT source_43
72422: , l4.TRX_TAX_LINE_ID source_57
72423: FROM xla_events_gt xet
72424: , AR_CUST_TRX_LINES_BASE_V l3
72425: , AR_CUST_TRX_LINES_L_V l4
72426: WHERE xet.event_id between x_first_event_id and x_last_event_id
72427: and xet.event_date between p_pad_start_date and p_pad_end_date
72428: and xet.event_class_code = C_EVENT_CLASS_CODE
72429: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 73537: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

73533: FROM (
73534: SELECT xet.event_id event_id
73535: , l4.line_number line_number
73536: , CASE r
73537: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
73538: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
73539: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73540: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73541: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 73538: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

73534: SELECT xet.event_id event_id
73535: , l4.line_number line_number
73536: , CASE r
73537: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
73538: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
73539: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73540: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73541: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73542: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 73539: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

73535: , l4.line_number line_number
73536: , CASE r
73537: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
73538: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
73539: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73540: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73541: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73542: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73543: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 73540: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

73536: , CASE r
73537: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
73538: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
73539: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73540: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73541: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73542: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73543: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
73544: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 73541: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

73537: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
73538: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
73539: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
73540: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
73541: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
73542: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
73543: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
73544: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
73545: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 73605: , AR_CUST_TRX_LINES_L_V l4

73601: END source_value
73602: , null source_meaning
73603: FROM xla_events_gt xet
73604: , AR_CUST_TRX_LINES_BASE_V l3
73605: , AR_CUST_TRX_LINES_L_V l4
73606: , (select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
73607: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
73608: AND xet.event_class_code = C_EVENT_CLASS_CODE
73609: AND l3.event_id = xet.event_id

Line 73753: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

73749: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
73750: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73751: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73752:
73753: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73754: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73755: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73756: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73757: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 73754: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

73750: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
73751: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73752:
73753: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73754: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73755: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73756: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73757: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73758: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 73755: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

73751: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
73752:
73753: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73754: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73755: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73756: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73757: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73758: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73759: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 73756: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

73752:
73753: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73754: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73755: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73756: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73757: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73758: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73759: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73760: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 73757: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

73753: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
73754: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
73755: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
73756: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73757: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
73758: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
73759: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
73760: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
73761: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 73872: , AR_CUST_TRX_LINES_L_V l4

73868: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
73869: , l3.TRX_LINE_ACCTD_AMT source_43
73870: FROM xla_events_gt xet
73871: , AR_CUST_TRX_LINES_BASE_V l3
73872: , AR_CUST_TRX_LINES_L_V l4
73873: WHERE xet.event_id between x_first_event_id and x_last_event_id
73874: and xet.event_date between p_pad_start_date and p_pad_end_date
73875: and xet.event_class_code = C_EVENT_CLASS_CODE
73876: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 74783: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'

74779: FROM (
74780: SELECT xet.event_id event_id
74781: , l4.line_number line_number
74782: , CASE r
74783: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74784: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74785: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74786: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74787: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 74784: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

74780: SELECT xet.event_id event_id
74781: , l4.line_number line_number
74782: , CASE r
74783: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74784: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74785: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74786: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74787: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74788: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74785: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

74781: , l4.line_number line_number
74782: , CASE r
74783: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74784: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74785: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74786: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74787: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74788: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74789: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74786: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

74782: , CASE r
74783: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74784: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74785: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74786: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74787: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74788: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74789: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74790: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74787: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

74783: WHEN 1 THEN 'AR_CUST_TRX_LINES_L_V'
74784: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
74785: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
74786: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
74787: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
74788: WHEN 6 THEN 'AR_CUST_TRX_LINES_BASE_V'
74789: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
74790: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
74791: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 74851: , AR_CUST_TRX_LINES_L_V l4

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

Line 74999: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

74995: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
74996: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74998:
74999: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75000: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75001: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 75000: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

74996: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
74997: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74998:
74999: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75000: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75001: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 75001: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

74997: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
74998:
74999: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75000: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75001: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 75002: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

74998:
74999: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75000: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75001: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 75003: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

74999: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75000: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75001: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75002: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75003: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
75004: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
75005: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
75006: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
75007: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 75118: , AR_CUST_TRX_LINES_L_V l4

75114: , l3.TRX_LINE_CUR_CONVERSION_TYPE source_42
75115: , l3.TRX_LINE_ACCTD_AMT source_43
75116: FROM xla_events_gt xet
75117: , AR_CUST_TRX_LINES_BASE_V l3
75118: , AR_CUST_TRX_LINES_L_V l4
75119: WHERE xet.event_id between x_first_event_id and x_last_event_id
75120: and xet.event_date between p_pad_start_date and p_pad_end_date
75121: and xet.event_class_code = C_EVENT_CLASS_CODE
75122: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 76045: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'

76041: SELECT xet.event_id event_id
76042: , l4.line_number line_number
76043: , CASE r
76044: WHEN 1 THEN 'FV_XLA_AR_REF_V'
76045: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
76046: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76047: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76048: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76049: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'

Line 76046: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'

76042: , l4.line_number line_number
76043: , CASE r
76044: WHEN 1 THEN 'FV_XLA_AR_REF_V'
76045: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
76046: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76047: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76048: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76049: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
76050: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 76047: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'

76043: , CASE r
76044: WHEN 1 THEN 'FV_XLA_AR_REF_V'
76045: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
76046: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76047: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76048: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76049: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
76050: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76051: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 76048: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

76044: WHEN 1 THEN 'FV_XLA_AR_REF_V'
76045: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
76046: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76047: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76048: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76049: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
76050: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76051: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76052: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 76049: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'

76045: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
76046: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
76047: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
76048: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'
76049: WHEN 6 THEN 'AR_CUST_TRX_LINES_L_V'
76050: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76051: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76052: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76053: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'

Line 76054: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'

76050: WHEN 7 THEN 'AR_CUST_TRX_LINES_BASE_V'
76051: WHEN 8 THEN 'AR_CUST_TRX_LINES_BASE_V'
76052: WHEN 9 THEN 'AR_CUST_TRX_LINES_BASE_V'
76053: WHEN 10 THEN 'AR_CUST_TRX_LINES_BASE_V'
76054: WHEN 11 THEN 'AR_CUST_TRX_LINES_L_V'
76055: WHEN 12 THEN 'FV_XLA_AR_REF_V'
76056: WHEN 13 THEN 'AR_CUST_TRX_LINES_BASE_V'
76057:
76058: ELSE null

Line 76132: , AR_CUST_TRX_LINES_L_V l4

76128: END source_value
76129: , null source_meaning
76130: FROM xla_events_gt xet
76131: , AR_CUST_TRX_LINES_BASE_V l3
76132: , AR_CUST_TRX_LINES_L_V l4
76133: , FV_XLA_AR_REF_V l6
76134: , (select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
76135: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
76136: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 76285: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

76281: TYPE t_array_source_86 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
76282: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76283:
76284: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76285: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76286: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76287: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76288: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76289: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 76286: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

76282: TYPE t_array_source_87 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
76283:
76284: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76285: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76286: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76287: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76288: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76289: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76290: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 76287: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

76283:
76284: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76285: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76286: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76287: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76288: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76289: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76290: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76291: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;

Line 76288: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

76284: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
76285: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76286: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76287: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76288: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76289: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76290: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76291: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76292: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 76289: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;

76285: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
76286: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
76287: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
76288: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76289: TYPE t_array_source_38 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_AMT%TYPE INDEX BY BINARY_INTEGER;
76290: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76291: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76292: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76293: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 76294: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

76290: TYPE t_array_source_40 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
76291: TYPE t_array_source_41 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
76292: TYPE t_array_source_42 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
76293: TYPE t_array_source_43 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.TRX_LINE_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
76294: TYPE t_array_source_57 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
76295: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
76296: TYPE t_array_source_68 IS TABLE OF AR_CUST_TRX_LINES_BASE_V.ROUNDING_CORRECTION_FLAG%TYPE INDEX BY BINARY_INTEGER;
76297:
76298: l_array_source_8 t_array_source_8;

Line 76421: , AR_CUST_TRX_LINES_L_V l4

76417: , l6.FEDERAL_ACCOUNT_VALID_FLAG source_58
76418: , l3.ROUNDING_CORRECTION_FLAG source_68
76419: FROM xla_events_gt xet
76420: , AR_CUST_TRX_LINES_BASE_V l3
76421: , AR_CUST_TRX_LINES_L_V l4
76422: , FV_XLA_AR_REF_V l6
76423: WHERE xet.event_id between x_first_event_id and x_last_event_id
76424: and xet.event_date between p_pad_start_date and p_pad_end_date
76425: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 79522: WHEN 8 THEN 'AR_CUST_TRX_LINES_L_V'

79518: WHEN 4 THEN 'FV_XLA_AR_REF_V'
79519: WHEN 5 THEN 'FV_XLA_AR_REF_V'
79520: WHEN 6 THEN 'FV_XLA_AR_REF_V'
79521: WHEN 7 THEN 'FV_XLA_AR_REF_V'
79522: WHEN 8 THEN 'AR_CUST_TRX_LINES_L_V'
79523: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
79524: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
79525: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
79526: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79533: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'

79529: WHEN 15 THEN 'AR_DISTRIBUTIONS_BASE_V'
79530: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
79531: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
79532: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
79533: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
79534: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
79535: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
79536: WHEN 22 THEN 'FV_XLA_AR_REF_V'
79537: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'

Line 79534: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'

79530: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
79531: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
79532: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
79533: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
79534: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
79535: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
79536: WHEN 22 THEN 'FV_XLA_AR_REF_V'
79537: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'
79538: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'

Line 79535: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'

79531: WHEN 17 THEN 'AR_DISTRIBUTIONS_BASE_V'
79532: WHEN 18 THEN 'AR_DISTRIBUTIONS_BASE_V'
79533: WHEN 19 THEN 'AR_CUST_TRX_LINES_L_V'
79534: WHEN 20 THEN 'AR_CUST_TRX_LINES_L_V'
79535: WHEN 21 THEN 'AR_CUST_TRX_LINES_L_V'
79536: WHEN 22 THEN 'FV_XLA_AR_REF_V'
79537: WHEN 23 THEN 'AR_DISTRIBUTIONS_BASE_V'
79538: WHEN 24 THEN 'AR_TRANSACTIONS_S_V'
79539: WHEN 25 THEN 'AR_TRANSACTIONS_S_V'

Line 79713: , AR_CUST_TRX_LINES_L_V l3

79709: END source_value
79710: , null source_meaning
79711: FROM xla_events_gt xet
79712: , AR_BILL_TO_CUSTOMERS_S_V l1
79713: , AR_CUST_TRX_LINES_L_V l3
79714: , AR_DISTRIBUTIONS_BASE_V l4
79715: , AR_DISTRIBUTIONS_L_V l5
79716: , AR_RECEIVABLES_TRX_ACT_S_V l8
79717: , AR_TRANSACTIONS_S_V l11

Line 79893: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;

79889: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79890: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79891: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79892: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79893: TYPE t_array_source_21 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
79894: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79895: TYPE t_array_source_23 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
79896: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79897: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79904: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;

79900: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79901: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79902: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79903: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79904: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79905: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79906: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79907: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79908: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 79905: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

79901: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79902: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79903: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79904: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79905: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79906: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79907: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79908: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79909: TYPE t_array_source_61 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 79906: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

79902: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79903: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79904: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79905: TYPE t_array_source_36 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79906: TYPE t_array_source_37 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79907: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79908: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79909: TYPE t_array_source_61 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79910: TYPE t_array_source_62 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;

Line 80111: , AR_CUST_TRX_LINES_L_V l3

80107: , l4.DIST_TO_CUR_CONVERSION_TYPE source_76
80108: , l5.DIST_SOURCE_TABLE source_77
80109: FROM xla_events_gt xet
80110: , AR_BILL_TO_CUSTOMERS_S_V l1
80111: , AR_CUST_TRX_LINES_L_V l3
80112: , AR_DISTRIBUTIONS_BASE_V l4
80113: , AR_DISTRIBUTIONS_L_V l5
80114: , AR_RECEIVABLES_TRX_ACT_S_V l8
80115: , AR_TRANSACTIONS_S_V l11