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

APPS.XLA_00222_AAD_S_000005_PKG dependencies on FV_XLA_AR_REF_V

Line 75282: WHEN 1 THEN 'FV_XLA_AR_REF_V'

75278: FROM (
75279: SELECT xet.event_id event_id
75280: , l4.line_number line_number
75281: , CASE r
75282: WHEN 1 THEN 'FV_XLA_AR_REF_V'
75283: WHEN 2 THEN 'AR_CUST_TRX_LINES_L_V'
75284: WHEN 3 THEN 'AR_CUST_TRX_LINES_L_V'
75285: WHEN 4 THEN 'AR_CUST_TRX_LINES_L_V'
75286: WHEN 5 THEN 'AR_CUST_TRX_LINES_L_V'

Line 75293: WHEN 12 THEN 'FV_XLA_AR_REF_V'

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

Line 75371: , FV_XLA_AR_REF_V l6

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

Line 75521: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

75517: TYPE t_array_source_37 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_INVOICE_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
75518: TYPE t_array_source_81 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75519: TYPE t_array_source_82 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
75520:
75521: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
75522: TYPE t_array_source_19 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_CCID%TYPE INDEX BY BINARY_INTEGER;
75523: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
75524: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
75525: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

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

Line 75657: , FV_XLA_AR_REF_V l6

75653: , l3.ROUNDING_CORRECTION_FLAG source_66
75654: FROM xla_events_gt xet
75655: , AR_CUST_TRX_LINES_BASE_V l3
75656: , AR_CUST_TRX_LINES_L_V l4
75657: , FV_XLA_AR_REF_V l6
75658: WHERE xet.event_id between x_first_event_id and x_last_event_id
75659: and xet.event_date between p_pad_start_date and p_pad_end_date
75660: and xet.event_class_code = C_EVENT_CLASS_CODE
75661: and xet.event_status_code <> 'N' AND l3.event_id = xet.event_id

Line 76955: WHEN 2 THEN 'FV_XLA_AR_REF_V'

76951: SELECT xet.event_id event_id
76952: , l3.line_number line_number
76953: , CASE r
76954: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
76955: WHEN 2 THEN 'FV_XLA_AR_REF_V'
76956: WHEN 3 THEN 'FV_XLA_AR_REF_V'
76957: WHEN 4 THEN 'FV_XLA_AR_REF_V'
76958: WHEN 5 THEN 'FV_XLA_AR_REF_V'
76959: WHEN 6 THEN 'FV_XLA_AR_REF_V'

Line 76956: WHEN 3 THEN 'FV_XLA_AR_REF_V'

76952: , l3.line_number line_number
76953: , CASE r
76954: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
76955: WHEN 2 THEN 'FV_XLA_AR_REF_V'
76956: WHEN 3 THEN 'FV_XLA_AR_REF_V'
76957: WHEN 4 THEN 'FV_XLA_AR_REF_V'
76958: WHEN 5 THEN 'FV_XLA_AR_REF_V'
76959: WHEN 6 THEN 'FV_XLA_AR_REF_V'
76960: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'

Line 76957: WHEN 4 THEN 'FV_XLA_AR_REF_V'

76953: , CASE r
76954: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
76955: WHEN 2 THEN 'FV_XLA_AR_REF_V'
76956: WHEN 3 THEN 'FV_XLA_AR_REF_V'
76957: WHEN 4 THEN 'FV_XLA_AR_REF_V'
76958: WHEN 5 THEN 'FV_XLA_AR_REF_V'
76959: WHEN 6 THEN 'FV_XLA_AR_REF_V'
76960: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
76961: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'

Line 76958: WHEN 5 THEN 'FV_XLA_AR_REF_V'

76954: WHEN 1 THEN 'AR_DISTRIBUTIONS_L_V'
76955: WHEN 2 THEN 'FV_XLA_AR_REF_V'
76956: WHEN 3 THEN 'FV_XLA_AR_REF_V'
76957: WHEN 4 THEN 'FV_XLA_AR_REF_V'
76958: WHEN 5 THEN 'FV_XLA_AR_REF_V'
76959: WHEN 6 THEN 'FV_XLA_AR_REF_V'
76960: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
76961: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
76962: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'

Line 76959: WHEN 6 THEN 'FV_XLA_AR_REF_V'

76955: WHEN 2 THEN 'FV_XLA_AR_REF_V'
76956: WHEN 3 THEN 'FV_XLA_AR_REF_V'
76957: WHEN 4 THEN 'FV_XLA_AR_REF_V'
76958: WHEN 5 THEN 'FV_XLA_AR_REF_V'
76959: WHEN 6 THEN 'FV_XLA_AR_REF_V'
76960: WHEN 7 THEN 'AR_DISTRIBUTIONS_L_V'
76961: WHEN 8 THEN 'AR_DISTRIBUTIONS_L_V'
76962: WHEN 9 THEN 'AR_DISTRIBUTIONS_L_V'
76963: WHEN 10 THEN 'AR_DISTRIBUTIONS_L_V'

Line 76968: WHEN 15 THEN 'FV_XLA_AR_REF_V'

76964: WHEN 11 THEN 'AR_DISTRIBUTIONS_L_V'
76965: WHEN 12 THEN 'AR_DISTRIBUTIONS_BASE_V'
76966: WHEN 13 THEN 'AR_DISTRIBUTIONS_BASE_V'
76967: WHEN 14 THEN 'AR_DISTRIBUTIONS_BASE_V'
76968: WHEN 15 THEN 'FV_XLA_AR_REF_V'
76969: WHEN 16 THEN 'AR_DISTRIBUTIONS_BASE_V'
76970: WHEN 17 THEN 'AR_DISTRIBUTIONS_L_V'
76971:
76972: ELSE null

Line 77063: , FV_XLA_AR_REF_V l4

77059: , null source_meaning
77060: FROM xla_events_gt xet
77061: , AR_DISTRIBUTIONS_BASE_V l2
77062: , AR_DISTRIBUTIONS_L_V l3
77063: , FV_XLA_AR_REF_V l4
77064: , (select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
77065: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
77066: AND xet.event_class_code = C_EVENT_CLASS_CODE
77067: AND l2.event_id = xet.event_id

Line 77209: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

77205: TYPE t_array_source_85 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
77206: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77207:
77208: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77209: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77210: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77211: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77212: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77213: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 77210: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

77206: TYPE t_array_source_86 IS TABLE OF AR_CASH_RECEIPTS_H_V.RCT_TRX_ACCT_REVERSAL%TYPE INDEX BY BINARY_INTEGER;
77207:
77208: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77209: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77210: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77211: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77212: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77213: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77214: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 77211: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

77207:
77208: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77209: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77210: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77211: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77212: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77213: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77214: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77215: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 77212: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;

77208: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
77209: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77210: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77211: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77212: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77213: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77214: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77215: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77216: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 77213: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

77209: TYPE t_array_source_9 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77210: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
77211: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
77212: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
77213: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
77214: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
77215: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
77216: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77217: TYPE t_array_source_24 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_ENT_AMT%TYPE INDEX BY BINARY_INTEGER;

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

77218: TYPE t_array_source_25 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
77219: TYPE t_array_source_27 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
77220: TYPE t_array_source_28 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_CUR_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
77221: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
77222: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
77223: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
77224: TYPE t_array_source_67 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_MFAR_ADDITIONAL_ENTRY%TYPE INDEX BY BINARY_INTEGER;
77225:
77226: l_array_source_83 t_array_source_83;

Line 77342: , FV_XLA_AR_REF_V l4

77338: , l3.DIST_MFAR_ADDITIONAL_ENTRY source_67
77339: FROM xla_events_gt xet
77340: , AR_DISTRIBUTIONS_BASE_V l2
77341: , AR_DISTRIBUTIONS_L_V l3
77342: , FV_XLA_AR_REF_V l4
77343: WHERE xet.event_id between x_first_event_id and x_last_event_id
77344: and xet.event_date between p_pad_start_date and p_pad_end_date
77345: and xet.event_class_code = C_EVENT_CLASS_CODE
77346: and xet.event_status_code <> 'N' AND l2.event_id = xet.event_id

Line 78724: WHEN 7 THEN 'FV_XLA_AR_REF_V'

78720: WHEN 3 THEN 'AR_TRANSACTIONS_S_V'
78721: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
78722: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
78723: WHEN 6 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78724: WHEN 7 THEN 'FV_XLA_AR_REF_V'
78725: WHEN 8 THEN 'FV_XLA_AR_REF_V'
78726: WHEN 9 THEN 'FV_XLA_AR_REF_V'
78727: WHEN 10 THEN 'FV_XLA_AR_REF_V'
78728: WHEN 11 THEN 'FV_XLA_AR_REF_V'

Line 78725: WHEN 8 THEN 'FV_XLA_AR_REF_V'

78721: WHEN 4 THEN 'AR_DISTRIBUTIONS_L_V'
78722: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
78723: WHEN 6 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78724: WHEN 7 THEN 'FV_XLA_AR_REF_V'
78725: WHEN 8 THEN 'FV_XLA_AR_REF_V'
78726: WHEN 9 THEN 'FV_XLA_AR_REF_V'
78727: WHEN 10 THEN 'FV_XLA_AR_REF_V'
78728: WHEN 11 THEN 'FV_XLA_AR_REF_V'
78729: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78726: WHEN 9 THEN 'FV_XLA_AR_REF_V'

78722: WHEN 5 THEN 'AR_DISTRIBUTIONS_L_V'
78723: WHEN 6 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78724: WHEN 7 THEN 'FV_XLA_AR_REF_V'
78725: WHEN 8 THEN 'FV_XLA_AR_REF_V'
78726: WHEN 9 THEN 'FV_XLA_AR_REF_V'
78727: WHEN 10 THEN 'FV_XLA_AR_REF_V'
78728: WHEN 11 THEN 'FV_XLA_AR_REF_V'
78729: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
78730: WHEN 13 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'

Line 78727: WHEN 10 THEN 'FV_XLA_AR_REF_V'

78723: WHEN 6 THEN 'AR_BILL_TO_CUSTOMERS_S_V'
78724: WHEN 7 THEN 'FV_XLA_AR_REF_V'
78725: WHEN 8 THEN 'FV_XLA_AR_REF_V'
78726: WHEN 9 THEN 'FV_XLA_AR_REF_V'
78727: WHEN 10 THEN 'FV_XLA_AR_REF_V'
78728: WHEN 11 THEN 'FV_XLA_AR_REF_V'
78729: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
78730: WHEN 13 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
78731: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78728: WHEN 11 THEN 'FV_XLA_AR_REF_V'

78724: WHEN 7 THEN 'FV_XLA_AR_REF_V'
78725: WHEN 8 THEN 'FV_XLA_AR_REF_V'
78726: WHEN 9 THEN 'FV_XLA_AR_REF_V'
78727: WHEN 10 THEN 'FV_XLA_AR_REF_V'
78728: WHEN 11 THEN 'FV_XLA_AR_REF_V'
78729: WHEN 12 THEN 'AR_DISTRIBUTIONS_L_V'
78730: WHEN 13 THEN 'AR_RECEIVABLES_TRX_ACT_S_V'
78731: WHEN 14 THEN 'AR_DISTRIBUTIONS_L_V'
78732: WHEN 15 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78742: WHEN 25 THEN 'FV_XLA_AR_REF_V'

78738: WHEN 21 THEN 'AR_DISTRIBUTIONS_BASE_V'
78739: WHEN 22 THEN 'AR_CUST_TRX_LINES_L_V'
78740: WHEN 23 THEN 'AR_CUST_TRX_LINES_L_V'
78741: WHEN 24 THEN 'AR_CUST_TRX_LINES_L_V'
78742: WHEN 25 THEN 'FV_XLA_AR_REF_V'
78743: WHEN 26 THEN 'AR_DISTRIBUTIONS_BASE_V'
78744: WHEN 27 THEN 'AR_TRANSACTIONS_S_V'
78745: WHEN 28 THEN 'AR_TRANSACTIONS_S_V'
78746: WHEN 29 THEN 'AR_DISTRIBUTIONS_L_V'

Line 78936: , FV_XLA_AR_REF_V l11

78932: , AR_DISTRIBUTIONS_BASE_V l4
78933: , AR_DISTRIBUTIONS_L_V l5
78934: , AR_RECEIVABLES_TRX_ACT_S_V l7
78935: , AR_TRANSACTIONS_S_V l10
78936: , FV_XLA_AR_REF_V l11
78937: , (select rownum r from all_objects where rownum <= 38 and owner = p_apps_owner)
78938: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
78939: AND xet.event_class_code = C_EVENT_CLASS_CODE
78940: AND l4.event_id = xet.event_id

Line 79105: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;

79101: TYPE t_array_source_3 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_DOC_SEQUENCE_VALUE%TYPE INDEX BY BINARY_INTEGER;
79102: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79103: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
79104: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79105: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
79106: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79107: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79108: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79109: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 79106: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

79102: TYPE t_array_source_5 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
79103: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
79104: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79105: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
79106: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79107: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79108: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79109: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79110: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79107: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;

79103: TYPE t_array_source_6 IS TABLE OF AR_DISTRIBUTIONS_L_V.GAIN_LOSS_CCID%TYPE INDEX BY BINARY_INTEGER;
79104: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79105: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
79106: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79107: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79108: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79109: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79110: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79111: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 79108: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;

79104: TYPE t_array_source_10 IS TABLE OF AR_BILL_TO_CUSTOMERS_S_V.BILL_CUSTOMER_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
79105: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
79106: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79107: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79108: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79109: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79110: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79111: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
79112: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 79109: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

79105: TYPE t_array_source_11 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_RULE%TYPE INDEX BY BINARY_INTEGER;
79106: TYPE t_array_source_12 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
79107: TYPE t_array_source_13 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_PRIOR_YEAR_FLAG%TYPE INDEX BY BINARY_INTEGER;
79108: TYPE t_array_source_14 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_FUND_TIME_FRAME%TYPE INDEX BY BINARY_INTEGER;
79109: TYPE t_array_source_15 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_APPORTIONMENT_CATEGORY%TYPE INDEX BY BINARY_INTEGER;
79110: TYPE t_array_source_20 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_SOURCE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79111: TYPE t_array_source_21 IS TABLE OF AR_RECEIVABLES_TRX_ACT_S_V.REC_ACT_TYPE%TYPE INDEX BY BINARY_INTEGER;
79112: TYPE t_array_source_22 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
79113: TYPE t_array_source_23 IS TABLE OF AR_DISTRIBUTIONS_L_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

79119: TYPE t_array_source_29 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_ACCTD_AMT%TYPE INDEX BY BINARY_INTEGER;
79120: TYPE t_array_source_33 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ACCOUNT_CLASS%TYPE INDEX BY BINARY_INTEGER;
79121: TYPE t_array_source_34 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_LINE_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
79122: TYPE t_array_source_35 IS TABLE OF AR_CUST_TRX_LINES_L_V.TRX_DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
79123: TYPE t_array_source_56 IS TABLE OF FV_XLA_AR_REF_V.FEDERAL_ACCOUNT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
79124: TYPE t_array_source_57 IS TABLE OF AR_DISTRIBUTIONS_BASE_V.DIST_TO_CUR_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
79125: TYPE t_array_source_59 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
79126: TYPE t_array_source_60 IS TABLE OF AR_TRANSACTIONS_S_V.TRX_CUSTOMER_TRX_ID%TYPE INDEX BY BINARY_INTEGER;
79127: TYPE t_array_source_61 IS TABLE OF AR_DISTRIBUTIONS_L_V.DIST_CURRENCY_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 79326: , FV_XLA_AR_REF_V l11

79322: , AR_DISTRIBUTIONS_BASE_V l4
79323: , AR_DISTRIBUTIONS_L_V l5
79324: , AR_RECEIVABLES_TRX_ACT_S_V l7
79325: , AR_TRANSACTIONS_S_V l10
79326: , FV_XLA_AR_REF_V l11
79327: WHERE xet.event_id between x_first_event_id and x_last_event_id
79328: and xet.event_date between p_pad_start_date and p_pad_end_date
79329: and xet.event_class_code = C_EVENT_CLASS_CODE
79330: and xet.event_status_code <> 'N' AND l4.event_id = xet.event_id