DBA Data[Home] [Help]

APPS.XLA_00707_AAD_S_000019_PKG dependencies on PO_HEADERS_REF_V

Line 313655: WHEN 14 THEN 'PO_HEADERS_REF_V'

313651: WHEN 10 THEN 'CST_XLA_RCV_REF_V'
313652: WHEN 11 THEN 'CST_XLA_RCV_HEADERS_V'
313653: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
313654: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
313655: WHEN 14 THEN 'PO_HEADERS_REF_V'
313656: WHEN 15 THEN 'PSA_CST_XLA_UPG_V'
313657: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
313658:
313659: ELSE null

Line 313752: , PO_HEADERS_REF_V h5

313748: FROM xla_events_gt xet
313749: , CST_XLA_RCV_HEADERS_V h1
313750: , CST_XLA_RCV_REF_V h3
313751: , PO_DISTS_REF_V h4
313752: , PO_HEADERS_REF_V h5
313753: , PSA_CST_XLA_UPG_V h6
313754: , fnd_lookup_values fvl85
313755: , fnd_lookup_values fvl114
313756: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

Line 314032: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

314028: TYPE t_array_source_89 IS TABLE OF CST_XLA_RCV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
314029: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
314030: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
314031: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
314032: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
314033: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
314034: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
314035:
314036: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 314118: , PO_HEADERS_REF_V h5

314114: FROM xla_events_gt xet
314115: , CST_XLA_RCV_HEADERS_V h1
314116: , CST_XLA_RCV_REF_V h3
314117: , PO_DISTS_REF_V h4
314118: , PO_HEADERS_REF_V h5
314119: , PSA_CST_XLA_UPG_V h6
314120: , fnd_lookup_values fvl85
314121: , fnd_lookup_values fvl114
314122: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 357739: WHEN 21 THEN 'PO_HEADERS_REF_V'

357735: WHEN 17 THEN 'CST_XLA_INV_HEADERS_V'
357736: WHEN 18 THEN 'PO_DISTS_REF_V'
357737: WHEN 19 THEN 'CST_XLA_INV_REF_V'
357738: WHEN 20 THEN 'CST_XLA_INV_REF_V'
357739: WHEN 21 THEN 'PO_HEADERS_REF_V'
357740: WHEN 22 THEN 'PSA_CST_XLA_UPG_V'
357741: WHEN 23 THEN 'CST_XLA_INV_REF_V'
357742: WHEN 24 THEN 'CST_XLA_INV_HEADERS_V'
357743:

Line 357872: , PO_HEADERS_REF_V h8

357868: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
357869: , CST_XLA_INV_TXN_TYPES_REF_V h5
357870: , CST_XLA_PLA_CATEGORY_REF_V h6
357871: , PO_DISTS_REF_V h7
357872: , PO_HEADERS_REF_V h8
357873: , PSA_CST_XLA_UPG_V h9
357874: , fnd_lookup_values fvl85
357875: , fnd_lookup_values fvl114
357876: ,(select rownum r from all_objects where rownum <= 24 and owner = p_apps_owner)

Line 358199: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

358195: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
358196: TYPE t_array_source_86 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
358197: TYPE t_array_source_87 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
358198: TYPE t_array_source_89 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
358199: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
358200: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
358201: TYPE t_array_source_101 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
358202: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
358203:

Line 358318: , PO_HEADERS_REF_V h8

358314: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
358315: , CST_XLA_INV_TXN_TYPES_REF_V h5
358316: , CST_XLA_PLA_CATEGORY_REF_V h6
358317: , PO_DISTS_REF_V h7
358318: , PO_HEADERS_REF_V h8
358319: , PSA_CST_XLA_UPG_V h9
358320: , fnd_lookup_values fvl85
358321: , fnd_lookup_values fvl114
358322: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 359614: WHEN 21 THEN 'PO_HEADERS_REF_V'

359610: WHEN 17 THEN 'CST_XLA_INV_HEADERS_V'
359611: WHEN 18 THEN 'PO_DISTS_REF_V'
359612: WHEN 19 THEN 'CST_XLA_INV_REF_V'
359613: WHEN 20 THEN 'CST_XLA_INV_REF_V'
359614: WHEN 21 THEN 'PO_HEADERS_REF_V'
359615: WHEN 22 THEN 'PSA_CST_XLA_UPG_V'
359616: WHEN 23 THEN 'CST_XLA_INV_REF_V'
359617: WHEN 24 THEN 'CST_XLA_INV_HEADERS_V'
359618:

Line 359747: , PO_HEADERS_REF_V h8

359743: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
359744: , CST_XLA_INV_TXN_TYPES_REF_V h5
359745: , CST_XLA_PLA_CATEGORY_REF_V h6
359746: , PO_DISTS_REF_V h7
359747: , PO_HEADERS_REF_V h8
359748: , PSA_CST_XLA_UPG_V h9
359749: , fnd_lookup_values fvl85
359750: , fnd_lookup_values fvl114
359751: ,(select rownum r from all_objects where rownum <= 24 and owner = p_apps_owner)

Line 360074: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

360070: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
360071: TYPE t_array_source_86 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
360072: TYPE t_array_source_87 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
360073: TYPE t_array_source_89 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
360074: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
360075: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
360076: TYPE t_array_source_101 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
360077: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
360078:

Line 360193: , PO_HEADERS_REF_V h8

360189: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
360190: , CST_XLA_INV_TXN_TYPES_REF_V h5
360191: , CST_XLA_PLA_CATEGORY_REF_V h6
360192: , PO_DISTS_REF_V h7
360193: , PO_HEADERS_REF_V h8
360194: , PSA_CST_XLA_UPG_V h9
360195: , fnd_lookup_values fvl85
360196: , fnd_lookup_values fvl114
360197: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 361490: WHEN 22 THEN 'PO_HEADERS_REF_V'

361486: WHEN 18 THEN 'CST_XLA_INV_HEADERS_V'
361487: WHEN 19 THEN 'PO_DISTS_REF_V'
361488: WHEN 20 THEN 'CST_XLA_INV_REF_V'
361489: WHEN 21 THEN 'CST_XLA_INV_REF_V'
361490: WHEN 22 THEN 'PO_HEADERS_REF_V'
361491: WHEN 23 THEN 'PSA_CST_XLA_UPG_V'
361492: WHEN 24 THEN 'CST_XLA_INV_REF_V'
361493: WHEN 25 THEN 'CST_XLA_INV_HEADERS_V'
361494:

Line 361627: , PO_HEADERS_REF_V h8

361623: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
361624: , CST_XLA_INV_TXN_TYPES_REF_V h5
361625: , CST_XLA_PLA_CATEGORY_REF_V h6
361626: , PO_DISTS_REF_V h7
361627: , PO_HEADERS_REF_V h8
361628: , PSA_CST_XLA_UPG_V h9
361629: , fnd_lookup_values fvl85
361630: , fnd_lookup_values fvl114
361631: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

Line 361955: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

361951: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
361952: TYPE t_array_source_86 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
361953: TYPE t_array_source_87 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
361954: TYPE t_array_source_89 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
361955: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
361956: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
361957: TYPE t_array_source_101 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
361958: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
361959:

Line 362076: , PO_HEADERS_REF_V h8

362072: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
362073: , CST_XLA_INV_TXN_TYPES_REF_V h5
362074: , CST_XLA_PLA_CATEGORY_REF_V h6
362075: , PO_DISTS_REF_V h7
362076: , PO_HEADERS_REF_V h8
362077: , PSA_CST_XLA_UPG_V h9
362078: , fnd_lookup_values fvl85
362079: , fnd_lookup_values fvl114
362080: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 370427: WHEN 15 THEN 'PO_HEADERS_REF_V'

370423: WHEN 11 THEN 'PSA_CST_XLA_PEA_UPG_V'
370424: WHEN 12 THEN 'CST_XLA_RCV_HEADERS_V'
370425: WHEN 13 THEN 'CST_XLA_RCV_HEADERS_V'
370426: WHEN 14 THEN 'CST_XLA_RCV_HEADERS_V'
370427: WHEN 15 THEN 'PO_HEADERS_REF_V'
370428: WHEN 16 THEN 'CST_XLA_RCV_HEADERS_V'
370429:
370430: ELSE null
370431: END object_name

Line 370523: , PO_HEADERS_REF_V h5

370519: FROM xla_events_gt xet
370520: , CST_XLA_RCV_HEADERS_V h1
370521: , CST_XLA_RCV_REF_V h3
370522: , PO_DISTS_REF_V h4
370523: , PO_HEADERS_REF_V h5
370524: , PSA_CST_XLA_PEA_UPG_V h6
370525: , fnd_lookup_values fvl85
370526: , fnd_lookup_values fvl114
370527: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)

Line 370804: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

370800: TYPE t_array_source_90 IS TABLE OF PSA_CST_XLA_PEA_UPG_V.CST_PEA_ENC_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
370801: TYPE t_array_source_92 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_DATE%TYPE INDEX BY BINARY_INTEGER;
370802: TYPE t_array_source_93 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_RATE%TYPE INDEX BY BINARY_INTEGER;
370803: TYPE t_array_source_94 IS TABLE OF CST_XLA_RCV_HEADERS_V.CURRENCY_CONVERSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
370804: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
370805: TYPE t_array_source_114 IS TABLE OF CST_XLA_RCV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
370806:
370807: TYPE t_array_source_11 IS TABLE OF CST_XLA_RCV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
370808: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 370889: , PO_HEADERS_REF_V h5

370885: FROM xla_events_gt xet
370886: , CST_XLA_RCV_HEADERS_V h1
370887: , CST_XLA_RCV_REF_V h3
370888: , PO_DISTS_REF_V h4
370889: , PO_HEADERS_REF_V h5
370890: , PSA_CST_XLA_PEA_UPG_V h6
370891: , fnd_lookup_values fvl85
370892: , fnd_lookup_values fvl114
370893: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 371821: WHEN 22 THEN 'PO_HEADERS_REF_V'

371817: WHEN 18 THEN 'CST_XLA_INV_HEADERS_V'
371818: WHEN 19 THEN 'PO_DISTS_REF_V'
371819: WHEN 20 THEN 'CST_XLA_INV_REF_V'
371820: WHEN 21 THEN 'CST_XLA_INV_REF_V'
371821: WHEN 22 THEN 'PO_HEADERS_REF_V'
371822: WHEN 23 THEN 'PSA_CST_XLA_UPG_V'
371823: WHEN 24 THEN 'CST_XLA_INV_REF_V'
371824: WHEN 25 THEN 'CST_XLA_INV_HEADERS_V'
371825:

Line 371959: , PO_HEADERS_REF_V h10

371955: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
371956: , CST_XLA_INV_TXN_TYPES_REF_V h7
371957: , CST_XLA_PLA_CATEGORY_REF_V h8
371958: , PO_DISTS_REF_V h9
371959: , PO_HEADERS_REF_V h10
371960: , PSA_CST_XLA_UPG_V h11
371961: , fnd_lookup_values fvl85
371962: , fnd_lookup_values fvl114
371963: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

Line 372299: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

372295: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
372296: TYPE t_array_source_86 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
372297: TYPE t_array_source_87 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
372298: TYPE t_array_source_89 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
372299: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
372300: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
372301: TYPE t_array_source_101 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
372302: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
372303:

Line 372424: , PO_HEADERS_REF_V h10

372420: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
372421: , CST_XLA_INV_TXN_TYPES_REF_V h7
372422: , CST_XLA_PLA_CATEGORY_REF_V h8
372423: , PO_DISTS_REF_V h9
372424: , PO_HEADERS_REF_V h10
372425: , PSA_CST_XLA_UPG_V h11
372426: , fnd_lookup_values fvl85
372427: , fnd_lookup_values fvl114
372428: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 373738: WHEN 23 THEN 'PO_HEADERS_REF_V'

373734: WHEN 19 THEN 'CST_XLA_INV_HEADERS_V'
373735: WHEN 20 THEN 'PO_DISTS_REF_V'
373736: WHEN 21 THEN 'CST_XLA_INV_REF_V'
373737: WHEN 22 THEN 'CST_XLA_INV_REF_V'
373738: WHEN 23 THEN 'PO_HEADERS_REF_V'
373739: WHEN 24 THEN 'PSA_CST_XLA_UPG_V'
373740: WHEN 25 THEN 'CST_XLA_INV_REF_V'
373741: WHEN 26 THEN 'CST_XLA_INV_HEADERS_V'
373742:

Line 373880: , PO_HEADERS_REF_V h10

373876: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
373877: , CST_XLA_INV_TXN_TYPES_REF_V h7
373878: , CST_XLA_PLA_CATEGORY_REF_V h8
373879: , PO_DISTS_REF_V h9
373880: , PO_HEADERS_REF_V h10
373881: , PSA_CST_XLA_UPG_V h11
373882: , fnd_lookup_values fvl85
373883: , fnd_lookup_values fvl114
373884: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)

Line 374221: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

374217: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
374218: TYPE t_array_source_86 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
374219: TYPE t_array_source_87 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
374220: TYPE t_array_source_89 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
374221: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
374222: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
374223: TYPE t_array_source_101 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
374224: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
374225:

Line 374348: , PO_HEADERS_REF_V h10

374344: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
374345: , CST_XLA_INV_TXN_TYPES_REF_V h7
374346: , CST_XLA_PLA_CATEGORY_REF_V h8
374347: , PO_DISTS_REF_V h9
374348: , PO_HEADERS_REF_V h10
374349: , PSA_CST_XLA_UPG_V h11
374350: , fnd_lookup_values fvl85
374351: , fnd_lookup_values fvl114
374352: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 380764: WHEN 22 THEN 'PO_HEADERS_REF_V'

380760: WHEN 18 THEN 'CST_XLA_INV_HEADERS_V'
380761: WHEN 19 THEN 'PO_DISTS_REF_V'
380762: WHEN 20 THEN 'CST_XLA_INV_REF_V'
380763: WHEN 21 THEN 'CST_XLA_INV_REF_V'
380764: WHEN 22 THEN 'PO_HEADERS_REF_V'
380765: WHEN 23 THEN 'PSA_CST_XLA_UPG_V'
380766: WHEN 24 THEN 'CST_XLA_INV_REF_V'
380767: WHEN 25 THEN 'CST_XLA_INV_HEADERS_V'
380768:

Line 380902: , PO_HEADERS_REF_V h10

380898: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
380899: , CST_XLA_INV_TXN_TYPES_REF_V h7
380900: , CST_XLA_PLA_CATEGORY_REF_V h8
380901: , PO_DISTS_REF_V h9
380902: , PO_HEADERS_REF_V h10
380903: , PSA_CST_XLA_UPG_V h11
380904: , fnd_lookup_values fvl85
380905: , fnd_lookup_values fvl114
380906: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

Line 381242: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

381238: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
381239: TYPE t_array_source_86 IS TABLE OF PO_DISTS_REF_V.PO_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
381240: TYPE t_array_source_87 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
381241: TYPE t_array_source_89 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
381242: TYPE t_array_source_96 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
381243: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
381244: TYPE t_array_source_101 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
381245: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
381246:

Line 381367: , PO_HEADERS_REF_V h10

381363: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
381364: , CST_XLA_INV_TXN_TYPES_REF_V h7
381365: , CST_XLA_PLA_CATEGORY_REF_V h8
381366: , PO_DISTS_REF_V h9
381367: , PO_HEADERS_REF_V h10
381368: , PSA_CST_XLA_UPG_V h11
381369: , fnd_lookup_values fvl85
381370: , fnd_lookup_values fvl114
381371: WHERE xet.event_date between p_pad_start_date and p_pad_end_date