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_00707_AAD_S_000007_BC_PKG dependencies on CST_XLA_RCV_REF_V

Line 29079: WHEN 2 THEN 'CST_XLA_RCV_REF_V'

29075: SELECT xet.event_id event_id
29076: , 0 line_number
29077: , CASE r
29078: WHEN 1 THEN 'PO_DISTS_REF_V'
29079: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
29080: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
29081: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
29082: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
29083: WHEN 6 THEN 'CST_XLA_RCV_REF_V'

Line 29080: WHEN 3 THEN 'CST_XLA_RCV_REF_V'

29076: , 0 line_number
29077: , CASE r
29078: WHEN 1 THEN 'PO_DISTS_REF_V'
29079: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
29080: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
29081: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
29082: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
29083: WHEN 6 THEN 'CST_XLA_RCV_REF_V'
29084: WHEN 7 THEN 'CST_XLA_RCV_HEADERS_V'

Line 29081: WHEN 4 THEN 'CST_XLA_RCV_REF_V'

29077: , CASE r
29078: WHEN 1 THEN 'PO_DISTS_REF_V'
29079: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
29080: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
29081: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
29082: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
29083: WHEN 6 THEN 'CST_XLA_RCV_REF_V'
29084: WHEN 7 THEN 'CST_XLA_RCV_HEADERS_V'
29085: WHEN 8 THEN 'CST_XLA_RCV_REF_V'

Line 29082: WHEN 5 THEN 'CST_XLA_RCV_REF_V'

29078: WHEN 1 THEN 'PO_DISTS_REF_V'
29079: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
29080: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
29081: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
29082: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
29083: WHEN 6 THEN 'CST_XLA_RCV_REF_V'
29084: WHEN 7 THEN 'CST_XLA_RCV_HEADERS_V'
29085: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
29086: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'

Line 29083: WHEN 6 THEN 'CST_XLA_RCV_REF_V'

29079: WHEN 2 THEN 'CST_XLA_RCV_REF_V'
29080: WHEN 3 THEN 'CST_XLA_RCV_REF_V'
29081: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
29082: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
29083: WHEN 6 THEN 'CST_XLA_RCV_REF_V'
29084: WHEN 7 THEN 'CST_XLA_RCV_HEADERS_V'
29085: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
29086: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
29087: WHEN 10 THEN 'CST_XLA_RCV_REF_V'

Line 29085: WHEN 8 THEN 'CST_XLA_RCV_REF_V'

29081: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
29082: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
29083: WHEN 6 THEN 'CST_XLA_RCV_REF_V'
29084: WHEN 7 THEN 'CST_XLA_RCV_HEADERS_V'
29085: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
29086: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
29087: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
29088: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
29089: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'

Line 29087: WHEN 10 THEN 'CST_XLA_RCV_REF_V'

29083: WHEN 6 THEN 'CST_XLA_RCV_REF_V'
29084: WHEN 7 THEN 'CST_XLA_RCV_HEADERS_V'
29085: WHEN 8 THEN 'CST_XLA_RCV_REF_V'
29086: WHEN 9 THEN 'CST_XLA_RCV_HEADERS_V'
29087: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
29088: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
29089: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
29090: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
29091: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'

Line 29093: WHEN 16 THEN 'CST_XLA_RCV_REF_V'

29089: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
29090: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
29091: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
29092: WHEN 15 THEN 'PO_HEADERS_REF_V'
29093: WHEN 16 THEN 'CST_XLA_RCV_REF_V'
29094: WHEN 17 THEN 'CST_XLA_RCV_HEADERS_V'
29095:
29096: ELSE null
29097: END object_name

Line 29191: , CST_XLA_RCV_REF_V h3

29187: ELSE null
29188: END source_meaning
29189: FROM xla_events_gt xet
29190: , CST_XLA_RCV_HEADERS_V h1
29191: , CST_XLA_RCV_REF_V h3
29192: , PO_DISTS_REF_V h5
29193: , PO_HEADERS_REF_V h6
29194: , PSA_CST_XLA_UPG_V h7
29195: , fnd_lookup_values fvl13

Line 29507: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

29503: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
29504: --
29505:
29506: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
29507: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
29508: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
29509: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29510: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
29511: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

Line 29508: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

29504: --
29505:
29506: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
29507: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
29508: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
29509: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29510: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
29511: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
29512: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 29509: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

29505:
29506: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
29507: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
29508: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
29509: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29510: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
29511: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
29512: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29513: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 29510: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

29506: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
29507: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
29508: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
29509: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29510: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
29511: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
29512: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29513: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
29514: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 29511: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

29507: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
29508: TYPE t_array_source_8 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
29509: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29510: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
29511: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
29512: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29513: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
29514: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
29515: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 29513: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

29509: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29510: TYPE t_array_source_10 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
29511: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
29512: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29513: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
29514: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
29515: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29516: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
29517: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 29515: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

29511: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
29512: TYPE t_array_source_13 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29513: TYPE t_array_source_14 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
29514: TYPE t_array_source_15 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
29515: TYPE t_array_source_16 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29516: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
29517: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
29518: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
29519: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 29521: TYPE t_array_source_33 IS TABLE OF CST_XLA_RCV_REF_V.PARENT_TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

29517: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
29518: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
29519: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29520: TYPE t_array_source_22 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
29521: TYPE t_array_source_33 IS TABLE OF CST_XLA_RCV_REF_V.PARENT_TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
29522: TYPE t_array_source_36 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
29523:
29524: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
29525: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 29624: , CST_XLA_RCV_REF_V h3

29620: , h1.TRANSFER_TO_GL_INDICATOR source_36
29621: , fvl36.meaning source_36_meaning
29622: FROM xla_events_gt xet
29623: , CST_XLA_RCV_HEADERS_V h1
29624: , CST_XLA_RCV_REF_V h3
29625: , PO_DISTS_REF_V h5
29626: , PO_HEADERS_REF_V h6
29627: , PSA_CST_XLA_UPG_V h7
29628: , fnd_lookup_values fvl13