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

APPS.XLA_00222_AAD_S_000006_PKG dependencies on FV_XLA_AR_REF_V

Line 77286: WHEN 2 THEN 'FV_XLA_AR_REF_V'

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

Line 77296: WHEN 12 THEN 'FV_XLA_AR_REF_V'

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

Line 77374: , FV_XLA_AR_REF_V l6

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

Line 77526: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

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

Line 77536: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;

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

Line 77663: , FV_XLA_AR_REF_V l6

77659: , l3.ROUNDING_CORRECTION_FLAG source_66
77660: FROM xla_events_gt xet
77661: , AR_CUST_TRX_LINES_BASE_V l3
77662: , AR_CUST_TRX_LINES_L_V l4
77663: , FV_XLA_AR_REF_V l6
77664: WHERE xet.event_id between x_first_event_id and x_last_event_id
77665: and xet.event_date between p_pad_start_date and p_pad_end_date
77666: and xet.event_class_code = C_EVENT_CLASS_CODE
77667: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 78868: WHEN 2 THEN 'FV_XLA_AR_REF_V'

78864: SELECT xet.event_id event_id
78865: , l3.line_number line_number
78866: , CASE r
78867: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
78868: WHEN 2 THEN 'FV_XLA_AR_REF_V'
78869: WHEN 3 THEN 'FV_XLA_AR_REF_V'
78870: WHEN 4 THEN 'FV_XLA_AR_REF_V'
78871: WHEN 5 THEN 'FV_XLA_AR_REF_V'
78872: WHEN 6 THEN 'FV_XLA_AR_REF_V'

Line 78869: WHEN 3 THEN 'FV_XLA_AR_REF_V'

78865: , l3.line_number line_number
78866: , CASE r
78867: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
78868: WHEN 2 THEN 'FV_XLA_AR_REF_V'
78869: WHEN 3 THEN 'FV_XLA_AR_REF_V'
78870: WHEN 4 THEN 'FV_XLA_AR_REF_V'
78871: WHEN 5 THEN 'FV_XLA_AR_REF_V'
78872: WHEN 6 THEN 'FV_XLA_AR_REF_V'
78873: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78870: WHEN 4 THEN 'FV_XLA_AR_REF_V'

78866: , CASE r
78867: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
78868: WHEN 2 THEN 'FV_XLA_AR_REF_V'
78869: WHEN 3 THEN 'FV_XLA_AR_REF_V'
78870: WHEN 4 THEN 'FV_XLA_AR_REF_V'
78871: WHEN 5 THEN 'FV_XLA_AR_REF_V'
78872: WHEN 6 THEN 'FV_XLA_AR_REF_V'
78873: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
78874: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78871: WHEN 5 THEN 'FV_XLA_AR_REF_V'

78867: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
78868: WHEN 2 THEN 'FV_XLA_AR_REF_V'
78869: WHEN 3 THEN 'FV_XLA_AR_REF_V'
78870: WHEN 4 THEN 'FV_XLA_AR_REF_V'
78871: WHEN 5 THEN 'FV_XLA_AR_REF_V'
78872: WHEN 6 THEN 'FV_XLA_AR_REF_V'
78873: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
78874: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
78875: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78872: WHEN 6 THEN 'FV_XLA_AR_REF_V'

78868: WHEN 2 THEN 'FV_XLA_AR_REF_V'
78869: WHEN 3 THEN 'FV_XLA_AR_REF_V'
78870: WHEN 4 THEN 'FV_XLA_AR_REF_V'
78871: WHEN 5 THEN 'FV_XLA_AR_REF_V'
78872: WHEN 6 THEN 'FV_XLA_AR_REF_V'
78873: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
78874: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
78875: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
78876: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78881: WHEN 15 THEN 'FV_XLA_AR_REF_V'

78877: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
78878: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
78879: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
78880: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
78881: WHEN 15 THEN 'FV_XLA_AR_REF_V'
78882: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
78883: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
78884:
78885: ELSE null

Line 78976: , FV_XLA_AR_REF_V l6

78972: , null source_meaning
78973: FROM xla_events_gt xet
78974: , AR_DISTRIBUTIONS_BASE_V l2
78975: , AR_DISTRIBUTIONS_L_V l3
78976: , FV_XLA_AR_REF_V l6
78977: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
78978: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78979: AND xet.event_class_code = C_EVENT_CLASS_CODE
78980: AND l2.event_id = xet.event_id

Line 79128: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

79124: TYPE t_array_source_88 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79125: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79126:
79127: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79128: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 79129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

79125: TYPE t_array_source_89 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79126:
79127: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79128: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

79126:
79127: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79128: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79134: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;

79127: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79128: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79134: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79135: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

79128: TYPE t_array_source_5 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79134: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79135: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79136: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 79141: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;

79137: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
79138: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
79139: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79140: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79141: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79142: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79143: TYPE t_array_source_69 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
79144:
79145: l_array_source_1 t_array_source_1;

Line 79277: , FV_XLA_AR_REF_V l6

79273: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_69
79274: FROM xla_events_gt xet
79275: , AR_DISTRIBUTIONS_BASE_V l2
79276: , AR_DISTRIBUTIONS_L_V l3
79277: , FV_XLA_AR_REF_V l6
79278: WHERE xet.event_id between x_first_event_id and x_last_event_id
79279: and xet.event_date between p_pad_start_date and p_pad_end_date
79280: and xet.event_class_code = C_EVENT_CLASS_CODE
79281: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 80759: WHEN 4 THEN 'FV_XLA_AR_REF_V'

80755: , CASE r
80756: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
80757: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
80758: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80759: WHEN 4 THEN 'FV_XLA_AR_REF_V'
80760: WHEN 5 THEN 'FV_XLA_AR_REF_V'
80761: WHEN 6 THEN 'FV_XLA_AR_REF_V'
80762: WHEN 7 THEN 'FV_XLA_AR_REF_V'
80763: WHEN 8 THEN 'FV_XLA_AR_REF_V'

Line 80760: WHEN 5 THEN 'FV_XLA_AR_REF_V'

80756: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
80757: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
80758: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80759: WHEN 4 THEN 'FV_XLA_AR_REF_V'
80760: WHEN 5 THEN 'FV_XLA_AR_REF_V'
80761: WHEN 6 THEN 'FV_XLA_AR_REF_V'
80762: WHEN 7 THEN 'FV_XLA_AR_REF_V'
80763: WHEN 8 THEN 'FV_XLA_AR_REF_V'
80764: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'

Line 80761: WHEN 6 THEN 'FV_XLA_AR_REF_V'

80757: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
80758: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80759: WHEN 4 THEN 'FV_XLA_AR_REF_V'
80760: WHEN 5 THEN 'FV_XLA_AR_REF_V'
80761: WHEN 6 THEN 'FV_XLA_AR_REF_V'
80762: WHEN 7 THEN 'FV_XLA_AR_REF_V'
80763: WHEN 8 THEN 'FV_XLA_AR_REF_V'
80764: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
80765: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

Line 80762: WHEN 7 THEN 'FV_XLA_AR_REF_V'

80758: WHEN 3 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
80759: WHEN 4 THEN 'FV_XLA_AR_REF_V'
80760: WHEN 5 THEN 'FV_XLA_AR_REF_V'
80761: WHEN 6 THEN 'FV_XLA_AR_REF_V'
80762: WHEN 7 THEN 'FV_XLA_AR_REF_V'
80763: WHEN 8 THEN 'FV_XLA_AR_REF_V'
80764: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
80765: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
80766: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'

Line 80763: WHEN 8 THEN 'FV_XLA_AR_REF_V'

80759: WHEN 4 THEN 'FV_XLA_AR_REF_V'
80760: WHEN 5 THEN 'FV_XLA_AR_REF_V'
80761: WHEN 6 THEN 'FV_XLA_AR_REF_V'
80762: WHEN 7 THEN 'FV_XLA_AR_REF_V'
80763: WHEN 8 THEN 'FV_XLA_AR_REF_V'
80764: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
80765: WHEN 10 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
80766: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
80767: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'

Line 80777: WHEN 22 THEN 'FV_XLA_AR_REF_V'

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

Line 80959: , FV_XLA_AR_REF_V l12

80955: , AR_DISTRIBUTIONS_BASE_V l4
80956: , AR_DISTRIBUTIONS_L_V l5
80957: , AR_RECEIVABLES_TRX_ACT_S_V l8
80958: , AR_TRANSACTIONS_S_V l11
80959: , FV_XLA_AR_REF_V l12
80960: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
80961: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
80962: AND xet.event_class_code = C_EVENT_CLASS_CODE
80963: AND l4.event_id = xet.event_id

Line 81128: TYPE t_array_source_7 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;

81124:
81125: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
81126: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
81127: TYPE t_array_source_6 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
81128: TYPE t_array_source_7 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
81129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
81130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
81131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
81132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 81129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

81125: TYPE t_array_source_3 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
81126: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
81127: TYPE t_array_source_6 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
81128: TYPE t_array_source_7 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
81129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
81130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
81131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
81132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 81130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

81126: TYPE t_array_source_4 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
81127: TYPE t_array_source_6 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
81128: TYPE t_array_source_7 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
81129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
81130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
81131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
81132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
81134: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 81131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;

81127: TYPE t_array_source_6 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
81128: TYPE t_array_source_7 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
81129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
81130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
81131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
81132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
81134: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
81135: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 81132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

81128: TYPE t_array_source_7 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
81129: TYPE t_array_source_8 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
81130: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
81131: TYPE t_array_source_10 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
81132: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
81133: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
81134: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
81135: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
81136: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 81146: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;

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

Line 81351: , FV_XLA_AR_REF_V l12

81347: , AR_DISTRIBUTIONS_BASE_V l4
81348: , AR_DISTRIBUTIONS_L_V l5
81349: , AR_RECEIVABLES_TRX_ACT_S_V l8
81350: , AR_TRANSACTIONS_S_V l11
81351: , FV_XLA_AR_REF_V l12
81352: WHERE xet.event_id between x_first_event_id and x_last_event_id
81353: and xet.event_date between p_pad_start_date and p_pad_end_date
81354: and xet.event_class_code = C_EVENT_CLASS_CODE
81355: and xet.event_status_code <> 'N' AND l4.event_id = xet.event_id