eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00707_AAD_S_000007_PKG dependencies on CST_XLA_INV_REF_V

Line 143390: WHEN 1 THEN 'CST_XLA_INV_REF_V'

143386: FROM (
143387: SELECT xet.event_id event_id
143388: , 0 line_number
143389: , CASE r
143390: WHEN 1 THEN 'CST_XLA_INV_REF_V'
143391: WHEN 2 THEN 'CST_XLA_INV_REF_V'
143392: WHEN 3 THEN 'CST_XLA_INV_REF_V'
143393: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
143394: WHEN 5 THEN 'CST_XLA_INV_REF_V'

Line 143391: WHEN 2 THEN 'CST_XLA_INV_REF_V'

143387: SELECT xet.event_id event_id
143388: , 0 line_number
143389: , CASE r
143390: WHEN 1 THEN 'CST_XLA_INV_REF_V'
143391: WHEN 2 THEN 'CST_XLA_INV_REF_V'
143392: WHEN 3 THEN 'CST_XLA_INV_REF_V'
143393: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
143394: WHEN 5 THEN 'CST_XLA_INV_REF_V'
143395: WHEN 6 THEN 'CST_XLA_INV_REF_V'

Line 143392: WHEN 3 THEN 'CST_XLA_INV_REF_V'

143388: , 0 line_number
143389: , CASE r
143390: WHEN 1 THEN 'CST_XLA_INV_REF_V'
143391: WHEN 2 THEN 'CST_XLA_INV_REF_V'
143392: WHEN 3 THEN 'CST_XLA_INV_REF_V'
143393: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
143394: WHEN 5 THEN 'CST_XLA_INV_REF_V'
143395: WHEN 6 THEN 'CST_XLA_INV_REF_V'
143396: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'

Line 143394: WHEN 5 THEN 'CST_XLA_INV_REF_V'

143390: WHEN 1 THEN 'CST_XLA_INV_REF_V'
143391: WHEN 2 THEN 'CST_XLA_INV_REF_V'
143392: WHEN 3 THEN 'CST_XLA_INV_REF_V'
143393: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
143394: WHEN 5 THEN 'CST_XLA_INV_REF_V'
143395: WHEN 6 THEN 'CST_XLA_INV_REF_V'
143396: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
143397: WHEN 8 THEN 'CST_XLA_INV_REF_V'
143398: WHEN 9 THEN 'CST_XLA_INV_REF_V'

Line 143395: WHEN 6 THEN 'CST_XLA_INV_REF_V'

143391: WHEN 2 THEN 'CST_XLA_INV_REF_V'
143392: WHEN 3 THEN 'CST_XLA_INV_REF_V'
143393: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
143394: WHEN 5 THEN 'CST_XLA_INV_REF_V'
143395: WHEN 6 THEN 'CST_XLA_INV_REF_V'
143396: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
143397: WHEN 8 THEN 'CST_XLA_INV_REF_V'
143398: WHEN 9 THEN 'CST_XLA_INV_REF_V'
143399: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'

Line 143397: WHEN 8 THEN 'CST_XLA_INV_REF_V'

143393: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
143394: WHEN 5 THEN 'CST_XLA_INV_REF_V'
143395: WHEN 6 THEN 'CST_XLA_INV_REF_V'
143396: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
143397: WHEN 8 THEN 'CST_XLA_INV_REF_V'
143398: WHEN 9 THEN 'CST_XLA_INV_REF_V'
143399: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
143400: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
143401: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'

Line 143398: WHEN 9 THEN 'CST_XLA_INV_REF_V'

143394: WHEN 5 THEN 'CST_XLA_INV_REF_V'
143395: WHEN 6 THEN 'CST_XLA_INV_REF_V'
143396: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
143397: WHEN 8 THEN 'CST_XLA_INV_REF_V'
143398: WHEN 9 THEN 'CST_XLA_INV_REF_V'
143399: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
143400: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
143401: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
143402:

Line 143478: , CST_XLA_INV_REF_V h3

143474: ELSE null
143475: END source_meaning
143476: FROM xla_events_gt xet
143477: , CST_XLA_INV_HEADERS_V h1
143478: , CST_XLA_INV_REF_V h3
143479: , PO_REQ_DISTS_REF_V h4
143480: , PO_REQ_HEADERS_REF_V h5
143481: , PSA_CST_XLA_UPG_V h6
143482: , fnd_lookup_values fvl12

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

143763: --
143764: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
143765: --
143766:
143767: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
143768: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
143769: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
143770: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143771: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

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

143764: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
143765: --
143766:
143767: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
143768: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
143769: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
143770: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143771: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
143772: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

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

143765: --
143766:
143767: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
143768: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
143769: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
143770: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143771: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
143772: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143773: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

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

143767: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
143768: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
143769: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
143770: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143771: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
143772: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143773: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
143774: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
143775: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

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

143768: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
143769: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
143770: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143771: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
143772: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143773: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
143774: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
143775: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
143776: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

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

143770: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
143771: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
143772: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143773: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
143774: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
143775: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
143776: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
143777: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
143778: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

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

143771: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
143772: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
143773: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
143774: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
143775: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
143776: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
143777: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
143778: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
143779:

Line 143860: , CST_XLA_INV_REF_V h3

143856: , h1.TRANSFER_TO_GL_INDICATOR source_38
143857: , fvl38.meaning source_38_meaning
143858: FROM xla_events_gt xet
143859: , CST_XLA_INV_HEADERS_V h1
143860: , CST_XLA_INV_REF_V h3
143861: , PO_REQ_DISTS_REF_V h4
143862: , PO_REQ_HEADERS_REF_V h5
143863: , PSA_CST_XLA_UPG_V h6
143864: , fnd_lookup_values fvl12

Line 146410: WHEN 1 THEN 'CST_XLA_INV_REF_V'

146406: FROM (
146407: SELECT xet.event_id event_id
146408: , 0 line_number
146409: , CASE r
146410: WHEN 1 THEN 'CST_XLA_INV_REF_V'
146411: WHEN 2 THEN 'CST_XLA_INV_REF_V'
146412: WHEN 3 THEN 'CST_XLA_INV_REF_V'
146413: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
146414: WHEN 5 THEN 'CST_XLA_INV_REF_V'

Line 146411: WHEN 2 THEN 'CST_XLA_INV_REF_V'

146407: SELECT xet.event_id event_id
146408: , 0 line_number
146409: , CASE r
146410: WHEN 1 THEN 'CST_XLA_INV_REF_V'
146411: WHEN 2 THEN 'CST_XLA_INV_REF_V'
146412: WHEN 3 THEN 'CST_XLA_INV_REF_V'
146413: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
146414: WHEN 5 THEN 'CST_XLA_INV_REF_V'
146415: WHEN 6 THEN 'CST_XLA_INV_REF_V'

Line 146412: WHEN 3 THEN 'CST_XLA_INV_REF_V'

146408: , 0 line_number
146409: , CASE r
146410: WHEN 1 THEN 'CST_XLA_INV_REF_V'
146411: WHEN 2 THEN 'CST_XLA_INV_REF_V'
146412: WHEN 3 THEN 'CST_XLA_INV_REF_V'
146413: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
146414: WHEN 5 THEN 'CST_XLA_INV_REF_V'
146415: WHEN 6 THEN 'CST_XLA_INV_REF_V'
146416: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'

Line 146414: WHEN 5 THEN 'CST_XLA_INV_REF_V'

146410: WHEN 1 THEN 'CST_XLA_INV_REF_V'
146411: WHEN 2 THEN 'CST_XLA_INV_REF_V'
146412: WHEN 3 THEN 'CST_XLA_INV_REF_V'
146413: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
146414: WHEN 5 THEN 'CST_XLA_INV_REF_V'
146415: WHEN 6 THEN 'CST_XLA_INV_REF_V'
146416: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
146417: WHEN 8 THEN 'CST_XLA_INV_REF_V'
146418: WHEN 9 THEN 'CST_XLA_INV_REF_V'

Line 146415: WHEN 6 THEN 'CST_XLA_INV_REF_V'

146411: WHEN 2 THEN 'CST_XLA_INV_REF_V'
146412: WHEN 3 THEN 'CST_XLA_INV_REF_V'
146413: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
146414: WHEN 5 THEN 'CST_XLA_INV_REF_V'
146415: WHEN 6 THEN 'CST_XLA_INV_REF_V'
146416: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
146417: WHEN 8 THEN 'CST_XLA_INV_REF_V'
146418: WHEN 9 THEN 'CST_XLA_INV_REF_V'
146419: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'

Line 146417: WHEN 8 THEN 'CST_XLA_INV_REF_V'

146413: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
146414: WHEN 5 THEN 'CST_XLA_INV_REF_V'
146415: WHEN 6 THEN 'CST_XLA_INV_REF_V'
146416: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
146417: WHEN 8 THEN 'CST_XLA_INV_REF_V'
146418: WHEN 9 THEN 'CST_XLA_INV_REF_V'
146419: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
146420: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
146421: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'

Line 146418: WHEN 9 THEN 'CST_XLA_INV_REF_V'

146414: WHEN 5 THEN 'CST_XLA_INV_REF_V'
146415: WHEN 6 THEN 'CST_XLA_INV_REF_V'
146416: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
146417: WHEN 8 THEN 'CST_XLA_INV_REF_V'
146418: WHEN 9 THEN 'CST_XLA_INV_REF_V'
146419: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
146420: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
146421: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
146422:

Line 146498: , CST_XLA_INV_REF_V h3

146494: ELSE null
146495: END source_meaning
146496: FROM xla_events_gt xet
146497: , CST_XLA_INV_HEADERS_V h1
146498: , CST_XLA_INV_REF_V h3
146499: , PO_REQ_DISTS_REF_V h4
146500: , PO_REQ_HEADERS_REF_V h5
146501: , PSA_CST_XLA_UPG_V h6
146502: , fnd_lookup_values fvl12

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

146783: --
146784: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
146785: --
146786:
146787: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
146788: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
146789: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
146790: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
146791: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

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

146784: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
146785: --
146786:
146787: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
146788: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
146789: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
146790: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
146791: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
146792: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

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

146785: --
146786:
146787: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
146788: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
146789: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
146790: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
146791: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
146792: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
146793: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

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

146787: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
146788: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
146789: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
146790: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
146791: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
146792: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
146793: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
146794: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
146795: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

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

146788: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
146789: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
146790: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
146791: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
146792: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
146793: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
146794: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
146795: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
146796: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

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

146790: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
146791: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
146792: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
146793: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
146794: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
146795: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
146796: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
146797: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
146798: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

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

146791: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
146792: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
146793: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
146794: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
146795: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
146796: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
146797: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
146798: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
146799:

Line 146880: , CST_XLA_INV_REF_V h3

146876: , h1.TRANSFER_TO_GL_INDICATOR source_38
146877: , fvl38.meaning source_38_meaning
146878: FROM xla_events_gt xet
146879: , CST_XLA_INV_HEADERS_V h1
146880: , CST_XLA_INV_REF_V h3
146881: , PO_REQ_DISTS_REF_V h4
146882: , PO_REQ_HEADERS_REF_V h5
146883: , PSA_CST_XLA_UPG_V h6
146884: , fnd_lookup_values fvl12

Line 150569: WHEN 1 THEN 'CST_XLA_INV_REF_V'

150565: FROM (
150566: SELECT xet.event_id event_id
150567: , 0 line_number
150568: , CASE r
150569: WHEN 1 THEN 'CST_XLA_INV_REF_V'
150570: WHEN 2 THEN 'CST_XLA_INV_REF_V'
150571: WHEN 3 THEN 'CST_XLA_INV_REF_V'
150572: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
150573: WHEN 5 THEN 'CST_XLA_INV_REF_V'

Line 150570: WHEN 2 THEN 'CST_XLA_INV_REF_V'

150566: SELECT xet.event_id event_id
150567: , 0 line_number
150568: , CASE r
150569: WHEN 1 THEN 'CST_XLA_INV_REF_V'
150570: WHEN 2 THEN 'CST_XLA_INV_REF_V'
150571: WHEN 3 THEN 'CST_XLA_INV_REF_V'
150572: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
150573: WHEN 5 THEN 'CST_XLA_INV_REF_V'
150574: WHEN 6 THEN 'CST_XLA_INV_REF_V'

Line 150571: WHEN 3 THEN 'CST_XLA_INV_REF_V'

150567: , 0 line_number
150568: , CASE r
150569: WHEN 1 THEN 'CST_XLA_INV_REF_V'
150570: WHEN 2 THEN 'CST_XLA_INV_REF_V'
150571: WHEN 3 THEN 'CST_XLA_INV_REF_V'
150572: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
150573: WHEN 5 THEN 'CST_XLA_INV_REF_V'
150574: WHEN 6 THEN 'CST_XLA_INV_REF_V'
150575: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'

Line 150573: WHEN 5 THEN 'CST_XLA_INV_REF_V'

150569: WHEN 1 THEN 'CST_XLA_INV_REF_V'
150570: WHEN 2 THEN 'CST_XLA_INV_REF_V'
150571: WHEN 3 THEN 'CST_XLA_INV_REF_V'
150572: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
150573: WHEN 5 THEN 'CST_XLA_INV_REF_V'
150574: WHEN 6 THEN 'CST_XLA_INV_REF_V'
150575: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
150576: WHEN 8 THEN 'CST_XLA_INV_REF_V'
150577: WHEN 9 THEN 'CST_XLA_INV_REF_V'

Line 150574: WHEN 6 THEN 'CST_XLA_INV_REF_V'

150570: WHEN 2 THEN 'CST_XLA_INV_REF_V'
150571: WHEN 3 THEN 'CST_XLA_INV_REF_V'
150572: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
150573: WHEN 5 THEN 'CST_XLA_INV_REF_V'
150574: WHEN 6 THEN 'CST_XLA_INV_REF_V'
150575: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
150576: WHEN 8 THEN 'CST_XLA_INV_REF_V'
150577: WHEN 9 THEN 'CST_XLA_INV_REF_V'
150578: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'

Line 150576: WHEN 8 THEN 'CST_XLA_INV_REF_V'

150572: WHEN 4 THEN 'CST_XLA_INV_HEADERS_V'
150573: WHEN 5 THEN 'CST_XLA_INV_REF_V'
150574: WHEN 6 THEN 'CST_XLA_INV_REF_V'
150575: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
150576: WHEN 8 THEN 'CST_XLA_INV_REF_V'
150577: WHEN 9 THEN 'CST_XLA_INV_REF_V'
150578: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
150579: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
150580: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'

Line 150577: WHEN 9 THEN 'CST_XLA_INV_REF_V'

150573: WHEN 5 THEN 'CST_XLA_INV_REF_V'
150574: WHEN 6 THEN 'CST_XLA_INV_REF_V'
150575: WHEN 7 THEN 'PSA_CST_XLA_UPG_V'
150576: WHEN 8 THEN 'CST_XLA_INV_REF_V'
150577: WHEN 9 THEN 'CST_XLA_INV_REF_V'
150578: WHEN 10 THEN 'PO_REQ_DISTS_REF_V'
150579: WHEN 11 THEN 'PO_REQ_HEADERS_REF_V'
150580: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
150581:

Line 150657: , CST_XLA_INV_REF_V h3

150653: ELSE null
150654: END source_meaning
150655: FROM xla_events_gt xet
150656: , CST_XLA_INV_HEADERS_V h1
150657: , CST_XLA_INV_REF_V h3
150658: , PO_REQ_DISTS_REF_V h4
150659: , PO_REQ_HEADERS_REF_V h5
150660: , PSA_CST_XLA_UPG_V h6
150661: , fnd_lookup_values fvl12

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

150942: --
150943: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
150944: --
150945:
150946: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
150947: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
150948: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
150949: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
150950: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

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

150943: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
150944: --
150945:
150946: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
150947: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
150948: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
150949: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
150950: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
150951: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

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

150944: --
150945:
150946: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
150947: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
150948: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
150949: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
150950: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
150951: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
150952: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

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

150946: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
150947: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
150948: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
150949: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
150950: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
150951: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
150952: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
150953: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
150954: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

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

150947: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
150948: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
150949: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
150950: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
150951: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
150952: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
150953: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
150954: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
150955: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

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

150949: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
150950: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
150951: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
150952: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
150953: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
150954: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
150955: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
150956: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
150957: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

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

150950: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
150951: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
150952: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
150953: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
150954: TYPE t_array_source_29 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
150955: TYPE t_array_source_30 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
150956: TYPE t_array_source_31 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
150957: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
150958:

Line 151039: , CST_XLA_INV_REF_V h3

151035: , h1.TRANSFER_TO_GL_INDICATOR source_38
151036: , fvl38.meaning source_38_meaning
151037: FROM xla_events_gt xet
151038: , CST_XLA_INV_HEADERS_V h1
151039: , CST_XLA_INV_REF_V h3
151040: , PO_REQ_DISTS_REF_V h4
151041: , PO_REQ_HEADERS_REF_V h5
151042: , PSA_CST_XLA_UPG_V h6
151043: , fnd_lookup_values fvl12

Line 164939: WHEN 1 THEN 'CST_XLA_INV_REF_V'

164935: FROM (
164936: SELECT xet.event_id event_id
164937: , 0 line_number
164938: , CASE r
164939: WHEN 1 THEN 'CST_XLA_INV_REF_V'
164940: WHEN 2 THEN 'CST_XLA_INV_REF_V'
164941: WHEN 3 THEN 'CST_XLA_INV_REF_V'
164942: WHEN 4 THEN 'CST_XLA_INV_REF_V'
164943: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'

Line 164940: WHEN 2 THEN 'CST_XLA_INV_REF_V'

164936: SELECT xet.event_id event_id
164937: , 0 line_number
164938: , CASE r
164939: WHEN 1 THEN 'CST_XLA_INV_REF_V'
164940: WHEN 2 THEN 'CST_XLA_INV_REF_V'
164941: WHEN 3 THEN 'CST_XLA_INV_REF_V'
164942: WHEN 4 THEN 'CST_XLA_INV_REF_V'
164943: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'
164944: WHEN 6 THEN 'PO_DISTS_REF_V'

Line 164941: WHEN 3 THEN 'CST_XLA_INV_REF_V'

164937: , 0 line_number
164938: , CASE r
164939: WHEN 1 THEN 'CST_XLA_INV_REF_V'
164940: WHEN 2 THEN 'CST_XLA_INV_REF_V'
164941: WHEN 3 THEN 'CST_XLA_INV_REF_V'
164942: WHEN 4 THEN 'CST_XLA_INV_REF_V'
164943: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'
164944: WHEN 6 THEN 'PO_DISTS_REF_V'
164945: WHEN 7 THEN 'CST_XLA_INV_REF_V'

Line 164942: WHEN 4 THEN 'CST_XLA_INV_REF_V'

164938: , CASE r
164939: WHEN 1 THEN 'CST_XLA_INV_REF_V'
164940: WHEN 2 THEN 'CST_XLA_INV_REF_V'
164941: WHEN 3 THEN 'CST_XLA_INV_REF_V'
164942: WHEN 4 THEN 'CST_XLA_INV_REF_V'
164943: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'
164944: WHEN 6 THEN 'PO_DISTS_REF_V'
164945: WHEN 7 THEN 'CST_XLA_INV_REF_V'
164946: WHEN 8 THEN 'CST_XLA_INV_REF_V'

Line 164945: WHEN 7 THEN 'CST_XLA_INV_REF_V'

164941: WHEN 3 THEN 'CST_XLA_INV_REF_V'
164942: WHEN 4 THEN 'CST_XLA_INV_REF_V'
164943: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'
164944: WHEN 6 THEN 'PO_DISTS_REF_V'
164945: WHEN 7 THEN 'CST_XLA_INV_REF_V'
164946: WHEN 8 THEN 'CST_XLA_INV_REF_V'
164947: WHEN 9 THEN 'PO_HEADERS_REF_V'
164948: WHEN 10 THEN 'PSA_CST_XLA_UPG_V'
164949: WHEN 11 THEN 'CST_XLA_INV_REF_V'

Line 164946: WHEN 8 THEN 'CST_XLA_INV_REF_V'

164942: WHEN 4 THEN 'CST_XLA_INV_REF_V'
164943: WHEN 5 THEN 'CST_XLA_INV_HEADERS_V'
164944: WHEN 6 THEN 'PO_DISTS_REF_V'
164945: WHEN 7 THEN 'CST_XLA_INV_REF_V'
164946: WHEN 8 THEN 'CST_XLA_INV_REF_V'
164947: WHEN 9 THEN 'PO_HEADERS_REF_V'
164948: WHEN 10 THEN 'PSA_CST_XLA_UPG_V'
164949: WHEN 11 THEN 'CST_XLA_INV_REF_V'
164950: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'

Line 164949: WHEN 11 THEN 'CST_XLA_INV_REF_V'

164945: WHEN 7 THEN 'CST_XLA_INV_REF_V'
164946: WHEN 8 THEN 'CST_XLA_INV_REF_V'
164947: WHEN 9 THEN 'PO_HEADERS_REF_V'
164948: WHEN 10 THEN 'PSA_CST_XLA_UPG_V'
164949: WHEN 11 THEN 'CST_XLA_INV_REF_V'
164950: WHEN 12 THEN 'CST_XLA_INV_HEADERS_V'
164951:
164952: ELSE null
164953: END object_name

Line 165027: , CST_XLA_INV_REF_V h3

165023: ELSE null
165024: END source_meaning
165025: FROM xla_events_gt xet
165026: , CST_XLA_INV_HEADERS_V h1
165027: , CST_XLA_INV_REF_V h3
165028: , PO_DISTS_REF_V h4
165029: , PO_HEADERS_REF_V h5
165030: , PSA_CST_XLA_UPG_V h6
165031: , fnd_lookup_values fvl12

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

165312: --
165313: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
165314: --
165315:
165316: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
165317: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
165318: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
165319: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
165320: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

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

165313: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
165314: --
165315:
165316: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
165317: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
165318: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
165319: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
165320: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
165321: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;

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

165314: --
165315:
165316: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
165317: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
165318: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
165319: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
165320: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
165321: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
165322: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;

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

165315:
165316: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
165317: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
165318: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
165319: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
165320: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
165321: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
165322: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
165323: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

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

165318: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
165319: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
165320: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
165321: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
165322: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
165323: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
165324: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
165325: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
165326: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;

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

165319: TYPE t_array_source_10 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
165320: TYPE t_array_source_12 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
165321: TYPE t_array_source_13 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
165322: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
165323: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
165324: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
165325: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
165326: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
165327: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

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

165322: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
165323: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
165324: TYPE t_array_source_23 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
165325: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
165326: TYPE t_array_source_28 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
165327: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
165328:
165329: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
165330: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 165409: , CST_XLA_INV_REF_V h3

165405: , h1.TRANSFER_TO_GL_INDICATOR source_38
165406: , fvl38.meaning source_38_meaning
165407: FROM xla_events_gt xet
165408: , CST_XLA_INV_HEADERS_V h1
165409: , CST_XLA_INV_REF_V h3
165410: , PO_DISTS_REF_V h4
165411: , PO_HEADERS_REF_V h5
165412: , PSA_CST_XLA_UPG_V h6
165413: , fnd_lookup_values fvl12