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

Line 148382: WHEN 1 THEN 'CST_XLA_INV_REF_V'

148378: FROM (
148379: SELECT xet.event_id event_id
148380: , 0 line_number
148381: , CASE r
148382: WHEN 1 THEN 'CST_XLA_INV_REF_V'
148383: WHEN 2 THEN 'CST_XLA_INV_REF_V'
148384: WHEN 3 THEN 'CST_XLA_INV_REF_V'
148385: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
148386: WHEN 5 THEN 'CST_XLA_INV_REF_V'

Line 148383: WHEN 2 THEN 'CST_XLA_INV_REF_V'

148379: SELECT xet.event_id event_id
148380: , 0 line_number
148381: , CASE r
148382: WHEN 1 THEN 'CST_XLA_INV_REF_V'
148383: WHEN 2 THEN 'CST_XLA_INV_REF_V'
148384: WHEN 3 THEN 'CST_XLA_INV_REF_V'
148385: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
148386: WHEN 5 THEN 'CST_XLA_INV_REF_V'
148387: WHEN 6 THEN 'CST_XLA_INV_REF_V'

Line 148384: WHEN 3 THEN 'CST_XLA_INV_REF_V'

148380: , 0 line_number
148381: , CASE r
148382: WHEN 1 THEN 'CST_XLA_INV_REF_V'
148383: WHEN 2 THEN 'CST_XLA_INV_REF_V'
148384: WHEN 3 THEN 'CST_XLA_INV_REF_V'
148385: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
148386: WHEN 5 THEN 'CST_XLA_INV_REF_V'
148387: WHEN 6 THEN 'CST_XLA_INV_REF_V'
148388: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'

Line 148386: WHEN 5 THEN 'CST_XLA_INV_REF_V'

148382: WHEN 1 THEN 'CST_XLA_INV_REF_V'
148383: WHEN 2 THEN 'CST_XLA_INV_REF_V'
148384: WHEN 3 THEN 'CST_XLA_INV_REF_V'
148385: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
148386: WHEN 5 THEN 'CST_XLA_INV_REF_V'
148387: WHEN 6 THEN 'CST_XLA_INV_REF_V'
148388: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
148389: WHEN 8 THEN 'CST_XLA_INV_REF_V'
148390: WHEN 9 THEN 'CST_XLA_INV_REF_V'

Line 148387: WHEN 6 THEN 'CST_XLA_INV_REF_V'

148383: WHEN 2 THEN 'CST_XLA_INV_REF_V'
148384: WHEN 3 THEN 'CST_XLA_INV_REF_V'
148385: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
148386: WHEN 5 THEN 'CST_XLA_INV_REF_V'
148387: WHEN 6 THEN 'CST_XLA_INV_REF_V'
148388: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
148389: WHEN 8 THEN 'CST_XLA_INV_REF_V'
148390: WHEN 9 THEN 'CST_XLA_INV_REF_V'
148391: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'

Line 148389: WHEN 8 THEN 'CST_XLA_INV_REF_V'

148385: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
148386: WHEN 5 THEN 'CST_XLA_INV_REF_V'
148387: WHEN 6 THEN 'CST_XLA_INV_REF_V'
148388: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
148389: WHEN 8 THEN 'CST_XLA_INV_REF_V'
148390: WHEN 9 THEN 'CST_XLA_INV_REF_V'
148391: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
148392: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
148393: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'

Line 148390: WHEN 9 THEN 'CST_XLA_INV_REF_V'

148386: WHEN 5 THEN 'CST_XLA_INV_REF_V'
148387: WHEN 6 THEN 'CST_XLA_INV_REF_V'
148388: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
148389: WHEN 8 THEN 'CST_XLA_INV_REF_V'
148390: WHEN 9 THEN 'CST_XLA_INV_REF_V'
148391: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
148392: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
148393: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
148394:

Line 148470: , CST_XLA_INV_REF_V h3

148466: ELSE null
148467: END source_meaning
148468: FROM xla_events_gt xet
148469: , CST_XLA_INV_HEADERS_V h1
148470: , CST_XLA_INV_REF_V h3
148471: , PO_REQ_DISTS_REF_V h4
148472: , PO_REQ_HEADERS_REF_V h5
148473: , PSA_CST_XLA_UPG_V h6
148474: , fnd_lookup_values fvl12

Line 148759: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

148755: --
148756: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
148757: --
148758:
148759: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
148760: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
148761: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
148762: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
148763: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 148760: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

148756: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
148757: --
148758:
148759: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
148760: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
148761: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
148762: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
148763: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
148764: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 148761: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

148757: --
148758:
148759: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
148760: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
148761: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
148762: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
148763: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
148764: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
148765: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

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

148759: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
148760: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
148761: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
148762: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
148763: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
148764: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
148765: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
148766: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
148767: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

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

148760: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
148761: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
148762: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
148763: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
148764: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
148765: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
148766: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
148767: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
148768: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 148766: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

148762: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
148763: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
148764: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
148765: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
148766: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
148767: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
148768: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
148769: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
148770: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 148767: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

148763: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
148764: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
148765: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
148766: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
148767: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
148768: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
148769: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
148770: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
148771:

Line 148852: , CST_XLA_INV_REF_V h3

148848: , h1.TRANSFER_TO_GL_INDICATOR source_38
148849: , fvl38.meaning source_38_meaning
148850: FROM xla_events_gt xet
148851: , CST_XLA_INV_HEADERS_V h1
148852: , CST_XLA_INV_REF_V h3
148853: , PO_REQ_DISTS_REF_V h4
148854: , PO_REQ_HEADERS_REF_V h5
148855: , PSA_CST_XLA_UPG_V h6
148856: , fnd_lookup_values fvl12

Line 151402: WHEN 1 THEN 'CST_XLA_INV_REF_V'

151398: FROM (
151399: SELECT xet.event_id event_id
151400: , 0 line_number
151401: , CASE r
151402: WHEN 1 THEN 'CST_XLA_INV_REF_V'
151403: WHEN 2 THEN 'CST_XLA_INV_REF_V'
151404: WHEN 3 THEN 'CST_XLA_INV_REF_V'
151405: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
151406: WHEN 5 THEN 'CST_XLA_INV_REF_V'

Line 151403: WHEN 2 THEN 'CST_XLA_INV_REF_V'

151399: SELECT xet.event_id event_id
151400: , 0 line_number
151401: , CASE r
151402: WHEN 1 THEN 'CST_XLA_INV_REF_V'
151403: WHEN 2 THEN 'CST_XLA_INV_REF_V'
151404: WHEN 3 THEN 'CST_XLA_INV_REF_V'
151405: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
151406: WHEN 5 THEN 'CST_XLA_INV_REF_V'
151407: WHEN 6 THEN 'CST_XLA_INV_REF_V'

Line 151404: WHEN 3 THEN 'CST_XLA_INV_REF_V'

151400: , 0 line_number
151401: , CASE r
151402: WHEN 1 THEN 'CST_XLA_INV_REF_V'
151403: WHEN 2 THEN 'CST_XLA_INV_REF_V'
151404: WHEN 3 THEN 'CST_XLA_INV_REF_V'
151405: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
151406: WHEN 5 THEN 'CST_XLA_INV_REF_V'
151407: WHEN 6 THEN 'CST_XLA_INV_REF_V'
151408: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'

Line 151406: WHEN 5 THEN 'CST_XLA_INV_REF_V'

151402: WHEN 1 THEN 'CST_XLA_INV_REF_V'
151403: WHEN 2 THEN 'CST_XLA_INV_REF_V'
151404: WHEN 3 THEN 'CST_XLA_INV_REF_V'
151405: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
151406: WHEN 5 THEN 'CST_XLA_INV_REF_V'
151407: WHEN 6 THEN 'CST_XLA_INV_REF_V'
151408: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
151409: WHEN 8 THEN 'CST_XLA_INV_REF_V'
151410: WHEN 9 THEN 'CST_XLA_INV_REF_V'

Line 151407: WHEN 6 THEN 'CST_XLA_INV_REF_V'

151403: WHEN 2 THEN 'CST_XLA_INV_REF_V'
151404: WHEN 3 THEN 'CST_XLA_INV_REF_V'
151405: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
151406: WHEN 5 THEN 'CST_XLA_INV_REF_V'
151407: WHEN 6 THEN 'CST_XLA_INV_REF_V'
151408: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
151409: WHEN 8 THEN 'CST_XLA_INV_REF_V'
151410: WHEN 9 THEN 'CST_XLA_INV_REF_V'
151411: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'

Line 151409: WHEN 8 THEN 'CST_XLA_INV_REF_V'

151405: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
151406: WHEN 5 THEN 'CST_XLA_INV_REF_V'
151407: WHEN 6 THEN 'CST_XLA_INV_REF_V'
151408: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
151409: WHEN 8 THEN 'CST_XLA_INV_REF_V'
151410: WHEN 9 THEN 'CST_XLA_INV_REF_V'
151411: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
151412: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
151413: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'

Line 151410: WHEN 9 THEN 'CST_XLA_INV_REF_V'

151406: WHEN 5 THEN 'CST_XLA_INV_REF_V'
151407: WHEN 6 THEN 'CST_XLA_INV_REF_V'
151408: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
151409: WHEN 8 THEN 'CST_XLA_INV_REF_V'
151410: WHEN 9 THEN 'CST_XLA_INV_REF_V'
151411: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
151412: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
151413: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
151414:

Line 151490: , CST_XLA_INV_REF_V h3

151486: ELSE null
151487: END source_meaning
151488: FROM xla_events_gt xet
151489: , CST_XLA_INV_HEADERS_V h1
151490: , CST_XLA_INV_REF_V h3
151491: , PO_REQ_DISTS_REF_V h4
151492: , PO_REQ_HEADERS_REF_V h5
151493: , PSA_CST_XLA_UPG_V h6
151494: , fnd_lookup_values fvl12

Line 151779: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

151775: --
151776: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
151777: --
151778:
151779: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
151780: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
151781: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
151782: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
151783: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 151780: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

151776: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
151777: --
151778:
151779: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
151780: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
151781: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
151782: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
151783: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
151784: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 151781: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

151777: --
151778:
151779: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
151780: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
151781: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
151782: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
151783: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
151784: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
151785: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

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

151779: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
151780: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
151781: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
151782: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
151783: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
151784: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
151785: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
151786: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
151787: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

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

151780: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
151781: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
151782: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
151783: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
151784: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
151785: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
151786: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
151787: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
151788: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 151786: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

151782: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
151783: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
151784: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
151785: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
151786: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
151787: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
151788: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
151789: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
151790: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 151787: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

151783: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
151784: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
151785: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
151786: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
151787: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
151788: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
151789: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
151790: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
151791:

Line 151872: , CST_XLA_INV_REF_V h3

151868: , h1.TRANSFER_TO_GL_INDICATOR source_38
151869: , fvl38.meaning source_38_meaning
151870: FROM xla_events_gt xet
151871: , CST_XLA_INV_HEADERS_V h1
151872: , CST_XLA_INV_REF_V h3
151873: , PO_REQ_DISTS_REF_V h4
151874: , PO_REQ_HEADERS_REF_V h5
151875: , PSA_CST_XLA_UPG_V h6
151876: , fnd_lookup_values fvl12

Line 155561: WHEN 1 THEN 'CST_XLA_INV_REF_V'

155557: FROM (
155558: SELECT xet.event_id event_id
155559: , 0 line_number
155560: , CASE r
155561: WHEN 1 THEN 'CST_XLA_INV_REF_V'
155562: WHEN 2 THEN 'CST_XLA_INV_REF_V'
155563: WHEN 3 THEN 'CST_XLA_INV_REF_V'
155564: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
155565: WHEN 5 THEN 'CST_XLA_INV_REF_V'

Line 155562: WHEN 2 THEN 'CST_XLA_INV_REF_V'

155558: SELECT xet.event_id event_id
155559: , 0 line_number
155560: , CASE r
155561: WHEN 1 THEN 'CST_XLA_INV_REF_V'
155562: WHEN 2 THEN 'CST_XLA_INV_REF_V'
155563: WHEN 3 THEN 'CST_XLA_INV_REF_V'
155564: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
155565: WHEN 5 THEN 'CST_XLA_INV_REF_V'
155566: WHEN 6 THEN 'CST_XLA_INV_REF_V'

Line 155563: WHEN 3 THEN 'CST_XLA_INV_REF_V'

155559: , 0 line_number
155560: , CASE r
155561: WHEN 1 THEN 'CST_XLA_INV_REF_V'
155562: WHEN 2 THEN 'CST_XLA_INV_REF_V'
155563: WHEN 3 THEN 'CST_XLA_INV_REF_V'
155564: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
155565: WHEN 5 THEN 'CST_XLA_INV_REF_V'
155566: WHEN 6 THEN 'CST_XLA_INV_REF_V'
155567: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'

Line 155565: WHEN 5 THEN 'CST_XLA_INV_REF_V'

155561: WHEN 1 THEN 'CST_XLA_INV_REF_V'
155562: WHEN 2 THEN 'CST_XLA_INV_REF_V'
155563: WHEN 3 THEN 'CST_XLA_INV_REF_V'
155564: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
155565: WHEN 5 THEN 'CST_XLA_INV_REF_V'
155566: WHEN 6 THEN 'CST_XLA_INV_REF_V'
155567: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
155568: WHEN 8 THEN 'CST_XLA_INV_REF_V'
155569: WHEN 9 THEN 'CST_XLA_INV_REF_V'

Line 155566: WHEN 6 THEN 'CST_XLA_INV_REF_V'

155562: WHEN 2 THEN 'CST_XLA_INV_REF_V'
155563: WHEN 3 THEN 'CST_XLA_INV_REF_V'
155564: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
155565: WHEN 5 THEN 'CST_XLA_INV_REF_V'
155566: WHEN 6 THEN 'CST_XLA_INV_REF_V'
155567: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
155568: WHEN 8 THEN 'CST_XLA_INV_REF_V'
155569: WHEN 9 THEN 'CST_XLA_INV_REF_V'
155570: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'

Line 155568: WHEN 8 THEN 'CST_XLA_INV_REF_V'

155564: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
155565: WHEN 5 THEN 'CST_XLA_INV_REF_V'
155566: WHEN 6 THEN 'CST_XLA_INV_REF_V'
155567: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
155568: WHEN 8 THEN 'CST_XLA_INV_REF_V'
155569: WHEN 9 THEN 'CST_XLA_INV_REF_V'
155570: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
155571: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
155572: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'

Line 155569: WHEN 9 THEN 'CST_XLA_INV_REF_V'

155565: WHEN 5 THEN 'CST_XLA_INV_REF_V'
155566: WHEN 6 THEN 'CST_XLA_INV_REF_V'
155567: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
155568: WHEN 8 THEN 'CST_XLA_INV_REF_V'
155569: WHEN 9 THEN 'CST_XLA_INV_REF_V'
155570: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
155571: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
155572: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
155573:

Line 155649: , CST_XLA_INV_REF_V h3

155645: ELSE null
155646: END source_meaning
155647: FROM xla_events_gt xet
155648: , CST_XLA_INV_HEADERS_V h1
155649: , CST_XLA_INV_REF_V h3
155650: , PO_REQ_DISTS_REF_V h4
155651: , PO_REQ_HEADERS_REF_V h5
155652: , PSA_CST_XLA_UPG_V h6
155653: , fnd_lookup_values fvl12

Line 155938: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

155934: --
155935: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
155936: --
155937:
155938: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
155939: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
155940: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
155941: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
155942: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 155939: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

155935: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
155936: --
155937:
155938: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
155939: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
155940: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
155941: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
155942: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
155943: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 155940: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

155936: --
155937:
155938: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
155939: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
155940: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
155941: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
155942: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
155943: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
155944: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

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

155938: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
155939: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
155940: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
155941: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
155942: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
155943: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
155944: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
155945: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
155946: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

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

155939: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
155940: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
155941: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
155942: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
155943: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
155944: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
155945: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
155946: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
155947: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 155945: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

155941: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
155942: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
155943: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
155944: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
155945: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
155946: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
155947: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
155948: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
155949: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 155946: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

155942: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
155943: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
155944: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
155945: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
155946: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
155947: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
155948: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
155949: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
155950:

Line 156031: , CST_XLA_INV_REF_V h3

156027: , h1.TRANSFER_TO_GL_INDICATOR source_38
156028: , fvl38.meaning source_38_meaning
156029: FROM xla_events_gt xet
156030: , CST_XLA_INV_HEADERS_V h1
156031: , CST_XLA_INV_REF_V h3
156032: , PO_REQ_DISTS_REF_V h4
156033: , PO_REQ_HEADERS_REF_V h5
156034: , PSA_CST_XLA_UPG_V h6
156035: , fnd_lookup_values fvl12

Line 172432: WHEN 1 THEN 'CST_XLA_INV_REF_V'

172428: FROM (
172429: SELECT xet.event_id event_id
172430: , 0 line_number
172431: , CASE r
172432: WHEN 1 THEN 'CST_XLA_INV_REF_V'
172433: WHEN 2 THEN 'CST_XLA_INV_REF_V'
172434: WHEN 3 THEN 'CST_XLA_INV_REF_V'
172435: WHEN 4 THEN 'CST_XLA_INV_REF_V'
172436: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'

Line 172433: WHEN 2 THEN 'CST_XLA_INV_REF_V'

172429: SELECT xet.event_id event_id
172430: , 0 line_number
172431: , CASE r
172432: WHEN 1 THEN 'CST_XLA_INV_REF_V'
172433: WHEN 2 THEN 'CST_XLA_INV_REF_V'
172434: WHEN 3 THEN 'CST_XLA_INV_REF_V'
172435: WHEN 4 THEN 'CST_XLA_INV_REF_V'
172436: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'
172437: WHEN 6 THEN 'PO_DISTS_REF_V'

Line 172434: WHEN 3 THEN 'CST_XLA_INV_REF_V'

172430: , 0 line_number
172431: , CASE r
172432: WHEN 1 THEN 'CST_XLA_INV_REF_V'
172433: WHEN 2 THEN 'CST_XLA_INV_REF_V'
172434: WHEN 3 THEN 'CST_XLA_INV_REF_V'
172435: WHEN 4 THEN 'CST_XLA_INV_REF_V'
172436: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'
172437: WHEN 6 THEN 'PO_DISTS_REF_V'
172438: WHEN 7 THEN 'CST_XLA_INV_REF_V'

Line 172435: WHEN 4 THEN 'CST_XLA_INV_REF_V'

172431: , CASE r
172432: WHEN 1 THEN 'CST_XLA_INV_REF_V'
172433: WHEN 2 THEN 'CST_XLA_INV_REF_V'
172434: WHEN 3 THEN 'CST_XLA_INV_REF_V'
172435: WHEN 4 THEN 'CST_XLA_INV_REF_V'
172436: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'
172437: WHEN 6 THEN 'PO_DISTS_REF_V'
172438: WHEN 7 THEN 'CST_XLA_INV_REF_V'
172439: WHEN 8 THEN 'CST_XLA_INV_REF_V'

Line 172438: WHEN 7 THEN 'CST_XLA_INV_REF_V'

172434: WHEN 3 THEN 'CST_XLA_INV_REF_V'
172435: WHEN 4 THEN 'CST_XLA_INV_REF_V'
172436: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'
172437: WHEN 6 THEN 'PO_DISTS_REF_V'
172438: WHEN 7 THEN 'CST_XLA_INV_REF_V'
172439: WHEN 8 THEN 'CST_XLA_INV_REF_V'
172440: WHEN 9 THEN 'PO_HEADERS_REF_V'
172441: WHEN 10 THEN 'PSA_CST_XLA_UPG_V'
172442: WHEN 11 THEN 'CST_XLA_INV_REF_V'

Line 172439: WHEN 8 THEN 'CST_XLA_INV_REF_V'

172435: WHEN 4 THEN 'CST_XLA_INV_REF_V'
172436: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'
172437: WHEN 6 THEN 'PO_DISTS_REF_V'
172438: WHEN 7 THEN 'CST_XLA_INV_REF_V'
172439: WHEN 8 THEN 'CST_XLA_INV_REF_V'
172440: WHEN 9 THEN 'PO_HEADERS_REF_V'
172441: WHEN 10 THEN 'PSA_CST_XLA_UPG_V'
172442: WHEN 11 THEN 'CST_XLA_INV_REF_V'
172443: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'

Line 172442: WHEN 11 THEN 'CST_XLA_INV_REF_V'

172438: WHEN 7 THEN 'CST_XLA_INV_REF_V'
172439: WHEN 8 THEN 'CST_XLA_INV_REF_V'
172440: WHEN 9 THEN 'PO_HEADERS_REF_V'
172441: WHEN 10 THEN 'PSA_CST_XLA_UPG_V'
172442: WHEN 11 THEN 'CST_XLA_INV_REF_V'
172443: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
172444:
172445: ELSE null
172446: END object_name

Line 172520: , CST_XLA_INV_REF_V h3

172516: ELSE null
172517: END source_meaning
172518: FROM xla_events_gt xet
172519: , CST_XLA_INV_HEADERS_V h1
172520: , CST_XLA_INV_REF_V h3
172521: , PO_DISTS_REF_V h4
172522: , PO_HEADERS_REF_V h5
172523: , PSA_CST_XLA_UPG_V h6
172524: , fnd_lookup_values fvl12

Line 172809: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

172805: --
172806: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
172807: --
172808:
172809: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
172810: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
172811: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
172812: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
172813: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 172810: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;

172806: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
172807: --
172808:
172809: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
172810: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
172811: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
172812: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
172813: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
172814: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 172811: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

172807: --
172808:
172809: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
172810: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
172811: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
172812: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
172813: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
172814: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
172815: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

Line 172812: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

172808:
172809: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
172810: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
172811: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
172812: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
172813: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
172814: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
172815: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
172816: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

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

172811: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
172812: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
172813: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
172814: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
172815: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
172816: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
172817: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
172818: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
172819: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

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

172812: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
172813: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
172814: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
172815: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
172816: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
172817: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
172818: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
172819: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
172820: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 172819: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

172815: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
172816: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
172817: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
172818: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
172819: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
172820: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
172821:
172822: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
172823: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 172902: , CST_XLA_INV_REF_V h3

172898: , h1.TRANSFER_TO_GL_INDICATOR source_38
172899: , fvl38.meaning source_38_meaning
172900: FROM xla_events_gt xet
172901: , CST_XLA_INV_HEADERS_V h1
172902: , CST_XLA_INV_REF_V h3
172903: , PO_DISTS_REF_V h4
172904: , PO_HEADERS_REF_V h5
172905: , PSA_CST_XLA_UPG_V h6
172906: , fnd_lookup_values fvl12