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 PO_HEADERS_REF_V

Line 13863: WHEN 3 THEN 'PO_HEADERS_REF_V'

13859: , 0 line_number
13860: , CASE r
13861: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
13862: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
13863: WHEN 3 THEN 'PO_HEADERS_REF_V'
13864: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
13865: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
13866: WHEN 6 THEN 'CST_XLA_RCV_REF_V'
13867: WHEN 7 THEN 'CST_XLA_RCV_REF_V'

Line 13872: WHEN 12 THEN 'PO_HEADERS_REF_V'

13868: WHEN 8 THEN 'PO_DISTS_REF_V'
13869: WHEN 9 THEN 'CST_XLA_RCV_REF_V'
13870: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
13871: WHEN 11 THEN 'PSA_CST_XLA_UPG_V'
13872: WHEN 12 THEN 'PO_HEADERS_REF_V'
13873: WHEN 13 THEN 'CST_XLA_RCV_REF_V'
13874: WHEN 14 THEN 'PO_DISTS_REF_V'
13875: WHEN 15 THEN 'CST_XLA_RCV_HEADERS_V'
13876:

Line 13966: , PO_HEADERS_REF_V h5

13962: FROM xla_events_gt xet
13963: , CST_XLA_RCV_HEADERS_V h1
13964: , CST_XLA_RCV_REF_V h3
13965: , PO_DISTS_REF_V h4
13966: , PO_HEADERS_REF_V h5
13967: , PSA_CST_XLA_UPG_V h6
13968: , fnd_lookup_values fvl9
13969: , fnd_lookup_values fvl42
13970: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)

Line 14220: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

14216: --
14217:
14218: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
14219: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
14220: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
14221: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
14222: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
14223: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
14224: TYPE t_array_source_23 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

Line 14229: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

14225: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
14226: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
14227: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
14228: TYPE t_array_source_27 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
14229: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
14230: TYPE t_array_source_30 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
14231: TYPE t_array_source_31 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;
14232: TYPE t_array_source_42 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
14233:

Line 14308: , PO_HEADERS_REF_V h5

14304: FROM xla_events_gt xet
14305: , CST_XLA_RCV_HEADERS_V h1
14306: , CST_XLA_RCV_REF_V h3
14307: , PO_DISTS_REF_V h4
14308: , PO_HEADERS_REF_V h5
14309: , PSA_CST_XLA_UPG_V h6
14310: , fnd_lookup_values fvl9
14311: , fnd_lookup_values fvl42
14312: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 26516: WHEN 7 THEN 'PO_HEADERS_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'
26520: WHEN 11 THEN 'CST_XLA_INV_REF_V'

Line 26527: WHEN 18 THEN 'PO_HEADERS_REF_V'

26523: WHEN 14 THEN 'PO_DISTS_REF_V'
26524: WHEN 15 THEN 'CST_XLA_INV_REF_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

Line 26643: , PO_HEADERS_REF_V h8

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
26646: , fnd_lookup_values fvl42
26647: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)

Line 26906: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%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;
26910: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 26917: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

26913: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
26914: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%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;

Line 27011: , PO_HEADERS_REF_V h8

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
27014: , fnd_lookup_values fvl42
27015: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 27892: WHEN 7 THEN 'PO_HEADERS_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'
27896: WHEN 11 THEN 'CST_XLA_INV_REF_V'

Line 27903: WHEN 18 THEN 'PO_HEADERS_REF_V'

27899: WHEN 14 THEN 'PO_DISTS_REF_V'
27900: WHEN 15 THEN 'CST_XLA_INV_REF_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

Line 28019: , PO_HEADERS_REF_V h8

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
28022: , fnd_lookup_values fvl42
28023: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)

Line 28282: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%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;
28286: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 28293: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

28289: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
28290: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%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;

Line 28387: , PO_HEADERS_REF_V h8

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
28390: , fnd_lookup_values fvl42
28391: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 29268: WHEN 7 THEN 'PO_HEADERS_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'
29272: WHEN 11 THEN 'CST_XLA_INV_REF_V'

Line 29279: WHEN 18 THEN 'PO_HEADERS_REF_V'

29275: WHEN 14 THEN 'PO_DISTS_REF_V'
29276: WHEN 15 THEN 'CST_XLA_INV_REF_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

Line 29395: , PO_HEADERS_REF_V h8

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
29398: , fnd_lookup_values fvl42
29399: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)

Line 29658: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%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;
29662: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 29669: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

29665: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
29666: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%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;

Line 29763: , PO_HEADERS_REF_V h8

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
29766: , fnd_lookup_values fvl42
29767: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 30640: WHEN 3 THEN 'PO_HEADERS_REF_V'

30636: , 0 line_number
30637: , CASE r
30638: WHEN 1 THEN 'CST_XLA_RCV_HEADERS_V'
30639: WHEN 2 THEN 'CST_XLA_RCV_HEADERS_V'
30640: WHEN 3 THEN 'PO_HEADERS_REF_V'
30641: WHEN 4 THEN 'CST_XLA_RCV_REF_V'
30642: WHEN 5 THEN 'CST_XLA_RCV_REF_V'
30643: WHEN 6 THEN 'CST_XLA_RCV_REF_V'
30644: WHEN 7 THEN 'CST_XLA_RCV_REF_V'

Line 30648: WHEN 11 THEN 'PO_HEADERS_REF_V'

30644: WHEN 7 THEN 'CST_XLA_RCV_REF_V'
30645: WHEN 8 THEN 'PO_DISTS_REF_V'
30646: WHEN 9 THEN 'CST_XLA_RCV_REF_V'
30647: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
30648: WHEN 11 THEN 'PO_HEADERS_REF_V'
30649: WHEN 12 THEN 'CST_XLA_RCV_REF_V'
30650: WHEN 13 THEN 'PSA_CST_XLA_PEA_UPG_V'
30651: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
30652:

Line 30738: , PO_HEADERS_REF_V h5

30734: FROM xla_events_gt xet
30735: , CST_XLA_RCV_HEADERS_V h1
30736: , CST_XLA_RCV_REF_V h3
30737: , PO_DISTS_REF_V h4
30738: , PO_HEADERS_REF_V h5
30739: , PSA_CST_XLA_PEA_UPG_V h6
30740: , fnd_lookup_values fvl9
30741: , fnd_lookup_values fvl42
30742: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)

Line 30992: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;

30988: --
30989:
30990: TYPE t_array_source_9 IS TABLE OF CST_XLA_RCV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
30991: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CODE%TYPE INDEX BY BINARY_INTEGER;
30992: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
30993: TYPE t_array_source_19 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;
30994: TYPE t_array_source_20 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_DIST_LINK_TYPE%TYPE INDEX BY BINARY_INTEGER;
30995: TYPE t_array_source_21 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
30996: TYPE t_array_source_23 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;

Line 31000: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

30996: TYPE t_array_source_23 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_PO_DOC_ID%TYPE INDEX BY BINARY_INTEGER;
30997: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
30998: TYPE t_array_source_25 IS TABLE OF CST_XLA_RCV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
30999: TYPE t_array_source_26 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
31000: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
31001: TYPE t_array_source_30 IS TABLE OF CST_XLA_RCV_REF_V.PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
31002: TYPE t_array_source_32 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
31003: TYPE t_array_source_42 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
31004:

Line 31077: , PO_HEADERS_REF_V h5

31073: FROM xla_events_gt xet
31074: , CST_XLA_RCV_HEADERS_V h1
31075: , CST_XLA_RCV_REF_V h3
31076: , PO_DISTS_REF_V h4
31077: , PO_HEADERS_REF_V h5
31078: , PSA_CST_XLA_PEA_UPG_V h6
31079: , fnd_lookup_values fvl9
31080: , fnd_lookup_values fvl42
31081: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 31940: WHEN 7 THEN 'PO_HEADERS_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'
31944: WHEN 11 THEN 'CST_XLA_INV_REF_V'

Line 31951: WHEN 18 THEN 'PO_HEADERS_REF_V'

31947: WHEN 14 THEN 'PO_DISTS_REF_V'
31948: WHEN 15 THEN 'CST_XLA_INV_REF_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

Line 32067: , PO_HEADERS_REF_V h8

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
32070: , fnd_lookup_values fvl42
32071: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)

Line 32330: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%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;
32334: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 32341: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

32337: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
32338: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%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;

Line 32435: , PO_HEADERS_REF_V h8

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
32438: , fnd_lookup_values fvl42
32439: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 33316: WHEN 7 THEN 'PO_HEADERS_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'
33320: WHEN 11 THEN 'CST_XLA_INV_REF_V'

Line 33327: WHEN 18 THEN 'PO_HEADERS_REF_V'

33323: WHEN 14 THEN 'PO_DISTS_REF_V'
33324: WHEN 15 THEN 'CST_XLA_INV_REF_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

Line 33443: , PO_HEADERS_REF_V h8

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
33446: , fnd_lookup_values fvl42
33447: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)

Line 33706: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%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;
33710: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 33717: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

33713: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
33714: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%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;

Line 33811: , PO_HEADERS_REF_V h8

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
33814: , fnd_lookup_values fvl42
33815: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 34692: WHEN 7 THEN 'PO_HEADERS_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'
34696: WHEN 11 THEN 'CST_XLA_INV_REF_V'

Line 34703: WHEN 18 THEN 'PO_HEADERS_REF_V'

34699: WHEN 14 THEN 'PO_DISTS_REF_V'
34700: WHEN 15 THEN 'CST_XLA_INV_REF_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

Line 34819: , PO_HEADERS_REF_V h8

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
34822: , fnd_lookup_values fvl42
34823: ,(select rownum r from all_objects where rownum <= 20 and owner = p_apps_owner)

Line 35082: TYPE t_array_source_16 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%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;
35086: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 35093: TYPE t_array_source_28 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

35089: TYPE t_array_source_24 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
35090: TYPE t_array_source_25 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%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;

Line 35187: , PO_HEADERS_REF_V h8

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
35190: , fnd_lookup_values fvl42
35191: WHERE xet.event_date between p_pad_start_date and p_pad_end_date