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_HEADERS_V

Line 15156: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

15152: FROM (
15153: SELECT xet.event_id event_id
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'

Line 15161: WHEN 6 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'
15164: WHEN 9 THEN 'CST_XLA_INV_REF_V'
15165: WHEN 10 THEN 'CST_XLA_INV_REF_V'

Line 15175: WHEN 20 THEN 'CST_XLA_INV_HEADERS_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:
15177: ELSE null
15178: END object_name
15179: , CASE r

Line 15283: , CST_XLA_INV_HEADERS_V h1

15279:
15280: ELSE null
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

Line 15541: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

15537: --
15538: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 15546: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%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;
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;

Line 15560: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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:
15562: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
15563: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
15564:

Line 15643: , CST_XLA_INV_HEADERS_V h1

15639: , h8.REQ_ENCUMBRANCE_TYPE_ID source_40
15640: , h1.TRANSFER_TO_GL_INDICATOR source_42
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

Line 16486: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

16482: FROM (
16483: SELECT xet.event_id event_id
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'

Line 16491: WHEN 6 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:
16494: ELSE null
16495: END object_name

Line 16492: WHEN 7 THEN 'CST_XLA_INV_HEADERS_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:
16494: ELSE null
16495: END object_name
16496: , CASE r

Line 16548: , CST_XLA_INV_HEADERS_V h1

16544:
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

Line 16836: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

16832: --
16833: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 16841: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%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:
16844: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16845: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 16842: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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:
16844: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
16845: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
16846: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 16914: , CST_XLA_INV_HEADERS_V h1

16910: , fvl9.meaning source_9_meaning
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

Line 17733: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

17729: FROM (
17730: SELECT xet.event_id event_id
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'

Line 17738: WHEN 6 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:
17741: ELSE null
17742: END object_name

Line 17739: WHEN 7 THEN 'CST_XLA_INV_HEADERS_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:
17741: ELSE null
17742: END object_name
17743: , CASE r

Line 17795: , CST_XLA_INV_HEADERS_V h1

17791:
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

Line 18083: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

18079: --
18080: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 18088: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%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:
18091: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18092: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 18089: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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:
18091: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
18092: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
18093: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 18161: , CST_XLA_INV_HEADERS_V h1

18157: , fvl9.meaning source_9_meaning
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

Line 18980: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

18976: FROM (
18977: SELECT xet.event_id event_id
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'

Line 18985: WHEN 6 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'
18988: WHEN 9 THEN 'CST_XLA_INV_REF_V'
18989: WHEN 10 THEN 'CST_XLA_INV_REF_V'

Line 18999: WHEN 20 THEN 'CST_XLA_INV_HEADERS_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:
19001: ELSE null
19002: END object_name
19003: , CASE r

Line 19107: , CST_XLA_INV_HEADERS_V h1

19103:
19104: ELSE null
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

Line 19369: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

19365: --
19366: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 19374: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%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;
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;

Line 19388: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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:
19390: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
19391: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
19392: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 19474: , CST_XLA_INV_HEADERS_V h1

19470: , h8.REQ_ENCUMBRANCE_TYPE_ID source_40
19471: , h1.TRANSFER_TO_GL_INDICATOR source_42
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

Line 20320: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

20316: FROM (
20317: SELECT xet.event_id event_id
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'

Line 20325: WHEN 6 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'
20328: WHEN 9 THEN 'CST_XLA_INV_REF_V'
20329: WHEN 10 THEN 'CST_XLA_INV_REF_V'

Line 20339: WHEN 20 THEN 'CST_XLA_INV_HEADERS_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:
20341: ELSE null
20342: END object_name
20343: , CASE r

Line 20447: , CST_XLA_INV_HEADERS_V h1

20443:
20444: ELSE null
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

Line 20709: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

20705: --
20706: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 20714: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%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;
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;

Line 20728: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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:
20730: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
20731: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
20732: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 20814: , CST_XLA_INV_HEADERS_V h1

20810: , h8.REQ_ENCUMBRANCE_TYPE_ID source_40
20811: , h1.TRANSFER_TO_GL_INDICATOR source_42
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

Line 21660: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

21656: FROM (
21657: SELECT xet.event_id event_id
21658: , 0 line_number
21659: , CASE r
21660: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
21661: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
21662:
21663: ELSE null
21664: END object_name

Line 21661: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'

21657: SELECT xet.event_id event_id
21658: , 0 line_number
21659: , CASE r
21660: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
21661: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
21662:
21663: ELSE null
21664: END object_name
21665: , CASE r

Line 21697: , CST_XLA_INV_HEADERS_V h1

21693:
21694: ELSE null
21695: END source_meaning
21696: FROM xla_events_gt xet
21697: , CST_XLA_INV_HEADERS_V h1
21698: , fnd_lookup_values fvl9
21699: , fnd_lookup_values fvl42
21700: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
21701: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 21982: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

21978: --
21979: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
21980: --
21981:
21982: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21983: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
21984:
21985: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21986: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 21983: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

21979: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
21980: --
21981:
21982: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
21983: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
21984:
21985: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
21986: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
21987: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 22045: , CST_XLA_INV_HEADERS_V h1

22041: , fvl9.meaning source_9_meaning
22042: , h1.TRANSFER_TO_GL_INDICATOR source_42
22043: , fvl42.meaning source_42_meaning
22044: FROM xla_events_gt xet
22045: , CST_XLA_INV_HEADERS_V h1
22046: , fnd_lookup_values fvl9
22047: , fnd_lookup_values fvl42
22048: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
22049: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 22838: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

22834: FROM (
22835: SELECT xet.event_id event_id
22836: , 0 line_number
22837: , CASE r
22838: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
22839: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
22840:
22841: ELSE null
22842: END object_name

Line 22839: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'

22835: SELECT xet.event_id event_id
22836: , 0 line_number
22837: , CASE r
22838: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
22839: WHEN 2 THEN 'CST_XLA_INV_HEADERS_V'
22840:
22841: ELSE null
22842: END object_name
22843: , CASE r

Line 22875: , CST_XLA_INV_HEADERS_V h1

22871:
22872: ELSE null
22873: END source_meaning
22874: FROM xla_events_gt xet
22875: , CST_XLA_INV_HEADERS_V h1
22876: , fnd_lookup_values fvl9
22877: , fnd_lookup_values fvl42
22878: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
22879: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 23160: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

23156: --
23157: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
23158: --
23159:
23160: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
23161: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
23162:
23163: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
23164: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 23161: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

23157: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
23158: --
23159:
23160: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
23161: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
23162:
23163: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
23164: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
23165: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 23223: , CST_XLA_INV_HEADERS_V h1

23219: , fvl9.meaning source_9_meaning
23220: , h1.TRANSFER_TO_GL_INDICATOR source_42
23221: , fvl42.meaning source_42_meaning
23222: FROM xla_events_gt xet
23223: , CST_XLA_INV_HEADERS_V h1
23224: , fnd_lookup_values fvl9
23225: , fnd_lookup_values fvl42
23226: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
23227: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 24016: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

24012: FROM (
24013: SELECT xet.event_id event_id
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'

Line 24021: WHEN 6 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:
24024: ELSE null
24025: END object_name

Line 24022: WHEN 7 THEN 'CST_XLA_INV_HEADERS_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:
24024: ELSE null
24025: END object_name
24026: , CASE r

Line 24078: , CST_XLA_INV_HEADERS_V h1

24074:
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

Line 24366: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

24362: --
24363: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 24371: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%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:
24374: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24375: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 24372: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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:
24374: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
24375: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
24376: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 24444: , CST_XLA_INV_HEADERS_V h1

24440: , fvl9.meaning source_9_meaning
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

Line 25263: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

25259: FROM (
25260: SELECT xet.event_id event_id
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'

Line 25268: WHEN 6 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:
25271: ELSE null
25272: END object_name

Line 25269: WHEN 7 THEN 'CST_XLA_INV_HEADERS_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:
25271: ELSE null
25272: END object_name
25273: , CASE r

Line 25325: , CST_XLA_INV_HEADERS_V h1

25321:
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

Line 25613: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

25609: --
25610: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 25618: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%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:
25621: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25622: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 25619: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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:
25621: TYPE t_array_source_6 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
25622: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
25623: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;

Line 25691: , CST_XLA_INV_HEADERS_V h1

25687: , fvl9.meaning source_9_meaning
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

Line 26510: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

26506: FROM (
26507: SELECT xet.event_id event_id
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'

Line 26515: WHEN 6 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'
26518: WHEN 9 THEN 'CST_XLA_INV_REF_V'
26519: WHEN 10 THEN 'CST_XLA_INV_REF_V'

Line 26529: WHEN 20 THEN 'CST_XLA_INV_HEADERS_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'
26530:
26531: ELSE null
26532: END object_name
26533: , CASE r

Line 26637: , CST_XLA_INV_HEADERS_V h1

26633:
26634: ELSE null
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

Line 26900: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

26896: --
26897: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 26905: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%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;
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;

Line 26919: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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;
26920:
26921: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
26922: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
26923: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 27005: , CST_XLA_INV_HEADERS_V h1

27001: , h7.RESERVED_FLAG source_31
27002: , h1.TRANSFER_TO_GL_INDICATOR source_42
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

Line 27886: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

27882: FROM (
27883: SELECT xet.event_id event_id
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'

Line 27891: WHEN 6 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'
27894: WHEN 9 THEN 'CST_XLA_INV_REF_V'
27895: WHEN 10 THEN 'CST_XLA_INV_REF_V'

Line 27905: WHEN 20 THEN 'CST_XLA_INV_HEADERS_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'
27906:
27907: ELSE null
27908: END object_name
27909: , CASE r

Line 28013: , CST_XLA_INV_HEADERS_V h1

28009:
28010: ELSE null
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

Line 28276: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

28272: --
28273: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 28281: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%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;
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;

Line 28295: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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;
28296:
28297: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
28298: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
28299: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 28381: , CST_XLA_INV_HEADERS_V h1

28377: , h7.RESERVED_FLAG source_31
28378: , h1.TRANSFER_TO_GL_INDICATOR source_42
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

Line 29262: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

29258: FROM (
29259: SELECT xet.event_id event_id
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'

Line 29267: WHEN 6 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'
29270: WHEN 9 THEN 'CST_XLA_INV_REF_V'
29271: WHEN 10 THEN 'CST_XLA_INV_REF_V'

Line 29281: WHEN 20 THEN 'CST_XLA_INV_HEADERS_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'
29282:
29283: ELSE null
29284: END object_name
29285: , CASE r

Line 29389: , CST_XLA_INV_HEADERS_V h1

29385:
29386: ELSE null
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

Line 29652: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

29648: --
29649: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 29657: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%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;
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;

Line 29671: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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;
29672:
29673: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
29674: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
29675: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 29757: , CST_XLA_INV_HEADERS_V h1

29753: , h7.RESERVED_FLAG source_31
29754: , h1.TRANSFER_TO_GL_INDICATOR source_42
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

Line 31934: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

31930: FROM (
31931: SELECT xet.event_id event_id
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'

Line 31939: WHEN 6 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'
31942: WHEN 9 THEN 'CST_XLA_INV_REF_V'
31943: WHEN 10 THEN 'CST_XLA_INV_REF_V'

Line 31953: WHEN 20 THEN 'CST_XLA_INV_HEADERS_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'
31954:
31955: ELSE null
31956: END object_name
31957: , CASE r

Line 32061: , CST_XLA_INV_HEADERS_V h1

32057:
32058: ELSE null
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

Line 32324: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

32320: --
32321: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 32329: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%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;
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;

Line 32343: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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;
32344:
32345: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
32346: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
32347: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 32429: , CST_XLA_INV_HEADERS_V h1

32425: , h7.RESERVED_FLAG source_31
32426: , h1.TRANSFER_TO_GL_INDICATOR source_42
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

Line 33310: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

33306: FROM (
33307: SELECT xet.event_id event_id
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'

Line 33315: WHEN 6 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'
33318: WHEN 9 THEN 'CST_XLA_INV_REF_V'
33319: WHEN 10 THEN 'CST_XLA_INV_REF_V'

Line 33329: WHEN 20 THEN 'CST_XLA_INV_HEADERS_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'
33330:
33331: ELSE null
33332: END object_name
33333: , CASE r

Line 33437: , CST_XLA_INV_HEADERS_V h1

33433:
33434: ELSE null
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

Line 33700: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

33696: --
33697: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 33705: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%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;
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;

Line 33719: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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;
33720:
33721: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
33722: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
33723: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 33805: , CST_XLA_INV_HEADERS_V h1

33801: , h7.RESERVED_FLAG source_31
33802: , h1.TRANSFER_TO_GL_INDICATOR source_42
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

Line 34686: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'

34682: FROM (
34683: SELECT xet.event_id event_id
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'

Line 34691: WHEN 6 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'
34694: WHEN 9 THEN 'CST_XLA_INV_REF_V'
34695: WHEN 10 THEN 'CST_XLA_INV_REF_V'

Line 34705: WHEN 20 THEN 'CST_XLA_INV_HEADERS_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'
34706:
34707: ELSE null
34708: END object_name
34709: , CASE r

Line 34813: , CST_XLA_INV_HEADERS_V h1

34809:
34810: ELSE null
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

Line 35076: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

35072: --
35073: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%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;

Line 35081: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%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;
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;

Line 35095: TYPE t_array_source_42 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%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;
35096:
35097: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_LINES_V.ACCOUNTING_LINE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
35098: TYPE t_array_source_8 IS TABLE OF CST_XLA_INV_LINES_V.DISTRIBUTION_IDENTIFIER%TYPE INDEX BY BINARY_INTEGER;
35099: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 35181: , CST_XLA_INV_HEADERS_V h1

35177: , h7.RESERVED_FLAG source_31
35178: , h1.TRANSFER_TO_GL_INDICATOR source_42
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