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_PKG dependencies on PSA_CST_XLA_UPG_V

Line 313656: WHEN 15 THEN 'PSA_CST_XLA_UPG_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
313660: END object_name

Line 313753: , PSA_CST_XLA_UPG_V h6

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)
313757: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 314033: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%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;
314037: TYPE t_array_source_78 IS TABLE OF CST_XLA_RCV_LINES_V.RCV_ACCOUNTING_LINE_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 314119: , PSA_CST_XLA_UPG_V h6

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
314123: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 315003: WHEN 21 THEN 'PSA_CST_XLA_UPG_V'

314999: WHEN 17 THEN 'CST_XLA_INV_REF_V'
315000: WHEN 18 THEN 'CST_XLA_INV_HEADERS_V'
315001: WHEN 19 THEN 'CST_XLA_INV_REF_V'
315002: WHEN 20 THEN 'CST_XLA_INV_REF_V'
315003: WHEN 21 THEN 'PSA_CST_XLA_UPG_V'
315004: WHEN 22 THEN 'CST_XLA_INV_REF_V'
315005: WHEN 23 THEN 'CST_XLA_INV_REF_V'
315006: WHEN 24 THEN 'PO_REQ_DISTS_REF_V'
315007: WHEN 25 THEN 'PO_REQ_HEADERS_REF_V'

Line 315148: , PSA_CST_XLA_UPG_V h10

315144: , CST_XLA_INV_TXN_TYPES_REF_V h6
315145: , CST_XLA_PLA_CATEGORY_REF_V h7
315146: , PO_REQ_DISTS_REF_V h8
315147: , PO_REQ_HEADERS_REF_V h9
315148: , PSA_CST_XLA_UPG_V h10
315149: , fnd_lookup_values fvl85
315150: , fnd_lookup_values fvl114
315151: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
315152: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 315477: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

315473: TYPE t_array_source_81 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
315474: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
315475: TYPE t_array_source_87 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
315476: TYPE t_array_source_89 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
315477: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
315478: TYPE t_array_source_101 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
315479: TYPE t_array_source_102 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
315480: TYPE t_array_source_103 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
315481: TYPE t_array_source_104 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 315603: , PSA_CST_XLA_UPG_V h10

315599: , CST_XLA_INV_TXN_TYPES_REF_V h6
315600: , CST_XLA_PLA_CATEGORY_REF_V h7
315601: , PO_REQ_DISTS_REF_V h8
315602: , PO_REQ_HEADERS_REF_V h9
315603: , PSA_CST_XLA_UPG_V h10
315604: , fnd_lookup_values fvl85
315605: , fnd_lookup_values fvl114
315606: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
315607: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 323122: WHEN 21 THEN 'PSA_CST_XLA_UPG_V'

323118: WHEN 17 THEN 'CST_XLA_INV_REF_V'
323119: WHEN 18 THEN 'CST_XLA_INV_HEADERS_V'
323120: WHEN 19 THEN 'CST_XLA_INV_REF_V'
323121: WHEN 20 THEN 'CST_XLA_INV_REF_V'
323122: WHEN 21 THEN 'PSA_CST_XLA_UPG_V'
323123: WHEN 22 THEN 'CST_XLA_INV_REF_V'
323124: WHEN 23 THEN 'CST_XLA_INV_REF_V'
323125: WHEN 24 THEN 'PO_REQ_DISTS_REF_V'
323126: WHEN 25 THEN 'PO_REQ_HEADERS_REF_V'

Line 323267: , PSA_CST_XLA_UPG_V h10

323263: , CST_XLA_INV_TXN_TYPES_REF_V h6
323264: , CST_XLA_PLA_CATEGORY_REF_V h7
323265: , PO_REQ_DISTS_REF_V h8
323266: , PO_REQ_HEADERS_REF_V h9
323267: , PSA_CST_XLA_UPG_V h10
323268: , fnd_lookup_values fvl85
323269: , fnd_lookup_values fvl114
323270: ,(select rownum r from all_objects where rownum <= 26 and owner = p_apps_owner)
323271: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 323595: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

323591: TYPE t_array_source_81 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
323592: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
323593: TYPE t_array_source_87 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
323594: TYPE t_array_source_89 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
323595: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
323596: TYPE t_array_source_101 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
323597: TYPE t_array_source_102 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
323598: TYPE t_array_source_103 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
323599: TYPE t_array_source_104 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 323722: , PSA_CST_XLA_UPG_V h10

323718: , CST_XLA_INV_TXN_TYPES_REF_V h6
323719: , CST_XLA_PLA_CATEGORY_REF_V h7
323720: , PO_REQ_DISTS_REF_V h8
323721: , PO_REQ_HEADERS_REF_V h9
323722: , PSA_CST_XLA_UPG_V h10
323723: , fnd_lookup_values fvl85
323724: , fnd_lookup_values fvl114
323725: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
323726: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 325024: WHEN 22 THEN 'PSA_CST_XLA_UPG_V'

325020: WHEN 18 THEN 'CST_XLA_INV_REF_V'
325021: WHEN 19 THEN 'CST_XLA_INV_HEADERS_V'
325022: WHEN 20 THEN 'CST_XLA_INV_REF_V'
325023: WHEN 21 THEN 'CST_XLA_INV_REF_V'
325024: WHEN 22 THEN 'PSA_CST_XLA_UPG_V'
325025: WHEN 23 THEN 'CST_XLA_INV_REF_V'
325026: WHEN 24 THEN 'CST_XLA_INV_REF_V'
325027: WHEN 25 THEN 'PO_REQ_DISTS_REF_V'
325028: WHEN 26 THEN 'PO_REQ_HEADERS_REF_V'

Line 325173: , PSA_CST_XLA_UPG_V h10

325169: , CST_XLA_INV_TXN_TYPES_REF_V h6
325170: , CST_XLA_PLA_CATEGORY_REF_V h7
325171: , PO_REQ_DISTS_REF_V h8
325172: , PO_REQ_HEADERS_REF_V h9
325173: , PSA_CST_XLA_UPG_V h10
325174: , fnd_lookup_values fvl85
325175: , fnd_lookup_values fvl114
325176: ,(select rownum r from all_objects where rownum <= 27 and owner = p_apps_owner)
325177: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 325502: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

325498: TYPE t_array_source_81 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
325499: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
325500: TYPE t_array_source_87 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
325501: TYPE t_array_source_89 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
325502: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
325503: TYPE t_array_source_101 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
325504: TYPE t_array_source_102 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
325505: TYPE t_array_source_103 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
325506: TYPE t_array_source_104 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 325631: , PSA_CST_XLA_UPG_V h10

325627: , CST_XLA_INV_TXN_TYPES_REF_V h6
325628: , CST_XLA_PLA_CATEGORY_REF_V h7
325629: , PO_REQ_DISTS_REF_V h8
325630: , PO_REQ_HEADERS_REF_V h9
325631: , PSA_CST_XLA_UPG_V h10
325632: , fnd_lookup_values fvl85
325633: , fnd_lookup_values fvl114
325634: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
325635: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 331721: WHEN 20 THEN 'PSA_CST_XLA_UPG_V'

331717: WHEN 16 THEN 'CST_XLA_INV_REF_V'
331718: WHEN 17 THEN 'CST_XLA_INV_HEADERS_V'
331719: WHEN 18 THEN 'CST_XLA_INV_REF_V'
331720: WHEN 19 THEN 'CST_XLA_INV_REF_V'
331721: WHEN 20 THEN 'PSA_CST_XLA_UPG_V'
331722: WHEN 21 THEN 'CST_XLA_INV_REF_V'
331723: WHEN 22 THEN 'CST_XLA_INV_REF_V'
331724: WHEN 23 THEN 'PO_REQ_DISTS_REF_V'
331725: WHEN 24 THEN 'PO_REQ_HEADERS_REF_V'

Line 331864: , PSA_CST_XLA_UPG_V h11

331860: , CST_XLA_INV_TXN_TYPES_REF_V h7
331861: , CST_XLA_PLA_CATEGORY_REF_V h8
331862: , PO_REQ_DISTS_REF_V h9
331863: , PO_REQ_HEADERS_REF_V h10
331864: , PSA_CST_XLA_UPG_V h11
331865: , fnd_lookup_values fvl39
331866: , fnd_lookup_values fvl85
331867: , fnd_lookup_values fvl114
331868: ,(select rownum r from all_objects where rownum <= 25 and owner = p_apps_owner)

Line 332196: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;

332192: TYPE t_array_source_81 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
332193: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
332194: TYPE t_array_source_87 IS TABLE OF CST_XLA_INV_REF_V.ENCUM_REVERSAL_AMOUNT_ENTERED%TYPE INDEX BY BINARY_INTEGER;
332195: TYPE t_array_source_89 IS TABLE OF CST_XLA_INV_REF_V.ENCUMBRANCE_REVERSAL_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
332196: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%TYPE INDEX BY BINARY_INTEGER;
332197: TYPE t_array_source_101 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_DISTRIBUTION_ID%TYPE INDEX BY BINARY_INTEGER;
332198: TYPE t_array_source_102 IS TABLE OF CST_XLA_INV_REF_V.TXN_PO_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
332199: TYPE t_array_source_103 IS TABLE OF PO_REQ_DISTS_REF_V.REQ_BUDGET_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
332200: TYPE t_array_source_104 IS TABLE OF PO_REQ_HEADERS_REF_V.REQ_ENCUMBRANCE_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 332324: , PSA_CST_XLA_UPG_V h11

332320: , CST_XLA_INV_TXN_TYPES_REF_V h7
332321: , CST_XLA_PLA_CATEGORY_REF_V h8
332322: , PO_REQ_DISTS_REF_V h9
332323: , PO_REQ_HEADERS_REF_V h10
332324: , PSA_CST_XLA_UPG_V h11
332325: , fnd_lookup_values fvl39
332326: , fnd_lookup_values fvl85
332327: , fnd_lookup_values fvl114
332328: WHERE xet.event_date between p_pad_start_date and p_pad_end_date

Line 357740: WHEN 22 THEN 'PSA_CST_XLA_UPG_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:
357744: ELSE null

Line 357873: , PSA_CST_XLA_UPG_V h9

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)
357877: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 358200: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%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:
358204: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 358319: , PSA_CST_XLA_UPG_V h9

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
358323: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 359615: WHEN 22 THEN 'PSA_CST_XLA_UPG_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:
359619: ELSE null

Line 359748: , PSA_CST_XLA_UPG_V h9

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)
359752: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 360075: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%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:
360079: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 360194: , PSA_CST_XLA_UPG_V h9

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
360198: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 361491: WHEN 23 THEN 'PSA_CST_XLA_UPG_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:
361495: ELSE null

Line 361628: , PSA_CST_XLA_UPG_V h9

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)
361632: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 361956: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%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:
361960: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 362077: , PSA_CST_XLA_UPG_V h9

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
362081: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 371822: WHEN 23 THEN 'PSA_CST_XLA_UPG_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:
371826: ELSE null

Line 371960: , PSA_CST_XLA_UPG_V h11

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)
371964: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 372300: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%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:
372304: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 372425: , PSA_CST_XLA_UPG_V h11

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
372429: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 373739: WHEN 24 THEN 'PSA_CST_XLA_UPG_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:
373743: ELSE null

Line 373881: , PSA_CST_XLA_UPG_V h11

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)
373885: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 374222: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%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:
374226: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 374349: , PSA_CST_XLA_UPG_V h11

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
374353: and xet.event_type_code = C_EVENT_TYPE_CODE

Line 380765: WHEN 23 THEN 'PSA_CST_XLA_UPG_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:
380769: ELSE null

Line 380903: , PSA_CST_XLA_UPG_V h11

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)
380907: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 381243: TYPE t_array_source_100 IS TABLE OF PSA_CST_XLA_UPG_V.CST_ENCUM_UPG_OPTION%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:
381247: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 381368: , PSA_CST_XLA_UPG_V h11

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
381372: and xet.event_type_code = C_EVENT_TYPE_CODE