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_SYSTEM_ITEMS_REF_V

Line 15157: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

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'
15161: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 15286: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

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

Line 15542: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

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

Line 15646: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

15642: FROM xla_events_gt xet
15643: , CST_XLA_INV_HEADERS_V h1
15644: , CST_XLA_INV_ORG_PARAMS_REF_V h3
15645: , CST_XLA_INV_REF_V h4
15646: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
15647: , CST_XLA_INV_TXN_TYPES_REF_V h6
15648: , PO_REQ_DISTS_REF_V h7
15649: , PO_REQ_HEADERS_REF_V h8
15650: , PSA_CST_XLA_UPG_V h9

Line 16487: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

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'
16491: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 16550: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4

16546: END source_meaning
16547: FROM xla_events_gt xet
16548: , CST_XLA_INV_HEADERS_V h1
16549: , CST_XLA_INV_REF_V h3
16550: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
16551: , CST_XLA_INV_TXN_TYPES_REF_V h5
16552: , fnd_lookup_values fvl9
16553: , fnd_lookup_values fvl42
16554: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

Line 16837: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

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;
16841: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 16916: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4

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

Line 17734: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

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'
17738: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 17797: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4

17793: END source_meaning
17794: FROM xla_events_gt xet
17795: , CST_XLA_INV_HEADERS_V h1
17796: , CST_XLA_INV_REF_V h3
17797: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
17798: , CST_XLA_INV_TXN_TYPES_REF_V h5
17799: , fnd_lookup_values fvl9
17800: , fnd_lookup_values fvl42
17801: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

Line 18084: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

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;
18088: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 18163: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4

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

Line 18981: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

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'
18985: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 19110: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

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

Line 19370: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

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

Line 19477: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

19473: FROM xla_events_gt xet
19474: , CST_XLA_INV_HEADERS_V h1
19475: , CST_XLA_INV_ORG_PARAMS_REF_V h3
19476: , CST_XLA_INV_REF_V h4
19477: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
19478: , CST_XLA_INV_TXN_TYPES_REF_V h6
19479: , PO_REQ_DISTS_REF_V h7
19480: , PO_REQ_HEADERS_REF_V h8
19481: , PSA_CST_XLA_UPG_V h9

Line 20321: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

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'
20325: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 20450: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

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

Line 20710: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

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

Line 20817: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

20813: FROM xla_events_gt xet
20814: , CST_XLA_INV_HEADERS_V h1
20815: , CST_XLA_INV_ORG_PARAMS_REF_V h3
20816: , CST_XLA_INV_REF_V h4
20817: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
20818: , CST_XLA_INV_TXN_TYPES_REF_V h6
20819: , PO_REQ_DISTS_REF_V h7
20820: , PO_REQ_HEADERS_REF_V h8
20821: , PSA_CST_XLA_UPG_V h9

Line 24017: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

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'
24021: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 24080: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4

24076: END source_meaning
24077: FROM xla_events_gt xet
24078: , CST_XLA_INV_HEADERS_V h1
24079: , CST_XLA_INV_REF_V h3
24080: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
24081: , CST_XLA_INV_TXN_TYPES_REF_V h5
24082: , fnd_lookup_values fvl9
24083: , fnd_lookup_values fvl42
24084: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

Line 24367: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

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;
24371: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 24446: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4

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

Line 25264: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

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'
25268: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 25327: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4

25323: END source_meaning
25324: FROM xla_events_gt xet
25325: , CST_XLA_INV_HEADERS_V h1
25326: , CST_XLA_INV_REF_V h3
25327: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
25328: , CST_XLA_INV_TXN_TYPES_REF_V h5
25329: , fnd_lookup_values fvl9
25330: , fnd_lookup_values fvl42
25331: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)

Line 25614: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

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;
25618: TYPE t_array_source_9 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 25693: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4

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

Line 26511: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

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'
26515: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 26640: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

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

Line 26901: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

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

Line 27008: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

27004: FROM xla_events_gt xet
27005: , CST_XLA_INV_HEADERS_V h1
27006: , CST_XLA_INV_ORG_PARAMS_REF_V h3
27007: , CST_XLA_INV_REF_V h4
27008: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
27009: , CST_XLA_INV_TXN_TYPES_REF_V h6
27010: , PO_DISTS_REF_V h7
27011: , PO_HEADERS_REF_V h8
27012: , PSA_CST_XLA_UPG_V h9

Line 27887: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

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'
27891: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 28016: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

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

Line 28277: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

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

Line 28384: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

28380: FROM xla_events_gt xet
28381: , CST_XLA_INV_HEADERS_V h1
28382: , CST_XLA_INV_ORG_PARAMS_REF_V h3
28383: , CST_XLA_INV_REF_V h4
28384: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
28385: , CST_XLA_INV_TXN_TYPES_REF_V h6
28386: , PO_DISTS_REF_V h7
28387: , PO_HEADERS_REF_V h8
28388: , PSA_CST_XLA_UPG_V h9

Line 29263: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

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'
29267: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 29392: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

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

Line 29653: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

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

Line 29760: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

29756: FROM xla_events_gt xet
29757: , CST_XLA_INV_HEADERS_V h1
29758: , CST_XLA_INV_ORG_PARAMS_REF_V h3
29759: , CST_XLA_INV_REF_V h4
29760: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
29761: , CST_XLA_INV_TXN_TYPES_REF_V h6
29762: , PO_DISTS_REF_V h7
29763: , PO_HEADERS_REF_V h8
29764: , PSA_CST_XLA_UPG_V h9

Line 31935: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

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'
31939: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 32064: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

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

Line 32325: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

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

Line 32432: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

32428: FROM xla_events_gt xet
32429: , CST_XLA_INV_HEADERS_V h1
32430: , CST_XLA_INV_ORG_PARAMS_REF_V h3
32431: , CST_XLA_INV_REF_V h4
32432: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
32433: , CST_XLA_INV_TXN_TYPES_REF_V h6
32434: , PO_DISTS_REF_V h7
32435: , PO_HEADERS_REF_V h8
32436: , PSA_CST_XLA_UPG_V h9

Line 33311: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

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'
33315: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 33440: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

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

Line 33701: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

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

Line 33808: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

33804: FROM xla_events_gt xet
33805: , CST_XLA_INV_HEADERS_V h1
33806: , CST_XLA_INV_ORG_PARAMS_REF_V h3
33807: , CST_XLA_INV_REF_V h4
33808: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
33809: , CST_XLA_INV_TXN_TYPES_REF_V h6
33810: , PO_DISTS_REF_V h7
33811: , PO_HEADERS_REF_V h8
33812: , PSA_CST_XLA_UPG_V h9

Line 34687: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'

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'
34691: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'

Line 34816: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

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

Line 35077: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

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

Line 35184: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5

35180: FROM xla_events_gt xet
35181: , CST_XLA_INV_HEADERS_V h1
35182: , CST_XLA_INV_ORG_PARAMS_REF_V h3
35183: , CST_XLA_INV_REF_V h4
35184: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
35185: , CST_XLA_INV_TXN_TYPES_REF_V h6
35186: , PO_DISTS_REF_V h7
35187: , PO_HEADERS_REF_V h8
35188: , PSA_CST_XLA_UPG_V h9