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_TXN_TYPES_REF_V

Line 15160: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'

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

Line 15287: , CST_XLA_INV_TXN_TYPES_REF_V h6

15283: , CST_XLA_INV_HEADERS_V h1
15284: , CST_XLA_INV_ORG_PARAMS_REF_V h3
15285: , CST_XLA_INV_REF_V h4
15286: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
15287: , CST_XLA_INV_TXN_TYPES_REF_V h6
15288: , PO_REQ_DISTS_REF_V h7
15289: , PO_REQ_HEADERS_REF_V h8
15290: , PSA_CST_XLA_UPG_V h9
15291: , fnd_lookup_values fvl9

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

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

Line 15647: , CST_XLA_INV_TXN_TYPES_REF_V h6

15643: , CST_XLA_INV_HEADERS_V h1
15644: , CST_XLA_INV_ORG_PARAMS_REF_V h3
15645: , CST_XLA_INV_REF_V h4
15646: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
15647: , CST_XLA_INV_TXN_TYPES_REF_V h6
15648: , PO_REQ_DISTS_REF_V h7
15649: , PO_REQ_HEADERS_REF_V h8
15650: , PSA_CST_XLA_UPG_V h9
15651: , fnd_lookup_values fvl9

Line 16490: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'

16486: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
16487: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
16488: WHEN 3 THEN 'CST_XLA_INV_REF_V'
16489: WHEN 4 THEN 'CST_XLA_INV_REF_V'
16490: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
16491: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
16492: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
16493:
16494: ELSE null

Line 16551: , CST_XLA_INV_TXN_TYPES_REF_V h5

16547: FROM xla_events_gt xet
16548: , CST_XLA_INV_HEADERS_V h1
16549: , CST_XLA_INV_REF_V h3
16550: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
16551: , CST_XLA_INV_TXN_TYPES_REF_V h5
16552: , fnd_lookup_values fvl9
16553: , fnd_lookup_values fvl42
16554: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
16555: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

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

Line 16917: , CST_XLA_INV_TXN_TYPES_REF_V h5

16913: FROM xla_events_gt xet
16914: , CST_XLA_INV_HEADERS_V h1
16915: , CST_XLA_INV_REF_V h3
16916: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
16917: , CST_XLA_INV_TXN_TYPES_REF_V h5
16918: , fnd_lookup_values fvl9
16919: , fnd_lookup_values fvl42
16920: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
16921: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 17737: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'

17733: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
17734: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
17735: WHEN 3 THEN 'CST_XLA_INV_REF_V'
17736: WHEN 4 THEN 'CST_XLA_INV_REF_V'
17737: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
17738: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
17739: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
17740:
17741: ELSE null

Line 17798: , CST_XLA_INV_TXN_TYPES_REF_V h5

17794: FROM xla_events_gt xet
17795: , CST_XLA_INV_HEADERS_V h1
17796: , CST_XLA_INV_REF_V h3
17797: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
17798: , CST_XLA_INV_TXN_TYPES_REF_V h5
17799: , fnd_lookup_values fvl9
17800: , fnd_lookup_values fvl42
17801: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
17802: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

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

Line 18164: , CST_XLA_INV_TXN_TYPES_REF_V h5

18160: FROM xla_events_gt xet
18161: , CST_XLA_INV_HEADERS_V h1
18162: , CST_XLA_INV_REF_V h3
18163: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
18164: , CST_XLA_INV_TXN_TYPES_REF_V h5
18165: , fnd_lookup_values fvl9
18166: , fnd_lookup_values fvl42
18167: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
18168: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 18984: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'

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

Line 19111: , CST_XLA_INV_TXN_TYPES_REF_V h6

19107: , CST_XLA_INV_HEADERS_V h1
19108: , CST_XLA_INV_ORG_PARAMS_REF_V h3
19109: , CST_XLA_INV_REF_V h4
19110: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
19111: , CST_XLA_INV_TXN_TYPES_REF_V h6
19112: , PO_REQ_DISTS_REF_V h7
19113: , PO_REQ_HEADERS_REF_V h8
19114: , PSA_CST_XLA_UPG_V h9
19115: , fnd_lookup_values fvl9

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

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

Line 19478: , CST_XLA_INV_TXN_TYPES_REF_V h6

19474: , CST_XLA_INV_HEADERS_V h1
19475: , CST_XLA_INV_ORG_PARAMS_REF_V h3
19476: , CST_XLA_INV_REF_V h4
19477: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
19478: , CST_XLA_INV_TXN_TYPES_REF_V h6
19479: , PO_REQ_DISTS_REF_V h7
19480: , PO_REQ_HEADERS_REF_V h8
19481: , PSA_CST_XLA_UPG_V h9
19482: , fnd_lookup_values fvl9

Line 20324: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'

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

Line 20451: , CST_XLA_INV_TXN_TYPES_REF_V h6

20447: , CST_XLA_INV_HEADERS_V h1
20448: , CST_XLA_INV_ORG_PARAMS_REF_V h3
20449: , CST_XLA_INV_REF_V h4
20450: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
20451: , CST_XLA_INV_TXN_TYPES_REF_V h6
20452: , PO_REQ_DISTS_REF_V h7
20453: , PO_REQ_HEADERS_REF_V h8
20454: , PSA_CST_XLA_UPG_V h9
20455: , fnd_lookup_values fvl9

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

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

Line 20818: , CST_XLA_INV_TXN_TYPES_REF_V h6

20814: , CST_XLA_INV_HEADERS_V h1
20815: , CST_XLA_INV_ORG_PARAMS_REF_V h3
20816: , CST_XLA_INV_REF_V h4
20817: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
20818: , CST_XLA_INV_TXN_TYPES_REF_V h6
20819: , PO_REQ_DISTS_REF_V h7
20820: , PO_REQ_HEADERS_REF_V h8
20821: , PSA_CST_XLA_UPG_V h9
20822: , fnd_lookup_values fvl9

Line 24020: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'

24016: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
24017: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
24018: WHEN 3 THEN 'CST_XLA_INV_REF_V'
24019: WHEN 4 THEN 'CST_XLA_INV_REF_V'
24020: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
24021: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
24022: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
24023:
24024: ELSE null

Line 24081: , CST_XLA_INV_TXN_TYPES_REF_V h5

24077: FROM xla_events_gt xet
24078: , CST_XLA_INV_HEADERS_V h1
24079: , CST_XLA_INV_REF_V h3
24080: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
24081: , CST_XLA_INV_TXN_TYPES_REF_V h5
24082: , fnd_lookup_values fvl9
24083: , fnd_lookup_values fvl42
24084: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
24085: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

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

Line 24447: , CST_XLA_INV_TXN_TYPES_REF_V h5

24443: FROM xla_events_gt xet
24444: , CST_XLA_INV_HEADERS_V h1
24445: , CST_XLA_INV_REF_V h3
24446: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
24447: , CST_XLA_INV_TXN_TYPES_REF_V h5
24448: , fnd_lookup_values fvl9
24449: , fnd_lookup_values fvl42
24450: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
24451: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 25267: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'

25263: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
25264: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
25265: WHEN 3 THEN 'CST_XLA_INV_REF_V'
25266: WHEN 4 THEN 'CST_XLA_INV_REF_V'
25267: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
25268: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
25269: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
25270:
25271: ELSE null

Line 25328: , CST_XLA_INV_TXN_TYPES_REF_V h5

25324: FROM xla_events_gt xet
25325: , CST_XLA_INV_HEADERS_V h1
25326: , CST_XLA_INV_REF_V h3
25327: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
25328: , CST_XLA_INV_TXN_TYPES_REF_V h5
25329: , fnd_lookup_values fvl9
25330: , fnd_lookup_values fvl42
25331: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
25332: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

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

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

Line 25694: , CST_XLA_INV_TXN_TYPES_REF_V h5

25690: FROM xla_events_gt xet
25691: , CST_XLA_INV_HEADERS_V h1
25692: , CST_XLA_INV_REF_V h3
25693: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
25694: , CST_XLA_INV_TXN_TYPES_REF_V h5
25695: , fnd_lookup_values fvl9
25696: , fnd_lookup_values fvl42
25697: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
25698: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 26514: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'

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

Line 26641: , CST_XLA_INV_TXN_TYPES_REF_V h6

26637: , CST_XLA_INV_HEADERS_V h1
26638: , CST_XLA_INV_ORG_PARAMS_REF_V h3
26639: , CST_XLA_INV_REF_V h4
26640: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
26641: , CST_XLA_INV_TXN_TYPES_REF_V h6
26642: , PO_DISTS_REF_V h7
26643: , PO_HEADERS_REF_V h8
26644: , PSA_CST_XLA_UPG_V h9
26645: , fnd_lookup_values fvl9

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

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

Line 27009: , CST_XLA_INV_TXN_TYPES_REF_V h6

27005: , CST_XLA_INV_HEADERS_V h1
27006: , CST_XLA_INV_ORG_PARAMS_REF_V h3
27007: , CST_XLA_INV_REF_V h4
27008: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
27009: , CST_XLA_INV_TXN_TYPES_REF_V h6
27010: , PO_DISTS_REF_V h7
27011: , PO_HEADERS_REF_V h8
27012: , PSA_CST_XLA_UPG_V h9
27013: , fnd_lookup_values fvl9

Line 27890: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'

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

Line 28017: , CST_XLA_INV_TXN_TYPES_REF_V h6

28013: , CST_XLA_INV_HEADERS_V h1
28014: , CST_XLA_INV_ORG_PARAMS_REF_V h3
28015: , CST_XLA_INV_REF_V h4
28016: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
28017: , CST_XLA_INV_TXN_TYPES_REF_V h6
28018: , PO_DISTS_REF_V h7
28019: , PO_HEADERS_REF_V h8
28020: , PSA_CST_XLA_UPG_V h9
28021: , fnd_lookup_values fvl9

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

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

Line 28385: , CST_XLA_INV_TXN_TYPES_REF_V h6

28381: , CST_XLA_INV_HEADERS_V h1
28382: , CST_XLA_INV_ORG_PARAMS_REF_V h3
28383: , CST_XLA_INV_REF_V h4
28384: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
28385: , CST_XLA_INV_TXN_TYPES_REF_V h6
28386: , PO_DISTS_REF_V h7
28387: , PO_HEADERS_REF_V h8
28388: , PSA_CST_XLA_UPG_V h9
28389: , fnd_lookup_values fvl9

Line 29266: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'

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

Line 29393: , CST_XLA_INV_TXN_TYPES_REF_V h6

29389: , CST_XLA_INV_HEADERS_V h1
29390: , CST_XLA_INV_ORG_PARAMS_REF_V h3
29391: , CST_XLA_INV_REF_V h4
29392: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
29393: , CST_XLA_INV_TXN_TYPES_REF_V h6
29394: , PO_DISTS_REF_V h7
29395: , PO_HEADERS_REF_V h8
29396: , PSA_CST_XLA_UPG_V h9
29397: , fnd_lookup_values fvl9

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

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

Line 29761: , CST_XLA_INV_TXN_TYPES_REF_V h6

29757: , CST_XLA_INV_HEADERS_V h1
29758: , CST_XLA_INV_ORG_PARAMS_REF_V h3
29759: , CST_XLA_INV_REF_V h4
29760: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
29761: , CST_XLA_INV_TXN_TYPES_REF_V h6
29762: , PO_DISTS_REF_V h7
29763: , PO_HEADERS_REF_V h8
29764: , PSA_CST_XLA_UPG_V h9
29765: , fnd_lookup_values fvl9

Line 31938: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'

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

Line 32065: , CST_XLA_INV_TXN_TYPES_REF_V h6

32061: , CST_XLA_INV_HEADERS_V h1
32062: , CST_XLA_INV_ORG_PARAMS_REF_V h3
32063: , CST_XLA_INV_REF_V h4
32064: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
32065: , CST_XLA_INV_TXN_TYPES_REF_V h6
32066: , PO_DISTS_REF_V h7
32067: , PO_HEADERS_REF_V h8
32068: , PSA_CST_XLA_UPG_V h9
32069: , fnd_lookup_values fvl9

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

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

Line 32433: , CST_XLA_INV_TXN_TYPES_REF_V h6

32429: , CST_XLA_INV_HEADERS_V h1
32430: , CST_XLA_INV_ORG_PARAMS_REF_V h3
32431: , CST_XLA_INV_REF_V h4
32432: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
32433: , CST_XLA_INV_TXN_TYPES_REF_V h6
32434: , PO_DISTS_REF_V h7
32435: , PO_HEADERS_REF_V h8
32436: , PSA_CST_XLA_UPG_V h9
32437: , fnd_lookup_values fvl9

Line 33314: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'

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

Line 33441: , CST_XLA_INV_TXN_TYPES_REF_V h6

33437: , CST_XLA_INV_HEADERS_V h1
33438: , CST_XLA_INV_ORG_PARAMS_REF_V h3
33439: , CST_XLA_INV_REF_V h4
33440: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
33441: , CST_XLA_INV_TXN_TYPES_REF_V h6
33442: , PO_DISTS_REF_V h7
33443: , PO_HEADERS_REF_V h8
33444: , PSA_CST_XLA_UPG_V h9
33445: , fnd_lookup_values fvl9

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

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

Line 33809: , CST_XLA_INV_TXN_TYPES_REF_V h6

33805: , CST_XLA_INV_HEADERS_V h1
33806: , CST_XLA_INV_ORG_PARAMS_REF_V h3
33807: , CST_XLA_INV_REF_V h4
33808: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
33809: , CST_XLA_INV_TXN_TYPES_REF_V h6
33810: , PO_DISTS_REF_V h7
33811: , PO_HEADERS_REF_V h8
33812: , PSA_CST_XLA_UPG_V h9
33813: , fnd_lookup_values fvl9

Line 34690: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'

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

Line 34817: , CST_XLA_INV_TXN_TYPES_REF_V h6

34813: , CST_XLA_INV_HEADERS_V h1
34814: , CST_XLA_INV_ORG_PARAMS_REF_V h3
34815: , CST_XLA_INV_REF_V h4
34816: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
34817: , CST_XLA_INV_TXN_TYPES_REF_V h6
34818: , PO_DISTS_REF_V h7
34819: , PO_HEADERS_REF_V h8
34820: , PSA_CST_XLA_UPG_V h9
34821: , fnd_lookup_values fvl9

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

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

Line 35185: , CST_XLA_INV_TXN_TYPES_REF_V h6

35181: , CST_XLA_INV_HEADERS_V h1
35182: , CST_XLA_INV_ORG_PARAMS_REF_V h3
35183: , CST_XLA_INV_REF_V h4
35184: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
35185: , CST_XLA_INV_TXN_TYPES_REF_V h6
35186: , PO_DISTS_REF_V h7
35187: , PO_HEADERS_REF_V h8
35188: , PSA_CST_XLA_UPG_V h9
35189: , fnd_lookup_values fvl9