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'
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'
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'
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'
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'
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'
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
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
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
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;
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;
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;
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;
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;
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;
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;
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;
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