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_INV_REF_V

Line 31225: WHEN 2 THEN 'CST_XLA_INV_REF_V'

31221: SELECT xet.event_id event_id
31222: , 0 line_number
31223: , CASE r
31224: WHEN 1 THEN 'PO_DISTS_REF_V'
31225: WHEN 2 THEN 'CST_XLA_INV_REF_V'
31226: WHEN 3 THEN 'CST_XLA_INV_REF_V'
31227: WHEN 4 THEN 'CST_XLA_INV_REF_V'
31228: WHEN 5 THEN 'CST_XLA_INV_REF_V'
31229: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 31226: WHEN 3 THEN 'CST_XLA_INV_REF_V'

31222: , 0 line_number
31223: , CASE r
31224: WHEN 1 THEN 'PO_DISTS_REF_V'
31225: WHEN 2 THEN 'CST_XLA_INV_REF_V'
31226: WHEN 3 THEN 'CST_XLA_INV_REF_V'
31227: WHEN 4 THEN 'CST_XLA_INV_REF_V'
31228: WHEN 5 THEN 'CST_XLA_INV_REF_V'
31229: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
31230: WHEN 7 THEN 'CST_XLA_INV_REF_V'

Line 31227: WHEN 4 THEN 'CST_XLA_INV_REF_V'

31223: , CASE r
31224: WHEN 1 THEN 'PO_DISTS_REF_V'
31225: WHEN 2 THEN 'CST_XLA_INV_REF_V'
31226: WHEN 3 THEN 'CST_XLA_INV_REF_V'
31227: WHEN 4 THEN 'CST_XLA_INV_REF_V'
31228: WHEN 5 THEN 'CST_XLA_INV_REF_V'
31229: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
31230: WHEN 7 THEN 'CST_XLA_INV_REF_V'
31231: WHEN 8 THEN 'CST_XLA_INV_REF_V'

Line 31228: WHEN 5 THEN 'CST_XLA_INV_REF_V'

31224: WHEN 1 THEN 'PO_DISTS_REF_V'
31225: WHEN 2 THEN 'CST_XLA_INV_REF_V'
31226: WHEN 3 THEN 'CST_XLA_INV_REF_V'
31227: WHEN 4 THEN 'CST_XLA_INV_REF_V'
31228: WHEN 5 THEN 'CST_XLA_INV_REF_V'
31229: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
31230: WHEN 7 THEN 'CST_XLA_INV_REF_V'
31231: WHEN 8 THEN 'CST_XLA_INV_REF_V'
31232: WHEN 9 THEN 'PSA_CST_XLA_UPG_V'

Line 31230: WHEN 7 THEN 'CST_XLA_INV_REF_V'

31226: WHEN 3 THEN 'CST_XLA_INV_REF_V'
31227: WHEN 4 THEN 'CST_XLA_INV_REF_V'
31228: WHEN 5 THEN 'CST_XLA_INV_REF_V'
31229: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
31230: WHEN 7 THEN 'CST_XLA_INV_REF_V'
31231: WHEN 8 THEN 'CST_XLA_INV_REF_V'
31232: WHEN 9 THEN 'PSA_CST_XLA_UPG_V'
31233: WHEN 10 THEN 'PO_HEADERS_REF_V'
31234: WHEN 11 THEN 'CST_XLA_INV_REF_V'

Line 31231: WHEN 8 THEN 'CST_XLA_INV_REF_V'

31227: WHEN 4 THEN 'CST_XLA_INV_REF_V'
31228: WHEN 5 THEN 'CST_XLA_INV_REF_V'
31229: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
31230: WHEN 7 THEN 'CST_XLA_INV_REF_V'
31231: WHEN 8 THEN 'CST_XLA_INV_REF_V'
31232: WHEN 9 THEN 'PSA_CST_XLA_UPG_V'
31233: WHEN 10 THEN 'PO_HEADERS_REF_V'
31234: WHEN 11 THEN 'CST_XLA_INV_REF_V'
31235: WHEN 12 THEN 'CST_XLA_INV_REF_V'

Line 31234: WHEN 11 THEN 'CST_XLA_INV_REF_V'

31230: WHEN 7 THEN 'CST_XLA_INV_REF_V'
31231: WHEN 8 THEN 'CST_XLA_INV_REF_V'
31232: WHEN 9 THEN 'PSA_CST_XLA_UPG_V'
31233: WHEN 10 THEN 'PO_HEADERS_REF_V'
31234: WHEN 11 THEN 'CST_XLA_INV_REF_V'
31235: WHEN 12 THEN 'CST_XLA_INV_REF_V'
31236: WHEN 13 THEN 'CST_XLA_INV_HEADERS_V'
31237:
31238: ELSE null

Line 31235: WHEN 12 THEN 'CST_XLA_INV_REF_V'

31231: WHEN 8 THEN 'CST_XLA_INV_REF_V'
31232: WHEN 9 THEN 'PSA_CST_XLA_UPG_V'
31233: WHEN 10 THEN 'PO_HEADERS_REF_V'
31234: WHEN 11 THEN 'CST_XLA_INV_REF_V'
31235: WHEN 12 THEN 'CST_XLA_INV_REF_V'
31236: WHEN 13 THEN 'CST_XLA_INV_HEADERS_V'
31237:
31238: ELSE null
31239: END object_name

Line 31317: , CST_XLA_INV_REF_V h3

31313: ELSE null
31314: END source_meaning
31315: FROM xla_events_gt xet
31316: , CST_XLA_INV_HEADERS_V h1
31317: , CST_XLA_INV_REF_V h3
31318: , PO_DISTS_REF_V h5
31319: , PO_HEADERS_REF_V h6
31320: , PSA_CST_XLA_UPG_V h7
31321: , fnd_lookup_values fvl13

Line 31648: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

31644: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
31645: --
31646:
31647: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
31648: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
31649: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
31650: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
31651: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
31652: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 31649: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

31645: --
31646:
31647: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
31648: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
31649: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
31650: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
31651: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
31652: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31653: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 31650: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

31646:
31647: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
31648: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
31649: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
31650: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
31651: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
31652: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31653: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
31654: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 31651: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

31647: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
31648: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
31649: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
31650: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
31651: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
31652: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31653: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
31654: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31655: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 31653: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

31649: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
31650: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
31651: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
31652: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31653: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
31654: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31655: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
31656: TYPE t_array_source_22 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
31657: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 31654: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

31650: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
31651: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
31652: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
31653: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
31654: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31655: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
31656: TYPE t_array_source_22 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
31657: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
31658: TYPE t_array_source_33 IS TABLE OF CST_XLA_INV_REF_V.PARENT_TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 31657: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

31653: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
31654: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31655: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
31656: TYPE t_array_source_22 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
31657: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
31658: TYPE t_array_source_33 IS TABLE OF CST_XLA_INV_REF_V.PARENT_TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
31659: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
31660:
31661: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;

Line 31658: TYPE t_array_source_33 IS TABLE OF CST_XLA_INV_REF_V.PARENT_TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

31654: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31655: TYPE t_array_source_17 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
31656: TYPE t_array_source_22 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
31657: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
31658: TYPE t_array_source_33 IS TABLE OF CST_XLA_INV_REF_V.PARENT_TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
31659: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
31660:
31661: TYPE t_array_source_1 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_EXPIRED_STATUS%TYPE INDEX BY BINARY_INTEGER;
31662: TYPE t_array_source_2 IS TABLE OF FV_XLA_CST_REF_V.FEDERAL_FUND_CATEGORY%TYPE INDEX BY BINARY_INTEGER;

Line 31759: , CST_XLA_INV_REF_V h3

31755: , h1.TRANSFER_TO_GL_INDICATOR source_36
31756: , fvl36.meaning source_36_meaning
31757: FROM xla_events_gt xet
31758: , CST_XLA_INV_HEADERS_V h1
31759: , CST_XLA_INV_REF_V h3
31760: , PO_DISTS_REF_V h5
31761: , PO_HEADERS_REF_V h6
31762: , PSA_CST_XLA_UPG_V h7
31763: , fnd_lookup_values fvl13