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_000020_BC_PKG dependencies on CST_XLA_INV_REF_V

Line 15158: WHEN 3 THEN 'CST_XLA_INV_REF_V'

15154: , 0 line_number
15155: , CASE r
15156: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
15157: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
15158: WHEN 3 THEN 'CST_XLA_INV_REF_V'
15159: WHEN 4 THEN 'CST_XLA_INV_REF_V'
15160: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
15161: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
15162: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'

Line 15159: WHEN 4 THEN 'CST_XLA_INV_REF_V'

15155: , CASE r
15156: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
15157: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
15158: WHEN 3 THEN 'CST_XLA_INV_REF_V'
15159: WHEN 4 THEN 'CST_XLA_INV_REF_V'
15160: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
15161: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
15162: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
15163: WHEN 8 THEN 'CST_XLA_INV_REF_V'

Line 15163: WHEN 8 THEN 'CST_XLA_INV_REF_V'

15159: WHEN 4 THEN 'CST_XLA_INV_REF_V'
15160: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
15161: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
15162: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
15163: WHEN 8 THEN 'CST_XLA_INV_REF_V'
15164: WHEN 9 THEN 'CST_XLA_INV_REF_V'
15165: WHEN 10 THEN 'CST_XLA_INV_REF_V'
15166: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
15167: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'

Line 15164: WHEN 9 THEN 'CST_XLA_INV_REF_V'

15160: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
15161: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
15162: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
15163: WHEN 8 THEN 'CST_XLA_INV_REF_V'
15164: WHEN 9 THEN 'CST_XLA_INV_REF_V'
15165: WHEN 10 THEN 'CST_XLA_INV_REF_V'
15166: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
15167: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
15168: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'

Line 15165: WHEN 10 THEN 'CST_XLA_INV_REF_V'

15161: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
15162: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
15163: WHEN 8 THEN 'CST_XLA_INV_REF_V'
15164: WHEN 9 THEN 'CST_XLA_INV_REF_V'
15165: WHEN 10 THEN 'CST_XLA_INV_REF_V'
15166: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
15167: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
15168: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
15169: WHEN 14 THEN 'CST_XLA_INV_REF_V'

Line 15169: WHEN 14 THEN 'CST_XLA_INV_REF_V'

15165: WHEN 10 THEN 'CST_XLA_INV_REF_V'
15166: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
15167: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
15168: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
15169: WHEN 14 THEN 'CST_XLA_INV_REF_V'
15170: WHEN 15 THEN 'CST_XLA_INV_REF_V'
15171: WHEN 16 THEN 'CST_XLA_INV_REF_V'
15172: WHEN 17 THEN 'CST_XLA_INV_REF_V'
15173: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'

Line 15170: WHEN 15 THEN 'CST_XLA_INV_REF_V'

15166: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
15167: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
15168: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
15169: WHEN 14 THEN 'CST_XLA_INV_REF_V'
15170: WHEN 15 THEN 'CST_XLA_INV_REF_V'
15171: WHEN 16 THEN 'CST_XLA_INV_REF_V'
15172: WHEN 17 THEN 'CST_XLA_INV_REF_V'
15173: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'
15174: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'

Line 15171: WHEN 16 THEN 'CST_XLA_INV_REF_V'

15167: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
15168: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
15169: WHEN 14 THEN 'CST_XLA_INV_REF_V'
15170: WHEN 15 THEN 'CST_XLA_INV_REF_V'
15171: WHEN 16 THEN 'CST_XLA_INV_REF_V'
15172: WHEN 17 THEN 'CST_XLA_INV_REF_V'
15173: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'
15174: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'
15175: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'

Line 15172: WHEN 17 THEN 'CST_XLA_INV_REF_V'

15168: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
15169: WHEN 14 THEN 'CST_XLA_INV_REF_V'
15170: WHEN 15 THEN 'CST_XLA_INV_REF_V'
15171: WHEN 16 THEN 'CST_XLA_INV_REF_V'
15172: WHEN 17 THEN 'CST_XLA_INV_REF_V'
15173: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'
15174: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'
15175: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'
15176:

Line 15285: , CST_XLA_INV_REF_V h4

15281: END source_meaning
15282: FROM xla_events_gt xet
15283: , CST_XLA_INV_HEADERS_V h1
15284: , CST_XLA_INV_ORG_PARAMS_REF_V h3
15285: , CST_XLA_INV_REF_V h4
15286: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
15287: , CST_XLA_INV_TXN_TYPES_REF_V h6
15288: , PO_REQ_DISTS_REF_V h7
15289: , PO_REQ_HEADERS_REF_V h8

Line 15543: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

15539: --
15540:
15541: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
15542: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
15543: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
15544: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
15545: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
15546: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
15547: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 15544: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

15540:
15541: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
15542: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
15543: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
15544: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
15545: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
15546: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
15547: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
15548: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 15548: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

15544: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
15545: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
15546: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
15547: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
15548: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
15549: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
15550: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
15551: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
15552: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 15549: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

15545: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
15546: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
15547: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
15548: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
15549: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
15550: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
15551: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
15552: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
15553: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 15550: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

15546: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
15547: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
15548: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
15549: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
15550: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
15551: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
15552: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
15553: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
15554: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 15554: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

15550: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
15551: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
15552: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
15553: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
15554: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
15555: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
15556: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
15557: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
15558: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 15555: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

15551: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
15552: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
15553: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
15554: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
15555: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
15556: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
15557: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
15558: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
15559: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 15556: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

15552: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
15553: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
15554: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
15555: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
15556: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
15557: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
15558: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
15559: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
15560: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 15557: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;

15553: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
15554: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
15555: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
15556: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
15557: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
15558: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
15559: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
15560: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
15561:

Line 15645: , CST_XLA_INV_REF_V h4

15641: , fvl42.meaning source_42_meaning
15642: FROM xla_events_gt xet
15643: , CST_XLA_INV_HEADERS_V h1
15644: , CST_XLA_INV_ORG_PARAMS_REF_V h3
15645: , CST_XLA_INV_REF_V h4
15646: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
15647: , CST_XLA_INV_TXN_TYPES_REF_V h6
15648: , PO_REQ_DISTS_REF_V h7
15649: , PO_REQ_HEADERS_REF_V h8

Line 16488: WHEN 3 THEN 'CST_XLA_INV_REF_V'

16484: , 0 line_number
16485: , CASE r
16486: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
16487: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
16488: WHEN 3 THEN 'CST_XLA_INV_REF_V'
16489: WHEN 4 THEN 'CST_XLA_INV_REF_V'
16490: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
16491: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
16492: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'

Line 16489: WHEN 4 THEN 'CST_XLA_INV_REF_V'

16485: , CASE r
16486: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
16487: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
16488: WHEN 3 THEN 'CST_XLA_INV_REF_V'
16489: WHEN 4 THEN 'CST_XLA_INV_REF_V'
16490: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
16491: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
16492: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
16493:

Line 16549: , CST_XLA_INV_REF_V h3

16545: ELSE null
16546: END source_meaning
16547: FROM xla_events_gt xet
16548: , CST_XLA_INV_HEADERS_V h1
16549: , CST_XLA_INV_REF_V h3
16550: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
16551: , CST_XLA_INV_TXN_TYPES_REF_V h5
16552: , fnd_lookup_values fvl9
16553: , fnd_lookup_values fvl42

Line 16838: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

16834: --
16835:
16836: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
16837: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
16838: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
16839: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
16840: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
16841: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16842: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 16839: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

16835:
16836: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
16837: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
16838: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
16839: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
16840: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
16841: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
16842: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
16843:

Line 16915: , CST_XLA_INV_REF_V h3

16911: , h1.TRANSFER_TO_GL_INDICATOR source_42
16912: , fvl42.meaning source_42_meaning
16913: FROM xla_events_gt xet
16914: , CST_XLA_INV_HEADERS_V h1
16915: , CST_XLA_INV_REF_V h3
16916: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
16917: , CST_XLA_INV_TXN_TYPES_REF_V h5
16918: , fnd_lookup_values fvl9
16919: , fnd_lookup_values fvl42

Line 17735: WHEN 3 THEN 'CST_XLA_INV_REF_V'

17731: , 0 line_number
17732: , CASE r
17733: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
17734: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
17735: WHEN 3 THEN 'CST_XLA_INV_REF_V'
17736: WHEN 4 THEN 'CST_XLA_INV_REF_V'
17737: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
17738: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
17739: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'

Line 17736: WHEN 4 THEN 'CST_XLA_INV_REF_V'

17732: , CASE r
17733: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
17734: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
17735: WHEN 3 THEN 'CST_XLA_INV_REF_V'
17736: WHEN 4 THEN 'CST_XLA_INV_REF_V'
17737: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
17738: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
17739: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
17740:

Line 17796: , CST_XLA_INV_REF_V h3

17792: ELSE null
17793: END source_meaning
17794: FROM xla_events_gt xet
17795: , CST_XLA_INV_HEADERS_V h1
17796: , CST_XLA_INV_REF_V h3
17797: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
17798: , CST_XLA_INV_TXN_TYPES_REF_V h5
17799: , fnd_lookup_values fvl9
17800: , fnd_lookup_values fvl42

Line 18085: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

18081: --
18082:
18083: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
18084: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
18085: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
18086: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
18087: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
18088: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18089: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 18086: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

18082:
18083: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
18084: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
18085: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
18086: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
18087: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
18088: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
18089: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
18090:

Line 18162: , CST_XLA_INV_REF_V h3

18158: , h1.TRANSFER_TO_GL_INDICATOR source_42
18159: , fvl42.meaning source_42_meaning
18160: FROM xla_events_gt xet
18161: , CST_XLA_INV_HEADERS_V h1
18162: , CST_XLA_INV_REF_V h3
18163: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
18164: , CST_XLA_INV_TXN_TYPES_REF_V h5
18165: , fnd_lookup_values fvl9
18166: , fnd_lookup_values fvl42

Line 18982: WHEN 3 THEN 'CST_XLA_INV_REF_V'

18978: , 0 line_number
18979: , CASE r
18980: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
18981: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
18982: WHEN 3 THEN 'CST_XLA_INV_REF_V'
18983: WHEN 4 THEN 'CST_XLA_INV_REF_V'
18984: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
18985: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
18986: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'

Line 18983: WHEN 4 THEN 'CST_XLA_INV_REF_V'

18979: , CASE r
18980: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
18981: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
18982: WHEN 3 THEN 'CST_XLA_INV_REF_V'
18983: WHEN 4 THEN 'CST_XLA_INV_REF_V'
18984: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
18985: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
18986: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
18987: WHEN 8 THEN 'CST_XLA_INV_REF_V'

Line 18987: WHEN 8 THEN 'CST_XLA_INV_REF_V'

18983: WHEN 4 THEN 'CST_XLA_INV_REF_V'
18984: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
18985: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
18986: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
18987: WHEN 8 THEN 'CST_XLA_INV_REF_V'
18988: WHEN 9 THEN 'CST_XLA_INV_REF_V'
18989: WHEN 10 THEN 'CST_XLA_INV_REF_V'
18990: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
18991: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'

Line 18988: WHEN 9 THEN 'CST_XLA_INV_REF_V'

18984: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
18985: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
18986: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
18987: WHEN 8 THEN 'CST_XLA_INV_REF_V'
18988: WHEN 9 THEN 'CST_XLA_INV_REF_V'
18989: WHEN 10 THEN 'CST_XLA_INV_REF_V'
18990: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
18991: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
18992: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'

Line 18989: WHEN 10 THEN 'CST_XLA_INV_REF_V'

18985: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
18986: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
18987: WHEN 8 THEN 'CST_XLA_INV_REF_V'
18988: WHEN 9 THEN 'CST_XLA_INV_REF_V'
18989: WHEN 10 THEN 'CST_XLA_INV_REF_V'
18990: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
18991: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
18992: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
18993: WHEN 14 THEN 'CST_XLA_INV_REF_V'

Line 18993: WHEN 14 THEN 'CST_XLA_INV_REF_V'

18989: WHEN 10 THEN 'CST_XLA_INV_REF_V'
18990: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
18991: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
18992: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
18993: WHEN 14 THEN 'CST_XLA_INV_REF_V'
18994: WHEN 15 THEN 'CST_XLA_INV_REF_V'
18995: WHEN 16 THEN 'CST_XLA_INV_REF_V'
18996: WHEN 17 THEN 'CST_XLA_INV_REF_V'
18997: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'

Line 18994: WHEN 15 THEN 'CST_XLA_INV_REF_V'

18990: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
18991: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
18992: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
18993: WHEN 14 THEN 'CST_XLA_INV_REF_V'
18994: WHEN 15 THEN 'CST_XLA_INV_REF_V'
18995: WHEN 16 THEN 'CST_XLA_INV_REF_V'
18996: WHEN 17 THEN 'CST_XLA_INV_REF_V'
18997: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'
18998: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'

Line 18995: WHEN 16 THEN 'CST_XLA_INV_REF_V'

18991: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
18992: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
18993: WHEN 14 THEN 'CST_XLA_INV_REF_V'
18994: WHEN 15 THEN 'CST_XLA_INV_REF_V'
18995: WHEN 16 THEN 'CST_XLA_INV_REF_V'
18996: WHEN 17 THEN 'CST_XLA_INV_REF_V'
18997: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'
18998: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'
18999: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'

Line 18996: WHEN 17 THEN 'CST_XLA_INV_REF_V'

18992: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
18993: WHEN 14 THEN 'CST_XLA_INV_REF_V'
18994: WHEN 15 THEN 'CST_XLA_INV_REF_V'
18995: WHEN 16 THEN 'CST_XLA_INV_REF_V'
18996: WHEN 17 THEN 'CST_XLA_INV_REF_V'
18997: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'
18998: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'
18999: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'
19000:

Line 19109: , CST_XLA_INV_REF_V h4

19105: END source_meaning
19106: FROM xla_events_gt xet
19107: , CST_XLA_INV_HEADERS_V h1
19108: , CST_XLA_INV_ORG_PARAMS_REF_V h3
19109: , CST_XLA_INV_REF_V h4
19110: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
19111: , CST_XLA_INV_TXN_TYPES_REF_V h6
19112: , PO_REQ_DISTS_REF_V h7
19113: , PO_REQ_HEADERS_REF_V h8

Line 19371: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

19367: --
19368:
19369: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
19370: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
19371: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
19372: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
19373: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
19374: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
19375: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 19372: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

19368:
19369: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
19370: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
19371: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
19372: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
19373: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
19374: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
19375: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
19376: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 19376: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

19372: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
19373: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
19374: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
19375: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
19376: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
19377: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
19378: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
19379: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
19380: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 19377: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

19373: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
19374: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
19375: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
19376: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
19377: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
19378: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
19379: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
19380: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
19381: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 19378: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

19374: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
19375: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
19376: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
19377: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
19378: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
19379: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
19380: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
19381: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
19382: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 19382: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

19378: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
19379: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
19380: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
19381: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
19382: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
19383: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
19384: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
19385: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
19386: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 19383: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

19379: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
19380: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
19381: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
19382: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
19383: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
19384: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
19385: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
19386: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
19387: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 19384: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

19380: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
19381: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
19382: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
19383: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
19384: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
19385: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
19386: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
19387: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
19388: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 19385: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;

19381: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
19382: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
19383: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
19384: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
19385: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
19386: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
19387: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
19388: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
19389:

Line 19476: , CST_XLA_INV_REF_V h4

19472: , fvl42.meaning source_42_meaning
19473: FROM xla_events_gt xet
19474: , CST_XLA_INV_HEADERS_V h1
19475: , CST_XLA_INV_ORG_PARAMS_REF_V h3
19476: , CST_XLA_INV_REF_V h4
19477: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
19478: , CST_XLA_INV_TXN_TYPES_REF_V h6
19479: , PO_REQ_DISTS_REF_V h7
19480: , PO_REQ_HEADERS_REF_V h8

Line 20322: WHEN 3 THEN 'CST_XLA_INV_REF_V'

20318: , 0 line_number
20319: , CASE r
20320: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
20321: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
20322: WHEN 3 THEN 'CST_XLA_INV_REF_V'
20323: WHEN 4 THEN 'CST_XLA_INV_REF_V'
20324: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
20325: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
20326: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'

Line 20323: WHEN 4 THEN 'CST_XLA_INV_REF_V'

20319: , CASE r
20320: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
20321: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
20322: WHEN 3 THEN 'CST_XLA_INV_REF_V'
20323: WHEN 4 THEN 'CST_XLA_INV_REF_V'
20324: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
20325: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
20326: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
20327: WHEN 8 THEN 'CST_XLA_INV_REF_V'

Line 20327: WHEN 8 THEN 'CST_XLA_INV_REF_V'

20323: WHEN 4 THEN 'CST_XLA_INV_REF_V'
20324: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
20325: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
20326: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
20327: WHEN 8 THEN 'CST_XLA_INV_REF_V'
20328: WHEN 9 THEN 'CST_XLA_INV_REF_V'
20329: WHEN 10 THEN 'CST_XLA_INV_REF_V'
20330: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
20331: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'

Line 20328: WHEN 9 THEN 'CST_XLA_INV_REF_V'

20324: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
20325: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
20326: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
20327: WHEN 8 THEN 'CST_XLA_INV_REF_V'
20328: WHEN 9 THEN 'CST_XLA_INV_REF_V'
20329: WHEN 10 THEN 'CST_XLA_INV_REF_V'
20330: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
20331: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
20332: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'

Line 20329: WHEN 10 THEN 'CST_XLA_INV_REF_V'

20325: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
20326: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
20327: WHEN 8 THEN 'CST_XLA_INV_REF_V'
20328: WHEN 9 THEN 'CST_XLA_INV_REF_V'
20329: WHEN 10 THEN 'CST_XLA_INV_REF_V'
20330: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
20331: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
20332: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
20333: WHEN 14 THEN 'CST_XLA_INV_REF_V'

Line 20333: WHEN 14 THEN 'CST_XLA_INV_REF_V'

20329: WHEN 10 THEN 'CST_XLA_INV_REF_V'
20330: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
20331: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
20332: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
20333: WHEN 14 THEN 'CST_XLA_INV_REF_V'
20334: WHEN 15 THEN 'CST_XLA_INV_REF_V'
20335: WHEN 16 THEN 'CST_XLA_INV_REF_V'
20336: WHEN 17 THEN 'CST_XLA_INV_REF_V'
20337: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'

Line 20334: WHEN 15 THEN 'CST_XLA_INV_REF_V'

20330: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
20331: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
20332: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
20333: WHEN 14 THEN 'CST_XLA_INV_REF_V'
20334: WHEN 15 THEN 'CST_XLA_INV_REF_V'
20335: WHEN 16 THEN 'CST_XLA_INV_REF_V'
20336: WHEN 17 THEN 'CST_XLA_INV_REF_V'
20337: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'
20338: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'

Line 20335: WHEN 16 THEN 'CST_XLA_INV_REF_V'

20331: WHEN 12 THEN 'PO_REQ_HEADERS_REF_V'
20332: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
20333: WHEN 14 THEN 'CST_XLA_INV_REF_V'
20334: WHEN 15 THEN 'CST_XLA_INV_REF_V'
20335: WHEN 16 THEN 'CST_XLA_INV_REF_V'
20336: WHEN 17 THEN 'CST_XLA_INV_REF_V'
20337: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'
20338: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'
20339: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'

Line 20336: WHEN 17 THEN 'CST_XLA_INV_REF_V'

20332: WHEN 13 THEN 'PO_REQ_DISTS_REF_V'
20333: WHEN 14 THEN 'CST_XLA_INV_REF_V'
20334: WHEN 15 THEN 'CST_XLA_INV_REF_V'
20335: WHEN 16 THEN 'CST_XLA_INV_REF_V'
20336: WHEN 17 THEN 'CST_XLA_INV_REF_V'
20337: WHEN 18 THEN 'PO_REQ_DISTS_REF_V'
20338: WHEN 19 THEN 'PO_REQ_HEADERS_REF_V'
20339: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'
20340:

Line 20449: , CST_XLA_INV_REF_V h4

20445: END source_meaning
20446: FROM xla_events_gt xet
20447: , CST_XLA_INV_HEADERS_V h1
20448: , CST_XLA_INV_ORG_PARAMS_REF_V h3
20449: , CST_XLA_INV_REF_V h4
20450: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
20451: , CST_XLA_INV_TXN_TYPES_REF_V h6
20452: , PO_REQ_DISTS_REF_V h7
20453: , PO_REQ_HEADERS_REF_V h8

Line 20711: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

20707: --
20708:
20709: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
20710: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
20711: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
20712: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
20713: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
20714: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
20715: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 20712: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

20708:
20709: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
20710: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
20711: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
20712: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
20713: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
20714: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
20715: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
20716: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 20716: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

20712: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
20713: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
20714: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
20715: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
20716: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
20717: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
20718: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
20719: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
20720: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 20717: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

20713: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
20714: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
20715: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
20716: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
20717: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
20718: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
20719: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
20720: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
20721: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 20718: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

20714: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
20715: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
20716: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
20717: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
20718: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
20719: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
20720: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
20721: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
20722: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 20722: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;

20718: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
20719: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
20720: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
20721: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
20722: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
20723: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
20724: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
20725: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
20726: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 20723: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

20719: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
20720: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
20721: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
20722: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
20723: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
20724: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
20725: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
20726: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
20727: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 20724: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

20720: TYPE t_array_source_33 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
20721: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
20722: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
20723: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
20724: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
20725: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
20726: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
20727: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
20728: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 20725: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;

20721: TYPE t_array_source_34 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
20722: TYPE t_array_source_35 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_TYPE%TYPE INDEX BY BINARY_INTEGER;
20723: TYPE t_array_source_36 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
20724: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
20725: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_REF_V.BUS_FLOW_REQ_ID%TYPE INDEX BY BINARY_INTEGER;
20726: TYPE t_array_source_39 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
20727: TYPE t_array_source_40 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
20728: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
20729:

Line 20816: , CST_XLA_INV_REF_V h4

20812: , fvl42.meaning source_42_meaning
20813: FROM xla_events_gt xet
20814: , CST_XLA_INV_HEADERS_V h1
20815: , CST_XLA_INV_ORG_PARAMS_REF_V h3
20816: , CST_XLA_INV_REF_V h4
20817: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
20818: , CST_XLA_INV_TXN_TYPES_REF_V h6
20819: , PO_REQ_DISTS_REF_V h7
20820: , PO_REQ_HEADERS_REF_V h8

Line 24018: WHEN 3 THEN 'CST_XLA_INV_REF_V'

24014: , 0 line_number
24015: , CASE r
24016: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
24017: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
24018: WHEN 3 THEN 'CST_XLA_INV_REF_V'
24019: WHEN 4 THEN 'CST_XLA_INV_REF_V'
24020: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
24021: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
24022: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'

Line 24019: WHEN 4 THEN 'CST_XLA_INV_REF_V'

24015: , CASE r
24016: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
24017: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
24018: WHEN 3 THEN 'CST_XLA_INV_REF_V'
24019: WHEN 4 THEN 'CST_XLA_INV_REF_V'
24020: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
24021: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
24022: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
24023:

Line 24079: , CST_XLA_INV_REF_V h3

24075: ELSE null
24076: END source_meaning
24077: FROM xla_events_gt xet
24078: , CST_XLA_INV_HEADERS_V h1
24079: , CST_XLA_INV_REF_V h3
24080: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
24081: , CST_XLA_INV_TXN_TYPES_REF_V h5
24082: , fnd_lookup_values fvl9
24083: , fnd_lookup_values fvl42

Line 24368: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

24364: --
24365:
24366: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
24367: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
24368: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
24369: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
24370: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
24371: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24372: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 24369: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

24365:
24366: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
24367: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
24368: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
24369: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
24370: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
24371: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
24372: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
24373:

Line 24445: , CST_XLA_INV_REF_V h3

24441: , h1.TRANSFER_TO_GL_INDICATOR source_42
24442: , fvl42.meaning source_42_meaning
24443: FROM xla_events_gt xet
24444: , CST_XLA_INV_HEADERS_V h1
24445: , CST_XLA_INV_REF_V h3
24446: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
24447: , CST_XLA_INV_TXN_TYPES_REF_V h5
24448: , fnd_lookup_values fvl9
24449: , fnd_lookup_values fvl42

Line 25265: WHEN 3 THEN 'CST_XLA_INV_REF_V'

25261: , 0 line_number
25262: , CASE r
25263: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
25264: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
25265: WHEN 3 THEN 'CST_XLA_INV_REF_V'
25266: WHEN 4 THEN 'CST_XLA_INV_REF_V'
25267: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
25268: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
25269: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'

Line 25266: WHEN 4 THEN 'CST_XLA_INV_REF_V'

25262: , CASE r
25263: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
25264: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
25265: WHEN 3 THEN 'CST_XLA_INV_REF_V'
25266: WHEN 4 THEN 'CST_XLA_INV_REF_V'
25267: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
25268: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
25269: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
25270:

Line 25326: , CST_XLA_INV_REF_V h3

25322: ELSE null
25323: END source_meaning
25324: FROM xla_events_gt xet
25325: , CST_XLA_INV_HEADERS_V h1
25326: , CST_XLA_INV_REF_V h3
25327: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
25328: , CST_XLA_INV_TXN_TYPES_REF_V h5
25329: , fnd_lookup_values fvl9
25330: , fnd_lookup_values fvl42

Line 25615: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

25611: --
25612:
25613: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
25614: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
25615: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
25616: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
25617: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
25618: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25619: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 25616: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

25612:
25613: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
25614: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
25615: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
25616: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
25617: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
25618: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
25619: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
25620:

Line 25692: , CST_XLA_INV_REF_V h3

25688: , h1.TRANSFER_TO_GL_INDICATOR source_42
25689: , fvl42.meaning source_42_meaning
25690: FROM xla_events_gt xet
25691: , CST_XLA_INV_HEADERS_V h1
25692: , CST_XLA_INV_REF_V h3
25693: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
25694: , CST_XLA_INV_TXN_TYPES_REF_V h5
25695: , fnd_lookup_values fvl9
25696: , fnd_lookup_values fvl42

Line 26512: WHEN 3 THEN 'CST_XLA_INV_REF_V'

26508: , 0 line_number
26509: , CASE r
26510: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
26511: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
26512: WHEN 3 THEN 'CST_XLA_INV_REF_V'
26513: WHEN 4 THEN 'CST_XLA_INV_REF_V'
26514: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
26515: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
26516: WHEN 7 THEN 'PO_HEADERS_REF_V'

Line 26513: WHEN 4 THEN 'CST_XLA_INV_REF_V'

26509: , CASE r
26510: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
26511: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
26512: WHEN 3 THEN 'CST_XLA_INV_REF_V'
26513: WHEN 4 THEN 'CST_XLA_INV_REF_V'
26514: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
26515: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
26516: WHEN 7 THEN 'PO_HEADERS_REF_V'
26517: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'

Line 26518: WHEN 9 THEN 'CST_XLA_INV_REF_V'

26514: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
26515: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
26516: WHEN 7 THEN 'PO_HEADERS_REF_V'
26517: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
26518: WHEN 9 THEN 'CST_XLA_INV_REF_V'
26519: WHEN 10 THEN 'CST_XLA_INV_REF_V'
26520: WHEN 11 THEN 'CST_XLA_INV_REF_V'
26521: WHEN 12 THEN 'CST_XLA_INV_REF_V'
26522: WHEN 13 THEN 'CST_XLA_INV_REF_V'

Line 26519: WHEN 10 THEN 'CST_XLA_INV_REF_V'

26515: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
26516: WHEN 7 THEN 'PO_HEADERS_REF_V'
26517: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
26518: WHEN 9 THEN 'CST_XLA_INV_REF_V'
26519: WHEN 10 THEN 'CST_XLA_INV_REF_V'
26520: WHEN 11 THEN 'CST_XLA_INV_REF_V'
26521: WHEN 12 THEN 'CST_XLA_INV_REF_V'
26522: WHEN 13 THEN 'CST_XLA_INV_REF_V'
26523: WHEN 14 THEN 'PO_DISTS_REF_V'

Line 26520: WHEN 11 THEN 'CST_XLA_INV_REF_V'

26516: WHEN 7 THEN 'PO_HEADERS_REF_V'
26517: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
26518: WHEN 9 THEN 'CST_XLA_INV_REF_V'
26519: WHEN 10 THEN 'CST_XLA_INV_REF_V'
26520: WHEN 11 THEN 'CST_XLA_INV_REF_V'
26521: WHEN 12 THEN 'CST_XLA_INV_REF_V'
26522: WHEN 13 THEN 'CST_XLA_INV_REF_V'
26523: WHEN 14 THEN 'PO_DISTS_REF_V'
26524: WHEN 15 THEN 'CST_XLA_INV_REF_V'

Line 26521: WHEN 12 THEN 'CST_XLA_INV_REF_V'

26517: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
26518: WHEN 9 THEN 'CST_XLA_INV_REF_V'
26519: WHEN 10 THEN 'CST_XLA_INV_REF_V'
26520: WHEN 11 THEN 'CST_XLA_INV_REF_V'
26521: WHEN 12 THEN 'CST_XLA_INV_REF_V'
26522: WHEN 13 THEN 'CST_XLA_INV_REF_V'
26523: WHEN 14 THEN 'PO_DISTS_REF_V'
26524: WHEN 15 THEN 'CST_XLA_INV_REF_V'
26525: WHEN 16 THEN 'CST_XLA_INV_REF_V'

Line 26522: WHEN 13 THEN 'CST_XLA_INV_REF_V'

26518: WHEN 9 THEN 'CST_XLA_INV_REF_V'
26519: WHEN 10 THEN 'CST_XLA_INV_REF_V'
26520: WHEN 11 THEN 'CST_XLA_INV_REF_V'
26521: WHEN 12 THEN 'CST_XLA_INV_REF_V'
26522: WHEN 13 THEN 'CST_XLA_INV_REF_V'
26523: WHEN 14 THEN 'PO_DISTS_REF_V'
26524: WHEN 15 THEN 'CST_XLA_INV_REF_V'
26525: WHEN 16 THEN 'CST_XLA_INV_REF_V'
26526: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'

Line 26524: WHEN 15 THEN 'CST_XLA_INV_REF_V'

26520: WHEN 11 THEN 'CST_XLA_INV_REF_V'
26521: WHEN 12 THEN 'CST_XLA_INV_REF_V'
26522: WHEN 13 THEN 'CST_XLA_INV_REF_V'
26523: WHEN 14 THEN 'PO_DISTS_REF_V'
26524: WHEN 15 THEN 'CST_XLA_INV_REF_V'
26525: WHEN 16 THEN 'CST_XLA_INV_REF_V'
26526: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
26527: WHEN 18 THEN 'PO_HEADERS_REF_V'
26528: WHEN 19 THEN 'PO_DISTS_REF_V'

Line 26525: WHEN 16 THEN 'CST_XLA_INV_REF_V'

26521: WHEN 12 THEN 'CST_XLA_INV_REF_V'
26522: WHEN 13 THEN 'CST_XLA_INV_REF_V'
26523: WHEN 14 THEN 'PO_DISTS_REF_V'
26524: WHEN 15 THEN 'CST_XLA_INV_REF_V'
26525: WHEN 16 THEN 'CST_XLA_INV_REF_V'
26526: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
26527: WHEN 18 THEN 'PO_HEADERS_REF_V'
26528: WHEN 19 THEN 'PO_DISTS_REF_V'
26529: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'

Line 26639: , CST_XLA_INV_REF_V h4

26635: END source_meaning
26636: FROM xla_events_gt xet
26637: , CST_XLA_INV_HEADERS_V h1
26638: , CST_XLA_INV_ORG_PARAMS_REF_V h3
26639: , CST_XLA_INV_REF_V h4
26640: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
26641: , CST_XLA_INV_TXN_TYPES_REF_V h6
26642: , PO_DISTS_REF_V h7
26643: , PO_HEADERS_REF_V h8

Line 26902: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

26898: --
26899:
26900: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
26901: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
26902: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
26903: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
26904: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
26905: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
26906: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 26903: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

26899:
26900: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
26901: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
26902: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
26903: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
26904: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
26905: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
26906: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
26907: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 26908: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

26904: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
26905: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
26906: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
26907: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
26908: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
26909: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
26910: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
26911: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
26912: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

Line 26909: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

26905: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
26906: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
26907: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
26908: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
26909: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
26910: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
26911: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
26912: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
26913: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 26910: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

26906: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
26907: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
26908: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
26909: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
26910: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
26911: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
26912: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
26913: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
26914: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 26911: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

26907: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
26908: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
26909: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
26910: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
26911: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
26912: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
26913: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
26914: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
26915: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 26912: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

26908: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
26909: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
26910: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
26911: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
26912: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
26913: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
26914: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
26915: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
26916: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 26914: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

26910: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
26911: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
26912: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
26913: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
26914: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
26915: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
26916: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
26917: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
26918: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 26915: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

26911: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
26912: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
26913: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
26914: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
26915: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
26916: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
26917: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
26918: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
26919: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 27007: , CST_XLA_INV_REF_V h4

27003: , fvl42.meaning source_42_meaning
27004: FROM xla_events_gt xet
27005: , CST_XLA_INV_HEADERS_V h1
27006: , CST_XLA_INV_ORG_PARAMS_REF_V h3
27007: , CST_XLA_INV_REF_V h4
27008: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
27009: , CST_XLA_INV_TXN_TYPES_REF_V h6
27010: , PO_DISTS_REF_V h7
27011: , PO_HEADERS_REF_V h8

Line 27888: WHEN 3 THEN 'CST_XLA_INV_REF_V'

27884: , 0 line_number
27885: , CASE r
27886: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
27887: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
27888: WHEN 3 THEN 'CST_XLA_INV_REF_V'
27889: WHEN 4 THEN 'CST_XLA_INV_REF_V'
27890: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
27891: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
27892: WHEN 7 THEN 'PO_HEADERS_REF_V'

Line 27889: WHEN 4 THEN 'CST_XLA_INV_REF_V'

27885: , CASE r
27886: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
27887: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
27888: WHEN 3 THEN 'CST_XLA_INV_REF_V'
27889: WHEN 4 THEN 'CST_XLA_INV_REF_V'
27890: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
27891: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
27892: WHEN 7 THEN 'PO_HEADERS_REF_V'
27893: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'

Line 27894: WHEN 9 THEN 'CST_XLA_INV_REF_V'

27890: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
27891: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
27892: WHEN 7 THEN 'PO_HEADERS_REF_V'
27893: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
27894: WHEN 9 THEN 'CST_XLA_INV_REF_V'
27895: WHEN 10 THEN 'CST_XLA_INV_REF_V'
27896: WHEN 11 THEN 'CST_XLA_INV_REF_V'
27897: WHEN 12 THEN 'CST_XLA_INV_REF_V'
27898: WHEN 13 THEN 'CST_XLA_INV_REF_V'

Line 27895: WHEN 10 THEN 'CST_XLA_INV_REF_V'

27891: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
27892: WHEN 7 THEN 'PO_HEADERS_REF_V'
27893: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
27894: WHEN 9 THEN 'CST_XLA_INV_REF_V'
27895: WHEN 10 THEN 'CST_XLA_INV_REF_V'
27896: WHEN 11 THEN 'CST_XLA_INV_REF_V'
27897: WHEN 12 THEN 'CST_XLA_INV_REF_V'
27898: WHEN 13 THEN 'CST_XLA_INV_REF_V'
27899: WHEN 14 THEN 'PO_DISTS_REF_V'

Line 27896: WHEN 11 THEN 'CST_XLA_INV_REF_V'

27892: WHEN 7 THEN 'PO_HEADERS_REF_V'
27893: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
27894: WHEN 9 THEN 'CST_XLA_INV_REF_V'
27895: WHEN 10 THEN 'CST_XLA_INV_REF_V'
27896: WHEN 11 THEN 'CST_XLA_INV_REF_V'
27897: WHEN 12 THEN 'CST_XLA_INV_REF_V'
27898: WHEN 13 THEN 'CST_XLA_INV_REF_V'
27899: WHEN 14 THEN 'PO_DISTS_REF_V'
27900: WHEN 15 THEN 'CST_XLA_INV_REF_V'

Line 27897: WHEN 12 THEN 'CST_XLA_INV_REF_V'

27893: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
27894: WHEN 9 THEN 'CST_XLA_INV_REF_V'
27895: WHEN 10 THEN 'CST_XLA_INV_REF_V'
27896: WHEN 11 THEN 'CST_XLA_INV_REF_V'
27897: WHEN 12 THEN 'CST_XLA_INV_REF_V'
27898: WHEN 13 THEN 'CST_XLA_INV_REF_V'
27899: WHEN 14 THEN 'PO_DISTS_REF_V'
27900: WHEN 15 THEN 'CST_XLA_INV_REF_V'
27901: WHEN 16 THEN 'CST_XLA_INV_REF_V'

Line 27898: WHEN 13 THEN 'CST_XLA_INV_REF_V'

27894: WHEN 9 THEN 'CST_XLA_INV_REF_V'
27895: WHEN 10 THEN 'CST_XLA_INV_REF_V'
27896: WHEN 11 THEN 'CST_XLA_INV_REF_V'
27897: WHEN 12 THEN 'CST_XLA_INV_REF_V'
27898: WHEN 13 THEN 'CST_XLA_INV_REF_V'
27899: WHEN 14 THEN 'PO_DISTS_REF_V'
27900: WHEN 15 THEN 'CST_XLA_INV_REF_V'
27901: WHEN 16 THEN 'CST_XLA_INV_REF_V'
27902: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'

Line 27900: WHEN 15 THEN 'CST_XLA_INV_REF_V'

27896: WHEN 11 THEN 'CST_XLA_INV_REF_V'
27897: WHEN 12 THEN 'CST_XLA_INV_REF_V'
27898: WHEN 13 THEN 'CST_XLA_INV_REF_V'
27899: WHEN 14 THEN 'PO_DISTS_REF_V'
27900: WHEN 15 THEN 'CST_XLA_INV_REF_V'
27901: WHEN 16 THEN 'CST_XLA_INV_REF_V'
27902: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
27903: WHEN 18 THEN 'PO_HEADERS_REF_V'
27904: WHEN 19 THEN 'PO_DISTS_REF_V'

Line 27901: WHEN 16 THEN 'CST_XLA_INV_REF_V'

27897: WHEN 12 THEN 'CST_XLA_INV_REF_V'
27898: WHEN 13 THEN 'CST_XLA_INV_REF_V'
27899: WHEN 14 THEN 'PO_DISTS_REF_V'
27900: WHEN 15 THEN 'CST_XLA_INV_REF_V'
27901: WHEN 16 THEN 'CST_XLA_INV_REF_V'
27902: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
27903: WHEN 18 THEN 'PO_HEADERS_REF_V'
27904: WHEN 19 THEN 'PO_DISTS_REF_V'
27905: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'

Line 28015: , CST_XLA_INV_REF_V h4

28011: END source_meaning
28012: FROM xla_events_gt xet
28013: , CST_XLA_INV_HEADERS_V h1
28014: , CST_XLA_INV_ORG_PARAMS_REF_V h3
28015: , CST_XLA_INV_REF_V h4
28016: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
28017: , CST_XLA_INV_TXN_TYPES_REF_V h6
28018: , PO_DISTS_REF_V h7
28019: , PO_HEADERS_REF_V h8

Line 28278: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

28274: --
28275:
28276: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
28277: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
28278: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
28279: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
28280: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
28281: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
28282: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 28279: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

28275:
28276: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
28277: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
28278: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
28279: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
28280: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
28281: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
28282: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
28283: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 28284: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

28280: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
28281: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
28282: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
28283: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
28284: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
28285: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
28286: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
28287: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
28288: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

Line 28285: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

28281: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
28282: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
28283: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
28284: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
28285: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
28286: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
28287: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
28288: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
28289: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 28286: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

28282: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
28283: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
28284: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
28285: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
28286: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
28287: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
28288: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
28289: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
28290: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 28287: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

28283: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
28284: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
28285: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
28286: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
28287: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
28288: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
28289: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
28290: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
28291: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 28288: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

28284: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
28285: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
28286: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
28287: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
28288: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
28289: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
28290: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
28291: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
28292: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 28290: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

28286: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
28287: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
28288: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
28289: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
28290: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
28291: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
28292: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
28293: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
28294: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 28291: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

28287: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
28288: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
28289: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
28290: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
28291: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
28292: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
28293: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
28294: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
28295: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 28383: , CST_XLA_INV_REF_V h4

28379: , fvl42.meaning source_42_meaning
28380: FROM xla_events_gt xet
28381: , CST_XLA_INV_HEADERS_V h1
28382: , CST_XLA_INV_ORG_PARAMS_REF_V h3
28383: , CST_XLA_INV_REF_V h4
28384: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
28385: , CST_XLA_INV_TXN_TYPES_REF_V h6
28386: , PO_DISTS_REF_V h7
28387: , PO_HEADERS_REF_V h8

Line 29264: WHEN 3 THEN 'CST_XLA_INV_REF_V'

29260: , 0 line_number
29261: , CASE r
29262: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
29263: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
29264: WHEN 3 THEN 'CST_XLA_INV_REF_V'
29265: WHEN 4 THEN 'CST_XLA_INV_REF_V'
29266: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
29267: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
29268: WHEN 7 THEN 'PO_HEADERS_REF_V'

Line 29265: WHEN 4 THEN 'CST_XLA_INV_REF_V'

29261: , CASE r
29262: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
29263: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
29264: WHEN 3 THEN 'CST_XLA_INV_REF_V'
29265: WHEN 4 THEN 'CST_XLA_INV_REF_V'
29266: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
29267: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
29268: WHEN 7 THEN 'PO_HEADERS_REF_V'
29269: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'

Line 29270: WHEN 9 THEN 'CST_XLA_INV_REF_V'

29266: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
29267: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
29268: WHEN 7 THEN 'PO_HEADERS_REF_V'
29269: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
29270: WHEN 9 THEN 'CST_XLA_INV_REF_V'
29271: WHEN 10 THEN 'CST_XLA_INV_REF_V'
29272: WHEN 11 THEN 'CST_XLA_INV_REF_V'
29273: WHEN 12 THEN 'CST_XLA_INV_REF_V'
29274: WHEN 13 THEN 'CST_XLA_INV_REF_V'

Line 29271: WHEN 10 THEN 'CST_XLA_INV_REF_V'

29267: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
29268: WHEN 7 THEN 'PO_HEADERS_REF_V'
29269: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
29270: WHEN 9 THEN 'CST_XLA_INV_REF_V'
29271: WHEN 10 THEN 'CST_XLA_INV_REF_V'
29272: WHEN 11 THEN 'CST_XLA_INV_REF_V'
29273: WHEN 12 THEN 'CST_XLA_INV_REF_V'
29274: WHEN 13 THEN 'CST_XLA_INV_REF_V'
29275: WHEN 14 THEN 'PO_DISTS_REF_V'

Line 29272: WHEN 11 THEN 'CST_XLA_INV_REF_V'

29268: WHEN 7 THEN 'PO_HEADERS_REF_V'
29269: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
29270: WHEN 9 THEN 'CST_XLA_INV_REF_V'
29271: WHEN 10 THEN 'CST_XLA_INV_REF_V'
29272: WHEN 11 THEN 'CST_XLA_INV_REF_V'
29273: WHEN 12 THEN 'CST_XLA_INV_REF_V'
29274: WHEN 13 THEN 'CST_XLA_INV_REF_V'
29275: WHEN 14 THEN 'PO_DISTS_REF_V'
29276: WHEN 15 THEN 'CST_XLA_INV_REF_V'

Line 29273: WHEN 12 THEN 'CST_XLA_INV_REF_V'

29269: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
29270: WHEN 9 THEN 'CST_XLA_INV_REF_V'
29271: WHEN 10 THEN 'CST_XLA_INV_REF_V'
29272: WHEN 11 THEN 'CST_XLA_INV_REF_V'
29273: WHEN 12 THEN 'CST_XLA_INV_REF_V'
29274: WHEN 13 THEN 'CST_XLA_INV_REF_V'
29275: WHEN 14 THEN 'PO_DISTS_REF_V'
29276: WHEN 15 THEN 'CST_XLA_INV_REF_V'
29277: WHEN 16 THEN 'CST_XLA_INV_REF_V'

Line 29274: WHEN 13 THEN 'CST_XLA_INV_REF_V'

29270: WHEN 9 THEN 'CST_XLA_INV_REF_V'
29271: WHEN 10 THEN 'CST_XLA_INV_REF_V'
29272: WHEN 11 THEN 'CST_XLA_INV_REF_V'
29273: WHEN 12 THEN 'CST_XLA_INV_REF_V'
29274: WHEN 13 THEN 'CST_XLA_INV_REF_V'
29275: WHEN 14 THEN 'PO_DISTS_REF_V'
29276: WHEN 15 THEN 'CST_XLA_INV_REF_V'
29277: WHEN 16 THEN 'CST_XLA_INV_REF_V'
29278: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'

Line 29276: WHEN 15 THEN 'CST_XLA_INV_REF_V'

29272: WHEN 11 THEN 'CST_XLA_INV_REF_V'
29273: WHEN 12 THEN 'CST_XLA_INV_REF_V'
29274: WHEN 13 THEN 'CST_XLA_INV_REF_V'
29275: WHEN 14 THEN 'PO_DISTS_REF_V'
29276: WHEN 15 THEN 'CST_XLA_INV_REF_V'
29277: WHEN 16 THEN 'CST_XLA_INV_REF_V'
29278: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
29279: WHEN 18 THEN 'PO_HEADERS_REF_V'
29280: WHEN 19 THEN 'PO_DISTS_REF_V'

Line 29277: WHEN 16 THEN 'CST_XLA_INV_REF_V'

29273: WHEN 12 THEN 'CST_XLA_INV_REF_V'
29274: WHEN 13 THEN 'CST_XLA_INV_REF_V'
29275: WHEN 14 THEN 'PO_DISTS_REF_V'
29276: WHEN 15 THEN 'CST_XLA_INV_REF_V'
29277: WHEN 16 THEN 'CST_XLA_INV_REF_V'
29278: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
29279: WHEN 18 THEN 'PO_HEADERS_REF_V'
29280: WHEN 19 THEN 'PO_DISTS_REF_V'
29281: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'

Line 29391: , CST_XLA_INV_REF_V h4

29387: END source_meaning
29388: FROM xla_events_gt xet
29389: , CST_XLA_INV_HEADERS_V h1
29390: , CST_XLA_INV_ORG_PARAMS_REF_V h3
29391: , CST_XLA_INV_REF_V h4
29392: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
29393: , CST_XLA_INV_TXN_TYPES_REF_V h6
29394: , PO_DISTS_REF_V h7
29395: , PO_HEADERS_REF_V h8

Line 29654: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

29650: --
29651:
29652: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
29653: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
29654: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
29655: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
29656: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
29657: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29658: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 29655: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

29651:
29652: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
29653: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
29654: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
29655: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
29656: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
29657: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29658: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
29659: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 29660: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

29656: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
29657: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29658: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
29659: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
29660: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
29661: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
29662: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29663: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
29664: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

Line 29661: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

29657: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
29658: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
29659: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
29660: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
29661: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
29662: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29663: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
29664: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
29665: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 29662: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

29658: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
29659: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
29660: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
29661: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
29662: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29663: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
29664: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
29665: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
29666: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 29663: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

29659: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
29660: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
29661: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
29662: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29663: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
29664: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
29665: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
29666: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
29667: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 29664: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

29660: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
29661: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
29662: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29663: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
29664: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
29665: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
29666: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
29667: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29668: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 29666: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

29662: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29663: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
29664: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
29665: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
29666: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
29667: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29668: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
29669: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
29670: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 29667: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

29663: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
29664: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
29665: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
29666: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
29667: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
29668: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
29669: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
29670: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
29671: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 29759: , CST_XLA_INV_REF_V h4

29755: , fvl42.meaning source_42_meaning
29756: FROM xla_events_gt xet
29757: , CST_XLA_INV_HEADERS_V h1
29758: , CST_XLA_INV_ORG_PARAMS_REF_V h3
29759: , CST_XLA_INV_REF_V h4
29760: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
29761: , CST_XLA_INV_TXN_TYPES_REF_V h6
29762: , PO_DISTS_REF_V h7
29763: , PO_HEADERS_REF_V h8

Line 31936: WHEN 3 THEN 'CST_XLA_INV_REF_V'

31932: , 0 line_number
31933: , CASE r
31934: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
31935: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
31936: WHEN 3 THEN 'CST_XLA_INV_REF_V'
31937: WHEN 4 THEN 'CST_XLA_INV_REF_V'
31938: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
31939: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
31940: WHEN 7 THEN 'PO_HEADERS_REF_V'

Line 31937: WHEN 4 THEN 'CST_XLA_INV_REF_V'

31933: , CASE r
31934: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
31935: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
31936: WHEN 3 THEN 'CST_XLA_INV_REF_V'
31937: WHEN 4 THEN 'CST_XLA_INV_REF_V'
31938: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
31939: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
31940: WHEN 7 THEN 'PO_HEADERS_REF_V'
31941: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'

Line 31942: WHEN 9 THEN 'CST_XLA_INV_REF_V'

31938: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
31939: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
31940: WHEN 7 THEN 'PO_HEADERS_REF_V'
31941: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
31942: WHEN 9 THEN 'CST_XLA_INV_REF_V'
31943: WHEN 10 THEN 'CST_XLA_INV_REF_V'
31944: WHEN 11 THEN 'CST_XLA_INV_REF_V'
31945: WHEN 12 THEN 'CST_XLA_INV_REF_V'
31946: WHEN 13 THEN 'CST_XLA_INV_REF_V'

Line 31943: WHEN 10 THEN 'CST_XLA_INV_REF_V'

31939: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
31940: WHEN 7 THEN 'PO_HEADERS_REF_V'
31941: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
31942: WHEN 9 THEN 'CST_XLA_INV_REF_V'
31943: WHEN 10 THEN 'CST_XLA_INV_REF_V'
31944: WHEN 11 THEN 'CST_XLA_INV_REF_V'
31945: WHEN 12 THEN 'CST_XLA_INV_REF_V'
31946: WHEN 13 THEN 'CST_XLA_INV_REF_V'
31947: WHEN 14 THEN 'PO_DISTS_REF_V'

Line 31944: WHEN 11 THEN 'CST_XLA_INV_REF_V'

31940: WHEN 7 THEN 'PO_HEADERS_REF_V'
31941: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
31942: WHEN 9 THEN 'CST_XLA_INV_REF_V'
31943: WHEN 10 THEN 'CST_XLA_INV_REF_V'
31944: WHEN 11 THEN 'CST_XLA_INV_REF_V'
31945: WHEN 12 THEN 'CST_XLA_INV_REF_V'
31946: WHEN 13 THEN 'CST_XLA_INV_REF_V'
31947: WHEN 14 THEN 'PO_DISTS_REF_V'
31948: WHEN 15 THEN 'CST_XLA_INV_REF_V'

Line 31945: WHEN 12 THEN 'CST_XLA_INV_REF_V'

31941: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
31942: WHEN 9 THEN 'CST_XLA_INV_REF_V'
31943: WHEN 10 THEN 'CST_XLA_INV_REF_V'
31944: WHEN 11 THEN 'CST_XLA_INV_REF_V'
31945: WHEN 12 THEN 'CST_XLA_INV_REF_V'
31946: WHEN 13 THEN 'CST_XLA_INV_REF_V'
31947: WHEN 14 THEN 'PO_DISTS_REF_V'
31948: WHEN 15 THEN 'CST_XLA_INV_REF_V'
31949: WHEN 16 THEN 'CST_XLA_INV_REF_V'

Line 31946: WHEN 13 THEN 'CST_XLA_INV_REF_V'

31942: WHEN 9 THEN 'CST_XLA_INV_REF_V'
31943: WHEN 10 THEN 'CST_XLA_INV_REF_V'
31944: WHEN 11 THEN 'CST_XLA_INV_REF_V'
31945: WHEN 12 THEN 'CST_XLA_INV_REF_V'
31946: WHEN 13 THEN 'CST_XLA_INV_REF_V'
31947: WHEN 14 THEN 'PO_DISTS_REF_V'
31948: WHEN 15 THEN 'CST_XLA_INV_REF_V'
31949: WHEN 16 THEN 'CST_XLA_INV_REF_V'
31950: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'

Line 31948: WHEN 15 THEN 'CST_XLA_INV_REF_V'

31944: WHEN 11 THEN 'CST_XLA_INV_REF_V'
31945: WHEN 12 THEN 'CST_XLA_INV_REF_V'
31946: WHEN 13 THEN 'CST_XLA_INV_REF_V'
31947: WHEN 14 THEN 'PO_DISTS_REF_V'
31948: WHEN 15 THEN 'CST_XLA_INV_REF_V'
31949: WHEN 16 THEN 'CST_XLA_INV_REF_V'
31950: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
31951: WHEN 18 THEN 'PO_HEADERS_REF_V'
31952: WHEN 19 THEN 'PO_DISTS_REF_V'

Line 31949: WHEN 16 THEN 'CST_XLA_INV_REF_V'

31945: WHEN 12 THEN 'CST_XLA_INV_REF_V'
31946: WHEN 13 THEN 'CST_XLA_INV_REF_V'
31947: WHEN 14 THEN 'PO_DISTS_REF_V'
31948: WHEN 15 THEN 'CST_XLA_INV_REF_V'
31949: WHEN 16 THEN 'CST_XLA_INV_REF_V'
31950: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
31951: WHEN 18 THEN 'PO_HEADERS_REF_V'
31952: WHEN 19 THEN 'PO_DISTS_REF_V'
31953: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'

Line 32063: , CST_XLA_INV_REF_V h4

32059: END source_meaning
32060: FROM xla_events_gt xet
32061: , CST_XLA_INV_HEADERS_V h1
32062: , CST_XLA_INV_ORG_PARAMS_REF_V h3
32063: , CST_XLA_INV_REF_V h4
32064: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
32065: , CST_XLA_INV_TXN_TYPES_REF_V h6
32066: , PO_DISTS_REF_V h7
32067: , PO_HEADERS_REF_V h8

Line 32326: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

32322: --
32323:
32324: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
32325: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
32326: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
32327: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
32328: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
32329: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
32330: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 32327: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

32323:
32324: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
32325: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
32326: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
32327: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
32328: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
32329: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
32330: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
32331: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 32332: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

32328: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
32329: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
32330: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
32331: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
32332: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
32333: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
32334: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
32335: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
32336: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

Line 32333: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

32329: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
32330: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
32331: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
32332: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
32333: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
32334: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
32335: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
32336: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
32337: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 32334: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

32330: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
32331: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
32332: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
32333: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
32334: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
32335: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
32336: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
32337: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
32338: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 32335: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

32331: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
32332: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
32333: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
32334: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
32335: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
32336: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
32337: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
32338: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
32339: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 32336: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

32332: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
32333: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
32334: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
32335: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
32336: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
32337: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
32338: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
32339: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
32340: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 32338: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

32334: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
32335: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
32336: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
32337: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
32338: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
32339: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
32340: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
32341: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
32342: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 32339: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

32335: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
32336: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
32337: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
32338: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
32339: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
32340: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
32341: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
32342: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
32343: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 32431: , CST_XLA_INV_REF_V h4

32427: , fvl42.meaning source_42_meaning
32428: FROM xla_events_gt xet
32429: , CST_XLA_INV_HEADERS_V h1
32430: , CST_XLA_INV_ORG_PARAMS_REF_V h3
32431: , CST_XLA_INV_REF_V h4
32432: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
32433: , CST_XLA_INV_TXN_TYPES_REF_V h6
32434: , PO_DISTS_REF_V h7
32435: , PO_HEADERS_REF_V h8

Line 33312: WHEN 3 THEN 'CST_XLA_INV_REF_V'

33308: , 0 line_number
33309: , CASE r
33310: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
33311: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
33312: WHEN 3 THEN 'CST_XLA_INV_REF_V'
33313: WHEN 4 THEN 'CST_XLA_INV_REF_V'
33314: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
33315: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
33316: WHEN 7 THEN 'PO_HEADERS_REF_V'

Line 33313: WHEN 4 THEN 'CST_XLA_INV_REF_V'

33309: , CASE r
33310: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
33311: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
33312: WHEN 3 THEN 'CST_XLA_INV_REF_V'
33313: WHEN 4 THEN 'CST_XLA_INV_REF_V'
33314: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
33315: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
33316: WHEN 7 THEN 'PO_HEADERS_REF_V'
33317: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'

Line 33318: WHEN 9 THEN 'CST_XLA_INV_REF_V'

33314: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
33315: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
33316: WHEN 7 THEN 'PO_HEADERS_REF_V'
33317: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
33318: WHEN 9 THEN 'CST_XLA_INV_REF_V'
33319: WHEN 10 THEN 'CST_XLA_INV_REF_V'
33320: WHEN 11 THEN 'CST_XLA_INV_REF_V'
33321: WHEN 12 THEN 'CST_XLA_INV_REF_V'
33322: WHEN 13 THEN 'CST_XLA_INV_REF_V'

Line 33319: WHEN 10 THEN 'CST_XLA_INV_REF_V'

33315: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
33316: WHEN 7 THEN 'PO_HEADERS_REF_V'
33317: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
33318: WHEN 9 THEN 'CST_XLA_INV_REF_V'
33319: WHEN 10 THEN 'CST_XLA_INV_REF_V'
33320: WHEN 11 THEN 'CST_XLA_INV_REF_V'
33321: WHEN 12 THEN 'CST_XLA_INV_REF_V'
33322: WHEN 13 THEN 'CST_XLA_INV_REF_V'
33323: WHEN 14 THEN 'PO_DISTS_REF_V'

Line 33320: WHEN 11 THEN 'CST_XLA_INV_REF_V'

33316: WHEN 7 THEN 'PO_HEADERS_REF_V'
33317: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
33318: WHEN 9 THEN 'CST_XLA_INV_REF_V'
33319: WHEN 10 THEN 'CST_XLA_INV_REF_V'
33320: WHEN 11 THEN 'CST_XLA_INV_REF_V'
33321: WHEN 12 THEN 'CST_XLA_INV_REF_V'
33322: WHEN 13 THEN 'CST_XLA_INV_REF_V'
33323: WHEN 14 THEN 'PO_DISTS_REF_V'
33324: WHEN 15 THEN 'CST_XLA_INV_REF_V'

Line 33321: WHEN 12 THEN 'CST_XLA_INV_REF_V'

33317: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
33318: WHEN 9 THEN 'CST_XLA_INV_REF_V'
33319: WHEN 10 THEN 'CST_XLA_INV_REF_V'
33320: WHEN 11 THEN 'CST_XLA_INV_REF_V'
33321: WHEN 12 THEN 'CST_XLA_INV_REF_V'
33322: WHEN 13 THEN 'CST_XLA_INV_REF_V'
33323: WHEN 14 THEN 'PO_DISTS_REF_V'
33324: WHEN 15 THEN 'CST_XLA_INV_REF_V'
33325: WHEN 16 THEN 'CST_XLA_INV_REF_V'

Line 33322: WHEN 13 THEN 'CST_XLA_INV_REF_V'

33318: WHEN 9 THEN 'CST_XLA_INV_REF_V'
33319: WHEN 10 THEN 'CST_XLA_INV_REF_V'
33320: WHEN 11 THEN 'CST_XLA_INV_REF_V'
33321: WHEN 12 THEN 'CST_XLA_INV_REF_V'
33322: WHEN 13 THEN 'CST_XLA_INV_REF_V'
33323: WHEN 14 THEN 'PO_DISTS_REF_V'
33324: WHEN 15 THEN 'CST_XLA_INV_REF_V'
33325: WHEN 16 THEN 'CST_XLA_INV_REF_V'
33326: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'

Line 33324: WHEN 15 THEN 'CST_XLA_INV_REF_V'

33320: WHEN 11 THEN 'CST_XLA_INV_REF_V'
33321: WHEN 12 THEN 'CST_XLA_INV_REF_V'
33322: WHEN 13 THEN 'CST_XLA_INV_REF_V'
33323: WHEN 14 THEN 'PO_DISTS_REF_V'
33324: WHEN 15 THEN 'CST_XLA_INV_REF_V'
33325: WHEN 16 THEN 'CST_XLA_INV_REF_V'
33326: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
33327: WHEN 18 THEN 'PO_HEADERS_REF_V'
33328: WHEN 19 THEN 'PO_DISTS_REF_V'

Line 33325: WHEN 16 THEN 'CST_XLA_INV_REF_V'

33321: WHEN 12 THEN 'CST_XLA_INV_REF_V'
33322: WHEN 13 THEN 'CST_XLA_INV_REF_V'
33323: WHEN 14 THEN 'PO_DISTS_REF_V'
33324: WHEN 15 THEN 'CST_XLA_INV_REF_V'
33325: WHEN 16 THEN 'CST_XLA_INV_REF_V'
33326: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
33327: WHEN 18 THEN 'PO_HEADERS_REF_V'
33328: WHEN 19 THEN 'PO_DISTS_REF_V'
33329: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'

Line 33439: , CST_XLA_INV_REF_V h4

33435: END source_meaning
33436: FROM xla_events_gt xet
33437: , CST_XLA_INV_HEADERS_V h1
33438: , CST_XLA_INV_ORG_PARAMS_REF_V h3
33439: , CST_XLA_INV_REF_V h4
33440: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
33441: , CST_XLA_INV_TXN_TYPES_REF_V h6
33442: , PO_DISTS_REF_V h7
33443: , PO_HEADERS_REF_V h8

Line 33702: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

33698: --
33699:
33700: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
33701: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
33702: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
33703: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
33704: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
33705: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
33706: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 33703: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

33699:
33700: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
33701: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
33702: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
33703: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
33704: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
33705: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
33706: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
33707: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 33708: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

33704: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
33705: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
33706: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
33707: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
33708: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
33709: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
33710: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
33711: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
33712: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

Line 33709: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

33705: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
33706: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
33707: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
33708: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
33709: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
33710: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
33711: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
33712: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
33713: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 33710: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

33706: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
33707: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
33708: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
33709: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
33710: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
33711: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
33712: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
33713: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
33714: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 33711: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

33707: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
33708: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
33709: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
33710: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
33711: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
33712: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
33713: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
33714: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
33715: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 33712: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

33708: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
33709: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
33710: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
33711: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
33712: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
33713: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
33714: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
33715: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
33716: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 33714: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

33710: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
33711: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
33712: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
33713: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
33714: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
33715: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
33716: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
33717: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
33718: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 33715: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

33711: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
33712: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
33713: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
33714: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
33715: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
33716: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
33717: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
33718: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
33719: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 33807: , CST_XLA_INV_REF_V h4

33803: , fvl42.meaning source_42_meaning
33804: FROM xla_events_gt xet
33805: , CST_XLA_INV_HEADERS_V h1
33806: , CST_XLA_INV_ORG_PARAMS_REF_V h3
33807: , CST_XLA_INV_REF_V h4
33808: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
33809: , CST_XLA_INV_TXN_TYPES_REF_V h6
33810: , PO_DISTS_REF_V h7
33811: , PO_HEADERS_REF_V h8

Line 34688: WHEN 3 THEN 'CST_XLA_INV_REF_V'

34684: , 0 line_number
34685: , CASE r
34686: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
34687: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
34688: WHEN 3 THEN 'CST_XLA_INV_REF_V'
34689: WHEN 4 THEN 'CST_XLA_INV_REF_V'
34690: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
34691: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
34692: WHEN 7 THEN 'PO_HEADERS_REF_V'

Line 34689: WHEN 4 THEN 'CST_XLA_INV_REF_V'

34685: , CASE r
34686: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
34687: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
34688: WHEN 3 THEN 'CST_XLA_INV_REF_V'
34689: WHEN 4 THEN 'CST_XLA_INV_REF_V'
34690: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
34691: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
34692: WHEN 7 THEN 'PO_HEADERS_REF_V'
34693: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'

Line 34694: WHEN 9 THEN 'CST_XLA_INV_REF_V'

34690: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
34691: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
34692: WHEN 7 THEN 'PO_HEADERS_REF_V'
34693: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
34694: WHEN 9 THEN 'CST_XLA_INV_REF_V'
34695: WHEN 10 THEN 'CST_XLA_INV_REF_V'
34696: WHEN 11 THEN 'CST_XLA_INV_REF_V'
34697: WHEN 12 THEN 'CST_XLA_INV_REF_V'
34698: WHEN 13 THEN 'CST_XLA_INV_REF_V'

Line 34695: WHEN 10 THEN 'CST_XLA_INV_REF_V'

34691: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
34692: WHEN 7 THEN 'PO_HEADERS_REF_V'
34693: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
34694: WHEN 9 THEN 'CST_XLA_INV_REF_V'
34695: WHEN 10 THEN 'CST_XLA_INV_REF_V'
34696: WHEN 11 THEN 'CST_XLA_INV_REF_V'
34697: WHEN 12 THEN 'CST_XLA_INV_REF_V'
34698: WHEN 13 THEN 'CST_XLA_INV_REF_V'
34699: WHEN 14 THEN 'PO_DISTS_REF_V'

Line 34696: WHEN 11 THEN 'CST_XLA_INV_REF_V'

34692: WHEN 7 THEN 'PO_HEADERS_REF_V'
34693: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
34694: WHEN 9 THEN 'CST_XLA_INV_REF_V'
34695: WHEN 10 THEN 'CST_XLA_INV_REF_V'
34696: WHEN 11 THEN 'CST_XLA_INV_REF_V'
34697: WHEN 12 THEN 'CST_XLA_INV_REF_V'
34698: WHEN 13 THEN 'CST_XLA_INV_REF_V'
34699: WHEN 14 THEN 'PO_DISTS_REF_V'
34700: WHEN 15 THEN 'CST_XLA_INV_REF_V'

Line 34697: WHEN 12 THEN 'CST_XLA_INV_REF_V'

34693: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
34694: WHEN 9 THEN 'CST_XLA_INV_REF_V'
34695: WHEN 10 THEN 'CST_XLA_INV_REF_V'
34696: WHEN 11 THEN 'CST_XLA_INV_REF_V'
34697: WHEN 12 THEN 'CST_XLA_INV_REF_V'
34698: WHEN 13 THEN 'CST_XLA_INV_REF_V'
34699: WHEN 14 THEN 'PO_DISTS_REF_V'
34700: WHEN 15 THEN 'CST_XLA_INV_REF_V'
34701: WHEN 16 THEN 'CST_XLA_INV_REF_V'

Line 34698: WHEN 13 THEN 'CST_XLA_INV_REF_V'

34694: WHEN 9 THEN 'CST_XLA_INV_REF_V'
34695: WHEN 10 THEN 'CST_XLA_INV_REF_V'
34696: WHEN 11 THEN 'CST_XLA_INV_REF_V'
34697: WHEN 12 THEN 'CST_XLA_INV_REF_V'
34698: WHEN 13 THEN 'CST_XLA_INV_REF_V'
34699: WHEN 14 THEN 'PO_DISTS_REF_V'
34700: WHEN 15 THEN 'CST_XLA_INV_REF_V'
34701: WHEN 16 THEN 'CST_XLA_INV_REF_V'
34702: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'

Line 34700: WHEN 15 THEN 'CST_XLA_INV_REF_V'

34696: WHEN 11 THEN 'CST_XLA_INV_REF_V'
34697: WHEN 12 THEN 'CST_XLA_INV_REF_V'
34698: WHEN 13 THEN 'CST_XLA_INV_REF_V'
34699: WHEN 14 THEN 'PO_DISTS_REF_V'
34700: WHEN 15 THEN 'CST_XLA_INV_REF_V'
34701: WHEN 16 THEN 'CST_XLA_INV_REF_V'
34702: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
34703: WHEN 18 THEN 'PO_HEADERS_REF_V'
34704: WHEN 19 THEN 'PO_DISTS_REF_V'

Line 34701: WHEN 16 THEN 'CST_XLA_INV_REF_V'

34697: WHEN 12 THEN 'CST_XLA_INV_REF_V'
34698: WHEN 13 THEN 'CST_XLA_INV_REF_V'
34699: WHEN 14 THEN 'PO_DISTS_REF_V'
34700: WHEN 15 THEN 'CST_XLA_INV_REF_V'
34701: WHEN 16 THEN 'CST_XLA_INV_REF_V'
34702: WHEN 17 THEN 'PSA_CST_XLA_UPG_V'
34703: WHEN 18 THEN 'PO_HEADERS_REF_V'
34704: WHEN 19 THEN 'PO_DISTS_REF_V'
34705: WHEN 20 THEN 'CST_XLA_INV_HEADERS_V'

Line 34815: , CST_XLA_INV_REF_V h4

34811: END source_meaning
34812: FROM xla_events_gt xet
34813: , CST_XLA_INV_HEADERS_V h1
34814: , CST_XLA_INV_ORG_PARAMS_REF_V h3
34815: , CST_XLA_INV_REF_V h4
34816: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
34817: , CST_XLA_INV_TXN_TYPES_REF_V h6
34818: , PO_DISTS_REF_V h7
34819: , PO_HEADERS_REF_V h8

Line 35078: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;

35074: --
35075:
35076: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
35077: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
35078: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
35079: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
35080: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
35081: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
35082: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 35079: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;

35075:
35076: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
35077: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
35078: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
35079: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
35080: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
35081: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
35082: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
35083: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 35084: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

35080: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
35081: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
35082: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
35083: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
35084: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
35085: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
35086: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
35087: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
35088: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

Line 35085: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

35081: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
35082: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
35083: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
35084: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
35085: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
35086: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
35087: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
35088: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
35089: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 35086: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

35082: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
35083: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
35084: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
35085: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
35086: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
35087: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
35088: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
35089: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
35090: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 35087: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

35083: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
35084: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
35085: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
35086: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
35087: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
35088: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
35089: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
35090: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
35091: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 35088: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

35084: TYPE t_array_source_19 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
35085: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
35086: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
35087: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
35088: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
35089: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
35090: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
35091: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
35092: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

Line 35090: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

35086: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
35087: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
35088: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
35089: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
35090: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
35091: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
35092: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
35093: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
35094: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 35091: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

35087: TYPE t_array_source_22 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
35088: TYPE t_array_source_23 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
35089: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
35090: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
35091: TYPE t_array_source_26 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
35092: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
35093: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
35094: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
35095: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 35183: , CST_XLA_INV_REF_V h4

35179: , fvl42.meaning source_42_meaning
35180: FROM xla_events_gt xet
35181: , CST_XLA_INV_HEADERS_V h1
35182: , CST_XLA_INV_ORG_PARAMS_REF_V h3
35183: , CST_XLA_INV_REF_V h4
35184: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
35185: , CST_XLA_INV_TXN_TYPES_REF_V h6
35186: , PO_DISTS_REF_V h7
35187: , PO_HEADERS_REF_V h8