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 FV_XLA_AR_REF_V

Line 76044: WHEN 1 THEN 'FV_XLA_AR_REF_V'

76040: FROM (
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'

Line 76055: WHEN 12 THEN 'FV_XLA_AR_REF_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
76059: END object_name

Line 76133: , FV_XLA_AR_REF_V l6

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
76137: AND l3.event_id = xet.event_id

Line 76284: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

76280: TYPE t_array_source_85 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%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;

Line 76295: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%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;
76299: l_array_source_12 t_array_source_12;

Line 76422: , FV_XLA_AR_REF_V l6

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
76426: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 77625: WHEN 2 THEN 'FV_XLA_AR_REF_V'

77621: SELECT xet.event_id event_id
77622: , l3.line_number line_number
77623: , CASE r
77624: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
77625: WHEN 2 THEN 'FV_XLA_AR_REF_V'
77626: WHEN 3 THEN 'FV_XLA_AR_REF_V'
77627: WHEN 4 THEN 'FV_XLA_AR_REF_V'
77628: WHEN 5 THEN 'FV_XLA_AR_REF_V'
77629: WHEN 6 THEN 'FV_XLA_AR_REF_V'

Line 77626: WHEN 3 THEN 'FV_XLA_AR_REF_V'

77622: , l3.line_number line_number
77623: , CASE r
77624: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
77625: WHEN 2 THEN 'FV_XLA_AR_REF_V'
77626: WHEN 3 THEN 'FV_XLA_AR_REF_V'
77627: WHEN 4 THEN 'FV_XLA_AR_REF_V'
77628: WHEN 5 THEN 'FV_XLA_AR_REF_V'
77629: WHEN 6 THEN 'FV_XLA_AR_REF_V'
77630: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

Line 77627: WHEN 4 THEN 'FV_XLA_AR_REF_V'

77623: , CASE r
77624: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
77625: WHEN 2 THEN 'FV_XLA_AR_REF_V'
77626: WHEN 3 THEN 'FV_XLA_AR_REF_V'
77627: WHEN 4 THEN 'FV_XLA_AR_REF_V'
77628: WHEN 5 THEN 'FV_XLA_AR_REF_V'
77629: WHEN 6 THEN 'FV_XLA_AR_REF_V'
77630: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
77631: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

Line 77628: WHEN 5 THEN 'FV_XLA_AR_REF_V'

77624: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
77625: WHEN 2 THEN 'FV_XLA_AR_REF_V'
77626: WHEN 3 THEN 'FV_XLA_AR_REF_V'
77627: WHEN 4 THEN 'FV_XLA_AR_REF_V'
77628: WHEN 5 THEN 'FV_XLA_AR_REF_V'
77629: WHEN 6 THEN 'FV_XLA_AR_REF_V'
77630: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
77631: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
77632: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'

Line 77629: WHEN 6 THEN 'FV_XLA_AR_REF_V'

77625: WHEN 2 THEN 'FV_XLA_AR_REF_V'
77626: WHEN 3 THEN 'FV_XLA_AR_REF_V'
77627: WHEN 4 THEN 'FV_XLA_AR_REF_V'
77628: WHEN 5 THEN 'FV_XLA_AR_REF_V'
77629: WHEN 6 THEN 'FV_XLA_AR_REF_V'
77630: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
77631: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
77632: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
77633: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

Line 77638: WHEN 15 THEN 'FV_XLA_AR_REF_V'

77634: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
77635: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
77636: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
77637: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
77638: WHEN 15 THEN 'FV_XLA_AR_REF_V'
77639: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
77640: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
77641:
77642: ELSE null

Line 77733: , FV_XLA_AR_REF_V l6

77729: , null source_meaning
77730: FROM xla_events_gt xet
77731: , AR_DISTRIBUTIONS_BASE_V l2
77732: , AR_DISTRIBUTIONS_L_V l3
77733: , FV_XLA_AR_REF_V l6
77734: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
77735: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77736: AND xet.event_class_code = C_EVENT_CLASS_CODE
77737: AND l2.event_id = xet.event_id

Line 77885: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

77881: TYPE t_array_source_90 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77882: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77883:
77884: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77885: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77886: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77887: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77888: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77889: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 77886: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

77882: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77883:
77884: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77885: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77886: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77887: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77888: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77889: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77890: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 77887: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

77883:
77884: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77885: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77886: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77887: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77888: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77889: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77890: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77891: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 77888: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;

77884: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77885: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77886: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77887: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77888: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77889: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77890: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77891: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77892: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 77889: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

77885: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77886: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77887: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77888: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77889: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77890: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77891: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77892: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77893: TYPE t_array_source_26 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

Line 77898: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;

77894: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77895: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77896: TYPE t_array_source_30 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77897: TYPE t_array_source_31 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77898: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
77899: TYPE t_array_source_59 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77900: TYPE t_array_source_71 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
77901:
77902: l_array_source_1 t_array_source_1;

Line 78034: , FV_XLA_AR_REF_V l6

78030: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_71
78031: FROM xla_events_gt xet
78032: , AR_DISTRIBUTIONS_BASE_V l2
78033: , AR_DISTRIBUTIONS_L_V l3
78034: , FV_XLA_AR_REF_V l6
78035: WHERE xet.event_id between x_first_event_id and x_last_event_id
78036: and xet.event_date between p_pad_start_date and p_pad_end_date
78037: and xet.event_class_code = C_EVENT_CLASS_CODE
78038: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 79517: WHEN 3 THEN 'FV_XLA_AR_REF_V'

79513: , l5.line_number line_number
79514: , CASE r
79515: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
79516: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
79517: WHEN 3 THEN 'FV_XLA_AR_REF_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'

Line 79518: WHEN 4 THEN 'FV_XLA_AR_REF_V'

79514: , CASE r
79515: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
79516: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
79517: WHEN 3 THEN 'FV_XLA_AR_REF_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'

Line 79519: WHEN 5 THEN 'FV_XLA_AR_REF_V'

79515: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
79516: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
79517: WHEN 3 THEN 'FV_XLA_AR_REF_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'

Line 79520: WHEN 6 THEN 'FV_XLA_AR_REF_V'

79516: WHEN 2 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
79517: WHEN 3 THEN 'FV_XLA_AR_REF_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'

Line 79521: WHEN 7 THEN 'FV_XLA_AR_REF_V'

79517: WHEN 3 THEN 'FV_XLA_AR_REF_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'

Line 79536: WHEN 22 THEN 'FV_XLA_AR_REF_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'
79540: WHEN 26 THEN 'AR_DISTRIBUTIONS_L_V'

Line 79718: , FV_XLA_AR_REF_V l12

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
79718: , FV_XLA_AR_REF_V l12
79719: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
79720: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
79721: AND xet.event_class_code = C_EVENT_CLASS_CODE
79722: AND l4.event_id = xet.event_id

Line 79888: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;

79884: TYPE t_array_source_91 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
79885:
79886: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79887: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79888: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%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;

Line 79889: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

79885:
79886: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79887: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79888: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%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;

Line 79890: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

79886: TYPE t_array_source_10 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79887: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79888: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%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;

Line 79891: TYPE t_array_source_16 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;

79887: TYPE t_array_source_12 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79888: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%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;

Line 79892: TYPE t_array_source_17 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

79888: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%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;

Line 79907: TYPE t_array_source_58 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%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;
79911: TYPE t_array_source_63 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 80116: , FV_XLA_AR_REF_V l12

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
80116: , FV_XLA_AR_REF_V l12
80117: WHERE xet.event_id between x_first_event_id and x_last_event_id
80118: and xet.event_date between p_pad_start_date and p_pad_end_date
80119: and xet.event_class_code = C_EVENT_CLASS_CODE
80120: and xet.event_status_code <> 'N' AND l4.event_id = xet.event_id