[Home] [Help]
307781: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
307782: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
307783: WHEN 3 THEN 'CST_XLA_INV_REF_V'
307784: WHEN 4 THEN 'CST_XLA_INV_REF_V'
307785: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
307786: WHEN 6 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
307787: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
307788: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
307789: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
307874: , CST_XLA_INV_HEADERS_V h1
307875: , CST_XLA_INV_ORG_PARAMS_REF_V h3
307876: , CST_XLA_INV_REF_V h4
307877: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
307878: , CST_XLA_INV_TXN_TYPES_REF_V h6
307879: , CST_XLA_PLA_CATEGORY_REF_V h7
307880: , fnd_lookup_values fvl39
307881: , fnd_lookup_values fvl85
307882: , fnd_lookup_values fvl114
308190: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
308191: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
308192: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
308193: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
308194: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
308195: TYPE t_array_source_39 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.PRIMARY_COST_METHOD%TYPE INDEX BY BINARY_INTEGER;
308196: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
308197: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
308198: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
308292: , CST_XLA_INV_HEADERS_V h1
308293: , CST_XLA_INV_ORG_PARAMS_REF_V h3
308294: , CST_XLA_INV_REF_V h4
308295: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
308296: , CST_XLA_INV_TXN_TYPES_REF_V h6
308297: , CST_XLA_PLA_CATEGORY_REF_V h7
308298: , fnd_lookup_values fvl39
308299: , fnd_lookup_values fvl85
308300: , fnd_lookup_values fvl114
309293: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
309294: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
309295: WHEN 3 THEN 'CST_XLA_INV_REF_V'
309296: WHEN 4 THEN 'CST_XLA_INV_REF_V'
309297: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
309298: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
309299: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
309300:
309301: ELSE null
309354: FROM xla_events_gt xet
309355: , CST_XLA_INV_HEADERS_V h1
309356: , CST_XLA_INV_REF_V h3
309357: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
309358: , CST_XLA_INV_TXN_TYPES_REF_V h5
309359: , fnd_lookup_values fvl85
309360: , fnd_lookup_values fvl114
309361: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
309362: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
309649: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
309650: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
309651: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
309652: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
309653: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
309654: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
309655: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
309656:
309657: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
309728: FROM xla_events_gt xet
309729: , CST_XLA_INV_HEADERS_V h1
309730: , CST_XLA_INV_REF_V h3
309731: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
309732: , CST_XLA_INV_TXN_TYPES_REF_V h5
309733: , fnd_lookup_values fvl85
309734: , fnd_lookup_values fvl114
309735: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
309736: and xet.event_type_code = C_EVENT_TYPE_CODE
310668: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
310669: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
310670: WHEN 3 THEN 'CST_XLA_INV_REF_V'
310671: WHEN 4 THEN 'CST_XLA_INV_REF_V'
310672: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
310673: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
310674: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
310675:
310676: ELSE null
310729: FROM xla_events_gt xet
310730: , CST_XLA_INV_HEADERS_V h1
310731: , CST_XLA_INV_REF_V h3
310732: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
310733: , CST_XLA_INV_TXN_TYPES_REF_V h5
310734: , fnd_lookup_values fvl85
310735: , fnd_lookup_values fvl114
310736: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
310737: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
311024: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
311025: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
311026: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
311027: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
311028: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
311029: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
311030: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
311031:
311032: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
311103: FROM xla_events_gt xet
311104: , CST_XLA_INV_HEADERS_V h1
311105: , CST_XLA_INV_REF_V h3
311106: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
311107: , CST_XLA_INV_TXN_TYPES_REF_V h5
311108: , fnd_lookup_values fvl85
311109: , fnd_lookup_values fvl114
311110: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
311111: and xet.event_type_code = C_EVENT_TYPE_CODE
312043: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
312044: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
312045: WHEN 3 THEN 'CST_XLA_INV_REF_V'
312046: WHEN 4 THEN 'CST_XLA_INV_REF_V'
312047: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
312048: WHEN 6 THEN 'CST_XLA_INV_REF_V'
312049: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
312050: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
312051: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
312155: , CST_XLA_INV_HEADERS_V h1
312156: , CST_XLA_INV_ORG_PARAMS_REF_V h3
312157: , CST_XLA_INV_REF_V h4
312158: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
312159: , CST_XLA_INV_TXN_TYPES_REF_V h6
312160: , CST_XLA_PLA_CATEGORY_REF_V h7
312161: , fnd_lookup_values fvl85
312162: , fnd_lookup_values fvl114
312163: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
312467: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
312468: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
312469: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
312470: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
312471: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
312472: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_DISTRIBUTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
312473: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.INV_ORG_AVG_COST_VAR_ACCT%TYPE INDEX BY BINARY_INTEGER;
312474: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
312475: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
312578: , CST_XLA_INV_HEADERS_V h1
312579: , CST_XLA_INV_ORG_PARAMS_REF_V h3
312580: , CST_XLA_INV_REF_V h4
312581: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
312582: , CST_XLA_INV_TXN_TYPES_REF_V h6
312583: , CST_XLA_PLA_CATEGORY_REF_V h7
312584: , fnd_lookup_values fvl85
312585: , fnd_lookup_values fvl114
312586: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
314983: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
314984: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
314985: WHEN 3 THEN 'CST_XLA_INV_REF_V'
314986: WHEN 4 THEN 'CST_XLA_INV_REF_V'
314987: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
314988: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
314989: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
314990: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
314991: WHEN 9 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
315140: , CST_XLA_INTERORG_PARAMS_REF_V h1
315141: , CST_XLA_INV_HEADERS_V h2
315142: , CST_XLA_INV_REF_V h4
315143: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
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
315457: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
315458: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
315459: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
315460: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
315461: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
315462: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
315463: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
315464: TYPE t_array_source_34 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
315465: TYPE t_array_source_35 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PAYABLES_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
315595: , CST_XLA_INTERORG_PARAMS_REF_V h1
315596: , CST_XLA_INV_HEADERS_V h2
315597: , CST_XLA_INV_REF_V h4
315598: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
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
316928: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
316929: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
316930: WHEN 3 THEN 'CST_XLA_INV_REF_V'
316931: WHEN 4 THEN 'CST_XLA_INV_REF_V'
316932: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
316933: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
316934: WHEN 7 THEN 'CST_XLA_INV_REF_V'
316935: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
316936: WHEN 9 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
317040: , CST_XLA_INTERORG_PARAMS_REF_V h1
317041: , CST_XLA_INV_HEADERS_V h2
317042: , CST_XLA_INV_REF_V h4
317043: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
317044: , CST_XLA_INV_TXN_TYPES_REF_V h6
317045: , CST_XLA_PLA_CATEGORY_REF_V h7
317046: , fnd_lookup_values fvl85
317047: , fnd_lookup_values fvl114
317048: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
317353: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
317354: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
317355: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
317356: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
317357: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
317358: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
317359: TYPE t_array_source_32 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_TRANSPO_DIST_ACCT%TYPE INDEX BY BINARY_INTEGER;
317360: TYPE t_array_source_33 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_REVENUE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
317361: TYPE t_array_source_40 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_TXFR_CREDIT_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
317464: , CST_XLA_INTERORG_PARAMS_REF_V h1
317465: , CST_XLA_INV_HEADERS_V h2
317466: , CST_XLA_INV_REF_V h4
317467: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
317468: , CST_XLA_INV_TXN_TYPES_REF_V h6
317469: , CST_XLA_PLA_CATEGORY_REF_V h7
317470: , fnd_lookup_values fvl85
317471: , fnd_lookup_values fvl114
317472: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
320177: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
320178: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
320179: WHEN 3 THEN 'CST_XLA_INV_REF_V'
320180: WHEN 4 THEN 'CST_XLA_INV_REF_V'
320181: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
320182: WHEN 6 THEN 'CST_XLA_INV_REF_V'
320183: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
320184: WHEN 8 THEN 'CST_XLA_INV_HEADERS_V'
320185: WHEN 9 THEN 'CST_XLA_INV_HEADERS_V'
320249: , CST_XLA_INTERORG_PARAMS_REF_V h1
320250: , CST_XLA_INV_HEADERS_V h2
320251: , CST_XLA_INV_REF_V h4
320252: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
320253: , CST_XLA_INV_TXN_TYPES_REF_V h6
320254: , fnd_lookup_values fvl85
320255: , fnd_lookup_values fvl114
320256: ,(select rownum r from all_objects where rownum <= 9 and owner = p_apps_owner)
320257: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
320545: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
320546: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
320547: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
320548: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
320549: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
320550: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_DISTRIBUTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
320551: TYPE t_array_source_35 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PAYABLES_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
320552: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
320553: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
320631: , CST_XLA_INTERORG_PARAMS_REF_V h1
320632: , CST_XLA_INV_HEADERS_V h2
320633: , CST_XLA_INV_REF_V h4
320634: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
320635: , CST_XLA_INV_TXN_TYPES_REF_V h6
320636: , fnd_lookup_values fvl85
320637: , fnd_lookup_values fvl114
320638: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
320639: and xet.event_type_code = C_EVENT_TYPE_CODE
321601: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
321602: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
321603: WHEN 3 THEN 'CST_XLA_INV_REF_V'
321604: WHEN 4 THEN 'CST_XLA_INV_REF_V'
321605: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
321606: WHEN 6 THEN 'CST_XLA_INV_REF_V'
321607: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
321608: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
321609: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
321698: , CST_XLA_INTERORG_PARAMS_REF_V h1
321699: , CST_XLA_INV_HEADERS_V h2
321700: , CST_XLA_INV_REF_V h4
321701: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
321702: , CST_XLA_INV_TXN_TYPES_REF_V h6
321703: , CST_XLA_PLA_CATEGORY_REF_V h7
321704: , fnd_lookup_values fvl85
321705: , fnd_lookup_values fvl114
321706: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
322010: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
322011: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
322012: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
322013: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
322014: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
322015: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_DISTRIBUTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
322016: TYPE t_array_source_35 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PAYABLES_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
322017: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
322018: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
322113: , CST_XLA_INTERORG_PARAMS_REF_V h1
322114: , CST_XLA_INV_HEADERS_V h2
322115: , CST_XLA_INV_REF_V h4
322116: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
322117: , CST_XLA_INV_TXN_TYPES_REF_V h6
322118: , CST_XLA_PLA_CATEGORY_REF_V h7
322119: , fnd_lookup_values fvl85
322120: , fnd_lookup_values fvl114
322121: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
323102: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
323103: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
323104: WHEN 3 THEN 'CST_XLA_INV_REF_V'
323105: WHEN 4 THEN 'CST_XLA_INV_REF_V'
323106: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
323107: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
323108: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
323109: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
323110: WHEN 9 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
323259: , CST_XLA_INTERORG_PARAMS_REF_V h1
323260: , CST_XLA_INV_HEADERS_V h2
323261: , CST_XLA_INV_REF_V h4
323262: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
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
323575: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
323576: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
323577: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
323578: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
323579: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
323580: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
323581: TYPE t_array_source_34 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
323582: TYPE t_array_source_35 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PAYABLES_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
323583: TYPE t_array_source_36 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PRICE_VAR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
323714: , CST_XLA_INTERORG_PARAMS_REF_V h1
323715: , CST_XLA_INV_HEADERS_V h2
323716: , CST_XLA_INV_REF_V h4
323717: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
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
325003: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
325004: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
325005: WHEN 3 THEN 'CST_XLA_INV_REF_V'
325006: WHEN 4 THEN 'CST_XLA_INV_REF_V'
325007: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
325008: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
325009: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
325010: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
325011: WHEN 9 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
325165: , CST_XLA_INTERORG_PARAMS_REF_V h1
325166: , CST_XLA_INV_HEADERS_V h2
325167: , CST_XLA_INV_REF_V h4
325168: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
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
325481: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
325482: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
325483: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
325484: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
325485: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
325486: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
325487: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
325488: TYPE t_array_source_36 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PRICE_VAR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
325489: TYPE t_array_source_37 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.PROFIT_IN_INV_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
325623: , CST_XLA_INTERORG_PARAMS_REF_V h1
325624: , CST_XLA_INV_HEADERS_V h2
325625: , CST_XLA_INV_REF_V h4
325626: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
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
326914: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
326915: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
326916: WHEN 3 THEN 'CST_XLA_INV_REF_V'
326917: WHEN 4 THEN 'CST_XLA_INV_REF_V'
326918: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
326919: WHEN 6 THEN 'CST_XLA_INV_REF_V'
326920: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
326921: WHEN 8 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
326922: WHEN 9 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
327033: , CST_XLA_INV_HEADERS_V h2
327034: , CST_XLA_INV_ORG_PARAMS_REF_V h4
327035: , CST_XLA_INV_REF_V h5
327036: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
327037: , CST_XLA_INV_TXN_TYPES_REF_V h7
327038: , CST_XLA_PLA_CATEGORY_REF_V h8
327039: , fnd_lookup_values fvl39
327040: , fnd_lookup_values fvl85
327041: , fnd_lookup_values fvl114
327345: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
327346: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
327347: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
327348: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
327349: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
327350: TYPE t_array_source_32 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_TRANSPO_DIST_ACCT%TYPE INDEX BY BINARY_INTEGER;
327351: TYPE t_array_source_33 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_REVENUE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
327352: TYPE t_array_source_39 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.PRIMARY_COST_METHOD%TYPE INDEX BY BINARY_INTEGER;
327353: TYPE t_array_source_40 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_TXFR_CREDIT_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
327461: , CST_XLA_INV_HEADERS_V h2
327462: , CST_XLA_INV_ORG_PARAMS_REF_V h4
327463: , CST_XLA_INV_REF_V h5
327464: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
327465: , CST_XLA_INV_TXN_TYPES_REF_V h7
327466: , CST_XLA_PLA_CATEGORY_REF_V h8
327467: , fnd_lookup_values fvl39
327468: , fnd_lookup_values fvl85
327469: , fnd_lookup_values fvl114
328601: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
328602: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
328603: WHEN 3 THEN 'CST_XLA_INV_REF_V'
328604: WHEN 4 THEN 'CST_XLA_INV_REF_V'
328605: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
328606: WHEN 6 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
328607: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
328608: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
328609: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
328710: , CST_XLA_INV_HEADERS_V h2
328711: , CST_XLA_INV_ORG_PARAMS_REF_V h4
328712: , CST_XLA_INV_REF_V h5
328713: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
328714: , CST_XLA_INV_TXN_TYPES_REF_V h7
328715: , CST_XLA_PLA_CATEGORY_REF_V h8
328716: , fnd_lookup_values fvl39
328717: , fnd_lookup_values fvl85
328718: , fnd_lookup_values fvl114
329022: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
329023: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
329024: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
329025: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
329026: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
329027: TYPE t_array_source_33 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_REVENUE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
329028: TYPE t_array_source_39 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.PRIMARY_COST_METHOD%TYPE INDEX BY BINARY_INTEGER;
329029: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
329030: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
329132: , CST_XLA_INV_HEADERS_V h2
329133: , CST_XLA_INV_ORG_PARAMS_REF_V h4
329134: , CST_XLA_INV_REF_V h5
329135: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
329136: , CST_XLA_INV_TXN_TYPES_REF_V h7
329137: , CST_XLA_PLA_CATEGORY_REF_V h8
329138: , fnd_lookup_values fvl39
329139: , fnd_lookup_values fvl85
329140: , fnd_lookup_values fvl114
330166: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
330167: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
330168: WHEN 3 THEN 'CST_XLA_INV_REF_V'
330169: WHEN 4 THEN 'CST_XLA_INV_REF_V'
330170: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
330171: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
330172: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
330173: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
330174: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
330270: , CST_XLA_INV_HEADERS_V h2
330271: , CST_XLA_INV_ORG_PARAMS_REF_V h4
330272: , CST_XLA_INV_REF_V h5
330273: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
330274: , CST_XLA_INV_TXN_TYPES_REF_V h7
330275: , CST_XLA_PLA_CATEGORY_REF_V h8
330276: , fnd_lookup_values fvl39
330277: , fnd_lookup_values fvl85
330278: , fnd_lookup_values fvl114
330587: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
330588: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
330589: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
330590: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
330591: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
330592: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
330593: TYPE t_array_source_39 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.PRIMARY_COST_METHOD%TYPE INDEX BY BINARY_INTEGER;
330594: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
330595: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
330696: , CST_XLA_INV_HEADERS_V h2
330697: , CST_XLA_INV_ORG_PARAMS_REF_V h4
330698: , CST_XLA_INV_REF_V h5
330699: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
330700: , CST_XLA_INV_TXN_TYPES_REF_V h7
330701: , CST_XLA_PLA_CATEGORY_REF_V h8
330702: , fnd_lookup_values fvl39
330703: , fnd_lookup_values fvl85
330704: , fnd_lookup_values fvl114
331702: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
331703: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
331704: WHEN 3 THEN 'CST_XLA_INV_REF_V'
331705: WHEN 4 THEN 'CST_XLA_INV_REF_V'
331706: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
331707: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
331708: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
331709: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
331710: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
331856: , CST_XLA_INV_HEADERS_V h2
331857: , CST_XLA_INV_ORG_PARAMS_REF_V h4
331858: , CST_XLA_INV_REF_V h5
331859: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
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
332177: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
332178: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
332179: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
332180: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
332181: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
332182: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
332183: TYPE t_array_source_39 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.PRIMARY_COST_METHOD%TYPE INDEX BY BINARY_INTEGER;
332184: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
332185: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
332316: , CST_XLA_INV_HEADERS_V h2
332317: , CST_XLA_INV_ORG_PARAMS_REF_V h4
332318: , CST_XLA_INV_REF_V h5
332319: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
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
333398: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
333399: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
333400: WHEN 3 THEN 'CST_XLA_INV_REF_V'
333401: WHEN 4 THEN 'CST_XLA_INV_REF_V'
333402: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
333403: WHEN 6 THEN 'CST_XLA_INV_REF_V'
333404: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
333405: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
333406: WHEN 9 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
333517: , CST_XLA_INV_HEADERS_V h2
333518: , CST_XLA_INV_ORG_PARAMS_REF_V h4
333519: , CST_XLA_INV_REF_V h5
333520: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
333521: , CST_XLA_INV_TXN_TYPES_REF_V h7
333522: , CST_XLA_PLA_CATEGORY_REF_V h8
333523: , fnd_lookup_values fvl39
333524: , fnd_lookup_values fvl85
333525: , fnd_lookup_values fvl114
333829: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
333830: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
333831: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
333832: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
333833: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
333834: TYPE t_array_source_32 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_TRANSPO_DIST_ACCT%TYPE INDEX BY BINARY_INTEGER;
333835: TYPE t_array_source_34 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
333836: TYPE t_array_source_35 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PAYABLES_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
333837: TYPE t_array_source_36 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PRICE_VAR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
333945: , CST_XLA_INV_HEADERS_V h2
333946: , CST_XLA_INV_ORG_PARAMS_REF_V h4
333947: , CST_XLA_INV_REF_V h5
333948: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
333949: , CST_XLA_INV_TXN_TYPES_REF_V h7
333950: , CST_XLA_PLA_CATEGORY_REF_V h8
333951: , fnd_lookup_values fvl39
333952: , fnd_lookup_values fvl85
333953: , fnd_lookup_values fvl114
335153: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
335154: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
335155: WHEN 3 THEN 'CST_XLA_INV_REF_V'
335156: WHEN 4 THEN 'CST_XLA_INV_REF_V'
335157: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
335158: WHEN 6 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
335159: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
335160: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
335161: WHEN 9 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
335272: , CST_XLA_INV_HEADERS_V h2
335273: , CST_XLA_INV_ORG_PARAMS_REF_V h4
335274: , CST_XLA_INV_REF_V h5
335275: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
335276: , CST_XLA_INV_TXN_TYPES_REF_V h7
335277: , CST_XLA_PLA_CATEGORY_REF_V h8
335278: , fnd_lookup_values fvl39
335279: , fnd_lookup_values fvl85
335280: , fnd_lookup_values fvl114
335584: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
335585: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
335586: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
335587: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
335588: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
335589: TYPE t_array_source_34 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
335590: TYPE t_array_source_36 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PRICE_VAR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
335591: TYPE t_array_source_37 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.PROFIT_IN_INV_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
335592: TYPE t_array_source_39 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.PRIMARY_COST_METHOD%TYPE INDEX BY BINARY_INTEGER;
335700: , CST_XLA_INV_HEADERS_V h2
335701: , CST_XLA_INV_ORG_PARAMS_REF_V h4
335702: , CST_XLA_INV_REF_V h5
335703: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
335704: , CST_XLA_INV_TXN_TYPES_REF_V h7
335705: , CST_XLA_PLA_CATEGORY_REF_V h8
335706: , fnd_lookup_values fvl39
335707: , fnd_lookup_values fvl85
335708: , fnd_lookup_values fvl114
338422: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
338423: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
338424: WHEN 3 THEN 'CST_XLA_INV_REF_V'
338425: WHEN 4 THEN 'CST_XLA_INV_REF_V'
338426: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
338427: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
338428: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
338429: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
338430: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
338524: , CST_XLA_INTERORG_PARAMS_REF_V h1
338525: , CST_XLA_INV_HEADERS_V h2
338526: , CST_XLA_INV_REF_V h4
338527: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
338528: , CST_XLA_INV_TXN_TYPES_REF_V h6
338529: , CST_XLA_PLA_CATEGORY_REF_V h7
338530: , fnd_lookup_values fvl85
338531: , fnd_lookup_values fvl114
338532: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
338831: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
338832: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
338833: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
338834: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
338835: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
338836: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
338837: TYPE t_array_source_33 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_REVENUE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
338838: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
338839: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
338935: , CST_XLA_INTERORG_PARAMS_REF_V h1
338936: , CST_XLA_INV_HEADERS_V h2
338937: , CST_XLA_INV_REF_V h4
338938: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
338939: , CST_XLA_INV_TXN_TYPES_REF_V h6
338940: , CST_XLA_PLA_CATEGORY_REF_V h7
338941: , fnd_lookup_values fvl85
338942: , fnd_lookup_values fvl114
338943: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
339877: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
339878: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
339879: WHEN 3 THEN 'CST_XLA_INV_REF_V'
339880: WHEN 4 THEN 'CST_XLA_INV_REF_V'
339881: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
339882: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339883: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
339884: WHEN 8 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
339885: WHEN 9 THEN 'CST_XLA_INV_HEADERS_V'
340028: FROM xla_events_gt xet
340029: , CST_XLA_INV_HEADERS_V h1
340030: , CST_XLA_INV_REF_V h3
340031: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
340032: , CST_XLA_INV_TXN_TYPES_REF_V h5
340033: , CST_XLA_PLA_CATEGORY_REF_V h6
340034: , CST_XLA_TRF_PLA_CAT_REF_V h7
340035: , fnd_lookup_values fvl85
340036: , fnd_lookup_values fvl114
340354: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
340355: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
340356: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
340357: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
340358: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
340359: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340360: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
340361: TYPE t_array_source_25 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
340362: TYPE t_array_source_27 IS TABLE OF CST_XLA_INV_HEADERS_V.H_TRANSFER_COST_GROUP_ID%TYPE INDEX BY BINARY_INTEGER;
340490: FROM xla_events_gt xet
340491: , CST_XLA_INV_HEADERS_V h1
340492: , CST_XLA_INV_REF_V h3
340493: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
340494: , CST_XLA_INV_TXN_TYPES_REF_V h5
340495: , CST_XLA_PLA_CATEGORY_REF_V h6
340496: , CST_XLA_TRF_PLA_CAT_REF_V h7
340497: , fnd_lookup_values fvl85
340498: , fnd_lookup_values fvl114
341499: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
341500: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
341501: WHEN 3 THEN 'CST_XLA_INV_REF_V'
341502: WHEN 4 THEN 'CST_XLA_INV_REF_V'
341503: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
341504: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
341505: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
341506: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
341507: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
341623: , CST_XLA_INTERORG_PARAMS_REF_V h1
341624: , CST_XLA_INV_HEADERS_V h2
341625: , CST_XLA_INV_REF_V h4
341626: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
341627: , CST_XLA_INV_TXN_TYPES_REF_V h6
341628: , CST_XLA_PLA_CATEGORY_REF_V h7
341629: , fnd_lookup_values fvl85
341630: , fnd_lookup_values fvl114
341631: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
341935: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
341936: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
341937: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
341938: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
341939: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
341940: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
341941: TYPE t_array_source_33 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_REVENUE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
341942: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
341943: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
342047: , CST_XLA_INTERORG_PARAMS_REF_V h1
342048: , CST_XLA_INV_HEADERS_V h2
342049: , CST_XLA_INV_REF_V h4
342050: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
342051: , CST_XLA_INV_TXN_TYPES_REF_V h6
342052: , CST_XLA_PLA_CATEGORY_REF_V h7
342053: , fnd_lookup_values fvl85
342054: , fnd_lookup_values fvl114
342055: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
343114: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
343115: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
343116: WHEN 3 THEN 'CST_XLA_INV_REF_V'
343117: WHEN 4 THEN 'CST_XLA_INV_REF_V'
343118: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
343119: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
343120: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
343121: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
343122: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
343238: , CST_XLA_INTERORG_PARAMS_REF_V h1
343239: , CST_XLA_INV_HEADERS_V h2
343240: , CST_XLA_INV_REF_V h4
343241: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
343242: , CST_XLA_INV_TXN_TYPES_REF_V h6
343243: , CST_XLA_PLA_CATEGORY_REF_V h7
343244: , fnd_lookup_values fvl85
343245: , fnd_lookup_values fvl114
343246: ,(select rownum r from all_objects where rownum <= 17 and owner = p_apps_owner)
343550: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
343551: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
343552: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
343553: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
343554: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
343555: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
343556: TYPE t_array_source_33 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_REVENUE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
343557: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
343558: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
343662: , CST_XLA_INTERORG_PARAMS_REF_V h1
343663: , CST_XLA_INV_HEADERS_V h2
343664: , CST_XLA_INV_REF_V h4
343665: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
343666: , CST_XLA_INV_TXN_TYPES_REF_V h6
343667: , CST_XLA_PLA_CATEGORY_REF_V h7
343668: , fnd_lookup_values fvl85
343669: , fnd_lookup_values fvl114
343670: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
346243: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
346244: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
346245: WHEN 3 THEN 'CST_XLA_INV_REF_V'
346246: WHEN 4 THEN 'CST_XLA_INV_REF_V'
346247: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
346248: WHEN 6 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
346249: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
346250: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
346251: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
346336: , CST_XLA_INV_HEADERS_V h1
346337: , CST_XLA_INV_ORG_PARAMS_REF_V h3
346338: , CST_XLA_INV_REF_V h4
346339: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
346340: , CST_XLA_INV_TXN_TYPES_REF_V h6
346341: , CST_XLA_PLA_CATEGORY_REF_V h7
346342: , fnd_lookup_values fvl39
346343: , fnd_lookup_values fvl85
346344: , fnd_lookup_values fvl114
346652: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
346653: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
346654: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
346655: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
346656: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
346657: TYPE t_array_source_39 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.PRIMARY_COST_METHOD%TYPE INDEX BY BINARY_INTEGER;
346658: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
346659: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
346660: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
346754: , CST_XLA_INV_HEADERS_V h1
346755: , CST_XLA_INV_ORG_PARAMS_REF_V h3
346756: , CST_XLA_INV_REF_V h4
346757: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
346758: , CST_XLA_INV_TXN_TYPES_REF_V h6
346759: , CST_XLA_PLA_CATEGORY_REF_V h7
346760: , fnd_lookup_values fvl39
346761: , fnd_lookup_values fvl85
346762: , fnd_lookup_values fvl114
347721: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
347722: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
347723: WHEN 3 THEN 'CST_XLA_INV_REF_V'
347724: WHEN 4 THEN 'CST_XLA_INV_REF_V'
347725: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
347726: WHEN 6 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
347727: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
347728: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
347729: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
347814: , CST_XLA_INV_HEADERS_V h1
347815: , CST_XLA_INV_ORG_PARAMS_REF_V h3
347816: , CST_XLA_INV_REF_V h4
347817: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
347818: , CST_XLA_INV_TXN_TYPES_REF_V h6
347819: , CST_XLA_PLA_CATEGORY_REF_V h7
347820: , fnd_lookup_values fvl39
347821: , fnd_lookup_values fvl85
347822: , fnd_lookup_values fvl114
348130: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
348131: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
348132: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
348133: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
348134: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
348135: TYPE t_array_source_39 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.PRIMARY_COST_METHOD%TYPE INDEX BY BINARY_INTEGER;
348136: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
348137: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
348138: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
348232: , CST_XLA_INV_HEADERS_V h1
348233: , CST_XLA_INV_ORG_PARAMS_REF_V h3
348234: , CST_XLA_INV_REF_V h4
348235: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
348236: , CST_XLA_INV_TXN_TYPES_REF_V h6
348237: , CST_XLA_PLA_CATEGORY_REF_V h7
348238: , fnd_lookup_values fvl39
348239: , fnd_lookup_values fvl85
348240: , fnd_lookup_values fvl114
351707: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
351708: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
351709: WHEN 3 THEN 'CST_XLA_INV_REF_V'
351710: WHEN 4 THEN 'CST_XLA_INV_REF_V'
351711: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
351712: WHEN 6 THEN 'CST_XLA_INV_REF_V'
351713: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
351714: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
351715: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
351814: FROM xla_events_gt xet
351815: , CST_XLA_INV_HEADERS_V h1
351816: , CST_XLA_INV_REF_V h3
351817: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
351818: , CST_XLA_INV_TXN_TYPES_REF_V h5
351819: , CST_XLA_PLA_CATEGORY_REF_V h6
351820: , fnd_lookup_values fvl62
351821: , fnd_lookup_values fvl85
351822: , fnd_lookup_values fvl114
352130: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
352131: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
352132: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
352133: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
352134: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
352135: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_DISTRIBUTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
352136: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
352137: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
352138: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
352240: FROM xla_events_gt xet
352241: , CST_XLA_INV_HEADERS_V h1
352242: , CST_XLA_INV_REF_V h3
352243: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
352244: , CST_XLA_INV_TXN_TYPES_REF_V h5
352245: , CST_XLA_PLA_CATEGORY_REF_V h6
352246: , fnd_lookup_values fvl62
352247: , fnd_lookup_values fvl85
352248: , fnd_lookup_values fvl114
353311: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
353312: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
353313: WHEN 3 THEN 'CST_XLA_INV_REF_V'
353314: WHEN 4 THEN 'CST_XLA_INV_REF_V'
353315: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
353316: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
353317: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
353318: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
353319: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
353403: FROM xla_events_gt xet
353404: , CST_XLA_INV_HEADERS_V h1
353405: , CST_XLA_INV_REF_V h3
353406: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
353407: , CST_XLA_INV_TXN_TYPES_REF_V h5
353408: , CST_XLA_PLA_CATEGORY_REF_V h6
353409: , fnd_lookup_values fvl62
353410: , fnd_lookup_values fvl85
353411: , fnd_lookup_values fvl114
353719: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
353720: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
353721: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
353722: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
353723: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
353724: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
353725: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
353726: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
353727: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
353820: FROM xla_events_gt xet
353821: , CST_XLA_INV_HEADERS_V h1
353822: , CST_XLA_INV_REF_V h3
353823: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
353824: , CST_XLA_INV_TXN_TYPES_REF_V h5
353825: , CST_XLA_PLA_CATEGORY_REF_V h6
353826: , fnd_lookup_values fvl62
353827: , fnd_lookup_values fvl85
353828: , fnd_lookup_values fvl114
354713: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
354714: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
354715: WHEN 3 THEN 'CST_XLA_INV_REF_V'
354716: WHEN 4 THEN 'CST_XLA_INV_REF_V'
354717: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
354718: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
354719: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
354720: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
354721: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
354805: FROM xla_events_gt xet
354806: , CST_XLA_INV_HEADERS_V h1
354807: , CST_XLA_INV_REF_V h3
354808: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
354809: , CST_XLA_INV_TXN_TYPES_REF_V h5
354810: , CST_XLA_PLA_CATEGORY_REF_V h6
354811: , fnd_lookup_values fvl62
354812: , fnd_lookup_values fvl85
354813: , fnd_lookup_values fvl114
355121: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
355122: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
355123: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
355124: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
355125: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
355126: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
355127: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
355128: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
355129: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
355222: FROM xla_events_gt xet
355223: , CST_XLA_INV_HEADERS_V h1
355224: , CST_XLA_INV_REF_V h3
355225: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
355226: , CST_XLA_INV_TXN_TYPES_REF_V h5
355227: , CST_XLA_PLA_CATEGORY_REF_V h6
355228: , fnd_lookup_values fvl62
355229: , fnd_lookup_values fvl85
355230: , fnd_lookup_values fvl114
356115: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
356116: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
356117: WHEN 3 THEN 'CST_XLA_INV_REF_V'
356118: WHEN 4 THEN 'CST_XLA_INV_REF_V'
356119: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
356120: WHEN 6 THEN 'CST_XLA_INV_REF_V'
356121: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
356122: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
356123: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
356222: FROM xla_events_gt xet
356223: , CST_XLA_INV_HEADERS_V h1
356224: , CST_XLA_INV_REF_V h3
356225: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
356226: , CST_XLA_INV_TXN_TYPES_REF_V h5
356227: , CST_XLA_PLA_CATEGORY_REF_V h6
356228: , fnd_lookup_values fvl62
356229: , fnd_lookup_values fvl85
356230: , fnd_lookup_values fvl114
356538: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
356539: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
356540: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
356541: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
356542: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
356543: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_DISTRIBUTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
356544: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
356545: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
356546: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
356648: FROM xla_events_gt xet
356649: , CST_XLA_INV_HEADERS_V h1
356650: , CST_XLA_INV_REF_V h3
356651: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
356652: , CST_XLA_INV_TXN_TYPES_REF_V h5
356653: , CST_XLA_PLA_CATEGORY_REF_V h6
356654: , fnd_lookup_values fvl62
356655: , fnd_lookup_values fvl85
356656: , fnd_lookup_values fvl114
357719: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
357720: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
357721: WHEN 3 THEN 'CST_XLA_INV_REF_V'
357722: WHEN 4 THEN 'CST_XLA_INV_REF_V'
357723: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
357724: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
357725: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
357726: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
357727: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
357865: FROM xla_events_gt xet
357866: , CST_XLA_INV_HEADERS_V h1
357867: , CST_XLA_INV_REF_V h3
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
358179: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
358180: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
358181: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
358182: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
358183: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
358184: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
358185: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
358186: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
358187: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
358311: FROM xla_events_gt xet
358312: , CST_XLA_INV_HEADERS_V h1
358313: , CST_XLA_INV_REF_V h3
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
359594: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
359595: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
359596: WHEN 3 THEN 'CST_XLA_INV_REF_V'
359597: WHEN 4 THEN 'CST_XLA_INV_REF_V'
359598: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
359599: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
359600: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
359601: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
359602: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
359740: FROM xla_events_gt xet
359741: , CST_XLA_INV_HEADERS_V h1
359742: , CST_XLA_INV_REF_V h3
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
360054: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
360055: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
360056: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
360057: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
360058: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
360059: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
360060: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
360061: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
360062: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
360186: FROM xla_events_gt xet
360187: , CST_XLA_INV_HEADERS_V h1
360188: , CST_XLA_INV_REF_V h3
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
361469: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
361470: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
361471: WHEN 3 THEN 'CST_XLA_INV_REF_V'
361472: WHEN 4 THEN 'CST_XLA_INV_REF_V'
361473: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
361474: WHEN 6 THEN 'CST_XLA_INV_REF_V'
361475: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
361476: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
361477: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
361620: FROM xla_events_gt xet
361621: , CST_XLA_INV_HEADERS_V h1
361622: , CST_XLA_INV_REF_V h3
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
361934: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
361935: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
361936: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
361937: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
361938: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
361939: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_DISTRIBUTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
361940: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
361941: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
361942: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
362069: FROM xla_events_gt xet
362070: , CST_XLA_INV_HEADERS_V h1
362071: , CST_XLA_INV_REF_V h3
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
363354: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
363355: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
363356: WHEN 3 THEN 'CST_XLA_INV_REF_V'
363357: WHEN 4 THEN 'CST_XLA_INV_REF_V'
363358: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
363359: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
363360: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
363361: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
363362: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
363440: FROM xla_events_gt xet
363441: , CST_XLA_INV_HEADERS_V h1
363442: , CST_XLA_INV_REF_V h3
363443: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
363444: , CST_XLA_INV_TXN_TYPES_REF_V h5
363445: , CST_XLA_PLA_CATEGORY_REF_V h6
363446: , fnd_lookup_values fvl85
363447: , fnd_lookup_values fvl114
363448: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
363751: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
363752: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
363753: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
363754: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
363755: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
363756: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
363757: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
363758: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
363759: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
363847: FROM xla_events_gt xet
363848: , CST_XLA_INV_HEADERS_V h1
363849: , CST_XLA_INV_REF_V h3
363850: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
363851: , CST_XLA_INV_TXN_TYPES_REF_V h5
363852: , CST_XLA_PLA_CATEGORY_REF_V h6
363853: , fnd_lookup_values fvl85
363854: , fnd_lookup_values fvl114
363855: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
364797: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
364798: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
364799: WHEN 3 THEN 'CST_XLA_INV_REF_V'
364800: WHEN 4 THEN 'CST_XLA_INV_REF_V'
364801: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
364802: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
364803: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
364804: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
364805: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
364883: FROM xla_events_gt xet
364884: , CST_XLA_INV_HEADERS_V h1
364885: , CST_XLA_INV_REF_V h3
364886: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
364887: , CST_XLA_INV_TXN_TYPES_REF_V h5
364888: , CST_XLA_PLA_CATEGORY_REF_V h6
364889: , fnd_lookup_values fvl85
364890: , fnd_lookup_values fvl114
364891: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
365194: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
365195: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
365196: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
365197: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
365198: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
365199: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
365200: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
365201: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
365202: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
365290: FROM xla_events_gt xet
365291: , CST_XLA_INV_HEADERS_V h1
365292: , CST_XLA_INV_REF_V h3
365293: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
365294: , CST_XLA_INV_TXN_TYPES_REF_V h5
365295: , CST_XLA_PLA_CATEGORY_REF_V h6
365296: , fnd_lookup_values fvl85
365297: , fnd_lookup_values fvl114
365298: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
366172: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
366173: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
366174: WHEN 3 THEN 'CST_XLA_INV_REF_V'
366175: WHEN 4 THEN 'CST_XLA_INV_REF_V'
366176: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
366177: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
366178: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
366179:
366180: ELSE null
366233: FROM xla_events_gt xet
366234: , CST_XLA_INV_HEADERS_V h1
366235: , CST_XLA_INV_REF_V h3
366236: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
366237: , CST_XLA_INV_TXN_TYPES_REF_V h5
366238: , fnd_lookup_values fvl85
366239: , fnd_lookup_values fvl114
366240: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
366241: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
366524: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
366525: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
366526: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
366527: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
366528: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
366529: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
366530: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
366531:
366532: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
366600: FROM xla_events_gt xet
366601: , CST_XLA_INV_HEADERS_V h1
366602: , CST_XLA_INV_REF_V h3
366603: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
366604: , CST_XLA_INV_TXN_TYPES_REF_V h5
366605: , fnd_lookup_values fvl85
366606: , fnd_lookup_values fvl114
366607: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
366608: and xet.event_class_code = C_EVENT_CLASS_CODE
367450: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
367451: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
367452: WHEN 3 THEN 'CST_XLA_INV_REF_V'
367453: WHEN 4 THEN 'CST_XLA_INV_REF_V'
367454: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
367455: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
367456: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
367457: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
367458: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
367536: FROM xla_events_gt xet
367537: , CST_XLA_INV_HEADERS_V h1
367538: , CST_XLA_INV_REF_V h3
367539: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
367540: , CST_XLA_INV_TXN_TYPES_REF_V h5
367541: , CST_XLA_PLA_CATEGORY_REF_V h6
367542: , fnd_lookup_values fvl85
367543: , fnd_lookup_values fvl114
367544: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
367848: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
367849: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
367850: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
367851: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
367852: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
367853: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
367854: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
367855: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
367856: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
367943: FROM xla_events_gt xet
367944: , CST_XLA_INV_HEADERS_V h1
367945: , CST_XLA_INV_REF_V h3
367946: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
367947: , CST_XLA_INV_TXN_TYPES_REF_V h5
367948: , CST_XLA_PLA_CATEGORY_REF_V h6
367949: , fnd_lookup_values fvl85
367950: , fnd_lookup_values fvl114
367951: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
371800: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
371801: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
371802: WHEN 3 THEN 'CST_XLA_INV_REF_V'
371803: WHEN 4 THEN 'CST_XLA_INV_REF_V'
371804: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
371805: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
371806: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
371807: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
371808: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
371952: , CST_XLA_INV_HEADERS_V h1
371953: , CST_XLA_INV_ORG_PARAMS_REF_V h3
371954: , CST_XLA_INV_REF_V h4
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
372278: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
372279: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
372280: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
372281: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
372282: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
372283: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
372284: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
372285: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
372286: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
372417: , CST_XLA_INV_HEADERS_V h1
372418: , CST_XLA_INV_ORG_PARAMS_REF_V h3
372419: , CST_XLA_INV_REF_V h4
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
373716: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
373717: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
373718: WHEN 3 THEN 'CST_XLA_INV_REF_V'
373719: WHEN 4 THEN 'CST_XLA_INV_REF_V'
373720: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
373721: WHEN 6 THEN 'CST_XLA_INV_REF_V'
373722: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
373723: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
373724: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
373873: , CST_XLA_INV_HEADERS_V h1
373874: , CST_XLA_INV_ORG_PARAMS_REF_V h3
373875: , CST_XLA_INV_REF_V h4
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
374199: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
374200: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
374201: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
374202: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
374203: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
374204: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_DISTRIBUTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
374205: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
374206: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
374207: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
374341: , CST_XLA_INV_HEADERS_V h1
374342: , CST_XLA_INV_ORG_PARAMS_REF_V h3
374343: , CST_XLA_INV_REF_V h4
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
376969: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
376970: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
376971: WHEN 3 THEN 'CST_XLA_INV_REF_V'
376972: WHEN 4 THEN 'CST_XLA_INV_REF_V'
376973: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
376974: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
376975: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
376976:
376977: ELSE null
377030: FROM xla_events_gt xet
377031: , CST_XLA_INV_HEADERS_V h1
377032: , CST_XLA_INV_REF_V h3
377033: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
377034: , CST_XLA_INV_TXN_TYPES_REF_V h5
377035: , fnd_lookup_values fvl85
377036: , fnd_lookup_values fvl114
377037: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
377038: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
377321: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
377322: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
377323: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
377324: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
377325: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
377326: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
377327: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
377328:
377329: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
377397: FROM xla_events_gt xet
377398: , CST_XLA_INV_HEADERS_V h1
377399: , CST_XLA_INV_REF_V h3
377400: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
377401: , CST_XLA_INV_TXN_TYPES_REF_V h5
377402: , fnd_lookup_values fvl85
377403: , fnd_lookup_values fvl114
377404: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
377405: and xet.event_class_code = C_EVENT_CLASS_CODE
380743: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
380744: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
380745: WHEN 3 THEN 'CST_XLA_INV_REF_V'
380746: WHEN 4 THEN 'CST_XLA_INV_REF_V'
380747: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
380748: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
380749: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
380750: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
380751: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
380895: , CST_XLA_INV_HEADERS_V h1
380896: , CST_XLA_INV_ORG_PARAMS_REF_V h3
380897: , CST_XLA_INV_REF_V h4
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
381221: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
381222: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
381223: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
381224: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
381225: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
381226: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
381227: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
381228: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
381229: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
381360: , CST_XLA_INV_HEADERS_V h1
381361: , CST_XLA_INV_ORG_PARAMS_REF_V h3
381362: , CST_XLA_INV_REF_V h4
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
382659: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
382660: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
382661: WHEN 3 THEN 'CST_XLA_INV_REF_V'
382662: WHEN 4 THEN 'CST_XLA_INV_REF_V'
382663: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
382664: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
382665: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
382666: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
382667: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
382745: FROM xla_events_gt xet
382746: , CST_XLA_INV_HEADERS_V h1
382747: , CST_XLA_INV_REF_V h3
382748: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
382749: , CST_XLA_INV_TXN_TYPES_REF_V h5
382750: , CST_XLA_PLA_CATEGORY_REF_V h6
382751: , fnd_lookup_values fvl85
382752: , fnd_lookup_values fvl114
382753: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
383056: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
383057: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
383058: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
383059: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
383060: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
383061: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
383062: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
383063: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
383064: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
383152: FROM xla_events_gt xet
383153: , CST_XLA_INV_HEADERS_V h1
383154: , CST_XLA_INV_REF_V h3
383155: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
383156: , CST_XLA_INV_TXN_TYPES_REF_V h5
383157: , CST_XLA_PLA_CATEGORY_REF_V h6
383158: , fnd_lookup_values fvl85
383159: , fnd_lookup_values fvl114
383160: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
384136: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
384137: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
384138: WHEN 3 THEN 'CST_XLA_INV_REF_V'
384139: WHEN 4 THEN 'CST_XLA_INV_REF_V'
384140: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
384141: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
384142: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
384143: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
384144: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
384222: FROM xla_events_gt xet
384223: , CST_XLA_INV_HEADERS_V h1
384224: , CST_XLA_INV_REF_V h3
384225: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
384226: , CST_XLA_INV_TXN_TYPES_REF_V h5
384227: , CST_XLA_PLA_CATEGORY_REF_V h6
384228: , fnd_lookup_values fvl85
384229: , fnd_lookup_values fvl114
384230: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
384533: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
384534: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
384535: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
384536: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
384537: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
384538: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
384539: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
384540: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
384541: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
384629: FROM xla_events_gt xet
384630: , CST_XLA_INV_HEADERS_V h1
384631: , CST_XLA_INV_REF_V h3
384632: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
384633: , CST_XLA_INV_TXN_TYPES_REF_V h5
384634: , CST_XLA_PLA_CATEGORY_REF_V h6
384635: , fnd_lookup_values fvl85
384636: , fnd_lookup_values fvl114
384637: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
385600: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
385601: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
385602: WHEN 3 THEN 'CST_XLA_INV_REF_V'
385603: WHEN 4 THEN 'CST_XLA_INV_REF_V'
385604: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
385605: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
385606: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
385607: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
385608: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
385686: FROM xla_events_gt xet
385687: , CST_XLA_INV_HEADERS_V h1
385688: , CST_XLA_INV_REF_V h3
385689: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
385690: , CST_XLA_INV_TXN_TYPES_REF_V h5
385691: , CST_XLA_PLA_CATEGORY_REF_V h6
385692: , fnd_lookup_values fvl85
385693: , fnd_lookup_values fvl114
385694: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
385997: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
385998: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
385999: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
386000: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
386001: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
386002: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
386003: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
386004: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
386005: TYPE t_array_source_44 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_OUTSIDE_PROCESSING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
386093: FROM xla_events_gt xet
386094: , CST_XLA_INV_HEADERS_V h1
386095: , CST_XLA_INV_REF_V h3
386096: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
386097: , CST_XLA_INV_TXN_TYPES_REF_V h5
386098: , CST_XLA_PLA_CATEGORY_REF_V h6
386099: , fnd_lookup_values fvl85
386100: , fnd_lookup_values fvl114
386101: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
387077: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
387078: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
387079: WHEN 3 THEN 'CST_XLA_INV_REF_V'
387080: WHEN 4 THEN 'CST_XLA_INV_REF_V'
387081: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
387082: WHEN 6 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
387083: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
387084: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
387085: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
387170: , CST_XLA_INV_HEADERS_V h1
387171: , CST_XLA_INV_ORG_PARAMS_REF_V h3
387172: , CST_XLA_INV_REF_V h4
387173: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
387174: , CST_XLA_INV_TXN_TYPES_REF_V h6
387175: , CST_XLA_PLA_CATEGORY_REF_V h7
387176: , fnd_lookup_values fvl39
387177: , fnd_lookup_values fvl85
387178: , fnd_lookup_values fvl114
387486: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
387487: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
387488: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
387489: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
387490: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
387491: TYPE t_array_source_39 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.PRIMARY_COST_METHOD%TYPE INDEX BY BINARY_INTEGER;
387492: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
387493: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
387494: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
387588: , CST_XLA_INV_HEADERS_V h1
387589: , CST_XLA_INV_ORG_PARAMS_REF_V h3
387590: , CST_XLA_INV_REF_V h4
387591: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
387592: , CST_XLA_INV_TXN_TYPES_REF_V h6
387593: , CST_XLA_PLA_CATEGORY_REF_V h7
387594: , fnd_lookup_values fvl39
387595: , fnd_lookup_values fvl85
387596: , fnd_lookup_values fvl114
388555: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
388556: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
388557: WHEN 3 THEN 'CST_XLA_INV_REF_V'
388558: WHEN 4 THEN 'CST_XLA_INV_REF_V'
388559: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
388560: WHEN 6 THEN 'CST_XLA_INV_REF_V'
388561: WHEN 7 THEN 'CST_XLA_INV_REF_V'
388562: WHEN 8 THEN 'CST_XLA_INV_REF_V'
388563: WHEN 9 THEN 'CST_XLA_INV_REF_V'
388676: FROM xla_events_gt xet
388677: , CST_XLA_INV_HEADERS_V h1
388678: , CST_XLA_INV_REF_V h3
388679: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
388680: , CST_XLA_INV_TXN_TYPES_REF_V h5
388681: , CST_XLA_PLA_CATEGORY_REF_V h6
388682: , fnd_lookup_values fvl85
388683: , fnd_lookup_values fvl114
388684: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
388985: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
388986: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
388987: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
388988: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
388989: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
388990: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
388991: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_MAT_OVHD_ACCT%TYPE INDEX BY BINARY_INTEGER;
388992: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
388993: TYPE t_array_source_18 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_OUT_PROC_ACCT%TYPE INDEX BY BINARY_INTEGER;
389102: FROM xla_events_gt xet
389103: , CST_XLA_INV_HEADERS_V h1
389104: , CST_XLA_INV_REF_V h3
389105: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
389106: , CST_XLA_INV_TXN_TYPES_REF_V h5
389107: , CST_XLA_PLA_CATEGORY_REF_V h6
389108: , fnd_lookup_values fvl85
389109: , fnd_lookup_values fvl114
389110: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
390091: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
390092: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
390093: WHEN 3 THEN 'CST_XLA_INV_REF_V'
390094: WHEN 4 THEN 'CST_XLA_INV_REF_V'
390095: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
390096: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
390097: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
390098: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
390099: WHEN 9 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
390222: FROM xla_events_gt xet
390223: , CST_XLA_INV_HEADERS_V h1
390224: , CST_XLA_INV_REF_V h3
390225: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
390226: , CST_XLA_INV_TXN_TYPES_REF_V h5
390227: , CST_XLA_PLA_CATEGORY_REF_V h6
390228: , CST_XLA_TRF_PLA_CAT_REF_V h7
390229: , fnd_lookup_values fvl85
390230: , fnd_lookup_values fvl114
390543: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
390544: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
390545: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
390546: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
390547: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
390548: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
390549: TYPE t_array_source_23 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_ACV_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
390550: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
390551: TYPE t_array_source_25 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
390668: FROM xla_events_gt xet
390669: , CST_XLA_INV_HEADERS_V h1
390670: , CST_XLA_INV_REF_V h3
390671: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
390672: , CST_XLA_INV_TXN_TYPES_REF_V h5
390673: , CST_XLA_PLA_CATEGORY_REF_V h6
390674: , CST_XLA_TRF_PLA_CAT_REF_V h7
390675: , fnd_lookup_values fvl85
390676: , fnd_lookup_values fvl114
391676: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
391677: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
391678: WHEN 3 THEN 'CST_XLA_INV_REF_V'
391679: WHEN 4 THEN 'CST_XLA_INV_REF_V'
391680: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
391681: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
391682: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
391683: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
391684: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
391783: , CST_XLA_INTERORG_PARAMS_REF_V h1
391784: , CST_XLA_INV_HEADERS_V h2
391785: , CST_XLA_INV_REF_V h4
391786: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
391787: , CST_XLA_INV_TXN_TYPES_REF_V h6
391788: , CST_XLA_PLA_CATEGORY_REF_V h7
391789: , fnd_lookup_values fvl85
391790: , fnd_lookup_values fvl114
391791: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
392093: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
392094: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
392095: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
392096: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
392097: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
392098: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
392099: TYPE t_array_source_34 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
392100: TYPE t_array_source_35 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PAYABLES_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
392101: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
392202: , CST_XLA_INTERORG_PARAMS_REF_V h1
392203: , CST_XLA_INV_HEADERS_V h2
392204: , CST_XLA_INV_REF_V h4
392205: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
392206: , CST_XLA_INV_TXN_TYPES_REF_V h6
392207: , CST_XLA_PLA_CATEGORY_REF_V h7
392208: , fnd_lookup_values fvl85
392209: , fnd_lookup_values fvl114
392210: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
394981: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
394982: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
394983: WHEN 3 THEN 'CST_XLA_INV_REF_V'
394984: WHEN 4 THEN 'CST_XLA_INV_REF_V'
394985: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
394986: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
394987: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
394988: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
394989: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
395088: , CST_XLA_INTERORG_PARAMS_REF_V h1
395089: , CST_XLA_INV_HEADERS_V h2
395090: , CST_XLA_INV_REF_V h4
395091: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
395092: , CST_XLA_INV_TXN_TYPES_REF_V h6
395093: , CST_XLA_PLA_CATEGORY_REF_V h7
395094: , fnd_lookup_values fvl85
395095: , fnd_lookup_values fvl114
395096: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
395398: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
395399: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
395400: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
395401: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
395402: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
395403: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
395404: TYPE t_array_source_34 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
395405: TYPE t_array_source_35 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PAYABLES_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
395406: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
395507: , CST_XLA_INTERORG_PARAMS_REF_V h1
395508: , CST_XLA_INV_HEADERS_V h2
395509: , CST_XLA_INV_REF_V h4
395510: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
395511: , CST_XLA_INV_TXN_TYPES_REF_V h6
395512: , CST_XLA_PLA_CATEGORY_REF_V h7
395513: , fnd_lookup_values fvl85
395514: , fnd_lookup_values fvl114
395515: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
396689: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
396690: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
396691: WHEN 3 THEN 'CST_XLA_INV_REF_V'
396692: WHEN 4 THEN 'CST_XLA_INV_REF_V'
396693: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
396694: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
396695: WHEN 7 THEN 'CST_XLA_INV_REF_V'
396696: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
396697: WHEN 9 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
396812: , CST_XLA_INV_HEADERS_V h2
396813: , CST_XLA_INV_ORG_PARAMS_REF_V h4
396814: , CST_XLA_INV_REF_V h5
396815: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
396816: , CST_XLA_INV_TXN_TYPES_REF_V h7
396817: , CST_XLA_PLA_CATEGORY_REF_V h8
396818: , fnd_lookup_values fvl85
396819: , fnd_lookup_values fvl114
396820: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
397122: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
397123: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
397124: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
397125: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
397126: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
397127: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
397128: TYPE t_array_source_32 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_TRANSPO_DIST_ACCT%TYPE INDEX BY BINARY_INTEGER;
397129: TYPE t_array_source_33 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_REVENUE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
397130: TYPE t_array_source_35 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PAYABLES_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
397241: , CST_XLA_INV_HEADERS_V h2
397242: , CST_XLA_INV_ORG_PARAMS_REF_V h4
397243: , CST_XLA_INV_REF_V h5
397244: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
397245: , CST_XLA_INV_TXN_TYPES_REF_V h7
397246: , CST_XLA_PLA_CATEGORY_REF_V h8
397247: , fnd_lookup_values fvl85
397248: , fnd_lookup_values fvl114
397249: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
398429: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
398430: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
398431: WHEN 3 THEN 'CST_XLA_INV_REF_V'
398432: WHEN 4 THEN 'CST_XLA_INV_REF_V'
398433: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
398434: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
398435: WHEN 7 THEN 'CST_XLA_INV_REF_V'
398436: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
398437: WHEN 9 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
398546: , CST_XLA_INTERORG_PARAMS_REF_V h1
398547: , CST_XLA_INV_HEADERS_V h2
398548: , CST_XLA_INV_REF_V h4
398549: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
398550: , CST_XLA_INV_TXN_TYPES_REF_V h6
398551: , CST_XLA_PLA_CATEGORY_REF_V h7
398552: , fnd_lookup_values fvl85
398553: , fnd_lookup_values fvl114
398554: ,(select rownum r from all_objects where rownum <= 18 and owner = p_apps_owner)
398856: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
398857: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
398858: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
398859: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
398860: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
398861: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
398862: TYPE t_array_source_32 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_TRANSPO_DIST_ACCT%TYPE INDEX BY BINARY_INTEGER;
398863: TYPE t_array_source_33 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_REVENUE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
398864: TYPE t_array_source_35 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PAYABLES_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
398971: , CST_XLA_INTERORG_PARAMS_REF_V h1
398972: , CST_XLA_INV_HEADERS_V h2
398973: , CST_XLA_INV_REF_V h4
398974: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
398975: , CST_XLA_INV_TXN_TYPES_REF_V h6
398976: , CST_XLA_PLA_CATEGORY_REF_V h7
398977: , fnd_lookup_values fvl85
398978: , fnd_lookup_values fvl114
398979: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
400123: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
400124: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
400125: WHEN 3 THEN 'CST_XLA_INV_REF_V'
400126: WHEN 4 THEN 'CST_XLA_INV_REF_V'
400127: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
400128: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
400129: WHEN 7 THEN 'CST_XLA_INV_REF_V'
400130: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
400131: WHEN 9 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
400246: , CST_XLA_INV_HEADERS_V h2
400247: , CST_XLA_INV_ORG_PARAMS_REF_V h4
400248: , CST_XLA_INV_REF_V h5
400249: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
400250: , CST_XLA_INV_TXN_TYPES_REF_V h7
400251: , CST_XLA_PLA_CATEGORY_REF_V h8
400252: , fnd_lookup_values fvl85
400253: , fnd_lookup_values fvl114
400254: ,(select rownum r from all_objects where rownum <= 19 and owner = p_apps_owner)
400556: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
400557: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
400558: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
400559: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
400560: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
400561: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
400562: TYPE t_array_source_32 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_TRANSPO_DIST_ACCT%TYPE INDEX BY BINARY_INTEGER;
400563: TYPE t_array_source_33 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_REVENUE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
400564: TYPE t_array_source_35 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PAYABLES_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
400675: , CST_XLA_INV_HEADERS_V h2
400676: , CST_XLA_INV_ORG_PARAMS_REF_V h4
400677: , CST_XLA_INV_REF_V h5
400678: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
400679: , CST_XLA_INV_TXN_TYPES_REF_V h7
400680: , CST_XLA_PLA_CATEGORY_REF_V h8
400681: , fnd_lookup_values fvl85
400682: , fnd_lookup_values fvl114
400683: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
401863: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
401864: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
401865: WHEN 3 THEN 'CST_XLA_INV_REF_V'
401866: WHEN 4 THEN 'CST_XLA_INV_REF_V'
401867: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
401868: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
401869: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
401870: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
401871: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
401967: , CST_XLA_INV_HEADERS_V h2
401968: , CST_XLA_INV_ORG_PARAMS_REF_V h4
401969: , CST_XLA_INV_REF_V h5
401970: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
401971: , CST_XLA_INV_TXN_TYPES_REF_V h7
401972: , CST_XLA_PLA_CATEGORY_REF_V h8
401973: , fnd_lookup_values fvl39
401974: , fnd_lookup_values fvl85
401975: , fnd_lookup_values fvl114
402282: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
402283: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
402284: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
402285: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
402286: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
402287: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
402288: TYPE t_array_source_39 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.PRIMARY_COST_METHOD%TYPE INDEX BY BINARY_INTEGER;
402289: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
402290: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
402391: , CST_XLA_INV_HEADERS_V h2
402392: , CST_XLA_INV_ORG_PARAMS_REF_V h4
402393: , CST_XLA_INV_REF_V h5
402394: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
402395: , CST_XLA_INV_TXN_TYPES_REF_V h7
402396: , CST_XLA_PLA_CATEGORY_REF_V h8
402397: , fnd_lookup_values fvl39
402398: , fnd_lookup_values fvl85
402399: , fnd_lookup_values fvl114
403382: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
403383: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
403384: WHEN 3 THEN 'CST_XLA_INV_REF_V'
403385: WHEN 4 THEN 'CST_XLA_INV_REF_V'
403386: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
403387: WHEN 6 THEN 'CST_XLA_INV_REF_V'
403388: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
403389: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
403390: WHEN 9 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
403501: , CST_XLA_INV_HEADERS_V h2
403502: , CST_XLA_INV_ORG_PARAMS_REF_V h4
403503: , CST_XLA_INV_REF_V h5
403504: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
403505: , CST_XLA_INV_TXN_TYPES_REF_V h7
403506: , CST_XLA_PLA_CATEGORY_REF_V h8
403507: , fnd_lookup_values fvl39
403508: , fnd_lookup_values fvl85
403509: , fnd_lookup_values fvl114
403811: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
403812: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
403813: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
403814: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
403815: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
403816: TYPE t_array_source_32 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_TRANSPO_DIST_ACCT%TYPE INDEX BY BINARY_INTEGER;
403817: TYPE t_array_source_34 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
403818: TYPE t_array_source_35 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PAYABLES_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
403819: TYPE t_array_source_36 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PRICE_VAR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
403927: , CST_XLA_INV_HEADERS_V h2
403928: , CST_XLA_INV_ORG_PARAMS_REF_V h4
403929: , CST_XLA_INV_REF_V h5
403930: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
403931: , CST_XLA_INV_TXN_TYPES_REF_V h7
403932: , CST_XLA_PLA_CATEGORY_REF_V h8
403933: , fnd_lookup_values fvl39
403934: , fnd_lookup_values fvl85
403935: , fnd_lookup_values fvl114
405120: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
405121: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
405122: WHEN 3 THEN 'CST_XLA_INV_REF_V'
405123: WHEN 4 THEN 'CST_XLA_INV_REF_V'
405124: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
405125: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
405126: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
405127: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
405128: WHEN 9 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
405244: , CST_XLA_INV_HEADERS_V h2
405245: , CST_XLA_INV_ORG_PARAMS_REF_V h4
405246: , CST_XLA_INV_REF_V h5
405247: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
405248: , CST_XLA_INV_TXN_TYPES_REF_V h7
405249: , CST_XLA_PLA_CATEGORY_REF_V h8
405250: , fnd_lookup_values fvl39
405251: , fnd_lookup_values fvl85
405252: , fnd_lookup_values fvl114
405554: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
405555: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
405556: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
405557: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
405558: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
405559: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
405560: TYPE t_array_source_36 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_PRICE_VAR_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
405561: TYPE t_array_source_37 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.PROFIT_IN_INV_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
405562: TYPE t_array_source_38 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.INV_ORG_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
405673: , CST_XLA_INV_HEADERS_V h2
405674: , CST_XLA_INV_ORG_PARAMS_REF_V h4
405675: , CST_XLA_INV_REF_V h5
405676: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h6
405677: , CST_XLA_INV_TXN_TYPES_REF_V h7
405678: , CST_XLA_PLA_CATEGORY_REF_V h8
405679: , fnd_lookup_values fvl39
405680: , fnd_lookup_values fvl85
405681: , fnd_lookup_values fvl114
406871: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
406872: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
406873: WHEN 3 THEN 'CST_XLA_INV_REF_V'
406874: WHEN 4 THEN 'CST_XLA_INV_REF_V'
406875: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
406876: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
406877: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
406878: WHEN 8 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
406879: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
406978: , CST_XLA_INTERORG_PARAMS_REF_V h1
406979: , CST_XLA_INV_HEADERS_V h2
406980: , CST_XLA_INV_REF_V h4
406981: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
406982: , CST_XLA_INV_TXN_TYPES_REF_V h6
406983: , CST_XLA_PLA_CATEGORY_REF_V h7
406984: , fnd_lookup_values fvl85
406985: , fnd_lookup_values fvl114
406986: ,(select rownum r from all_objects where rownum <= 16 and owner = p_apps_owner)
407288: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
407289: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
407290: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
407291: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
407292: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
407293: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
407294: TYPE t_array_source_33 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_REVENUE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
407295: TYPE t_array_source_40 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_TXFR_CREDIT_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
407296: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
407397: , CST_XLA_INTERORG_PARAMS_REF_V h1
407398: , CST_XLA_INV_HEADERS_V h2
407399: , CST_XLA_INV_REF_V h4
407400: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
407401: , CST_XLA_INV_TXN_TYPES_REF_V h6
407402: , CST_XLA_PLA_CATEGORY_REF_V h7
407403: , fnd_lookup_values fvl85
407404: , fnd_lookup_values fvl114
407405: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
408477: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
408478: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
408479: WHEN 3 THEN 'CST_XLA_INV_REF_V'
408480: WHEN 4 THEN 'CST_XLA_INV_REF_V'
408481: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
408482: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
408483: WHEN 7 THEN 'CST_XLA_INTERORG_PARAMS_REF_V'
408484: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
408485: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
408579: , CST_XLA_INTERORG_PARAMS_REF_V h1
408580: , CST_XLA_INV_HEADERS_V h2
408581: , CST_XLA_INV_REF_V h4
408582: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
408583: , CST_XLA_INV_TXN_TYPES_REF_V h6
408584: , CST_XLA_PLA_CATEGORY_REF_V h7
408585: , fnd_lookup_values fvl85
408586: , fnd_lookup_values fvl114
408587: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
408884: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
408885: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
408886: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
408887: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
408888: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
408889: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
408890: TYPE t_array_source_33 IS TABLE OF CST_XLA_INTERORG_PARAMS_REF_V.INTERORG_REVENUE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
408891: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
408892: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
408988: , CST_XLA_INTERORG_PARAMS_REF_V h1
408989: , CST_XLA_INV_HEADERS_V h2
408990: , CST_XLA_INV_REF_V h4
408991: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h5
408992: , CST_XLA_INV_TXN_TYPES_REF_V h6
408993: , CST_XLA_PLA_CATEGORY_REF_V h7
408994: , fnd_lookup_values fvl85
408995: , fnd_lookup_values fvl114
408996: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
409928: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
409929: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
409930: WHEN 3 THEN 'CST_XLA_INV_REF_V'
409931: WHEN 4 THEN 'CST_XLA_INV_REF_V'
409932: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
409933: WHEN 6 THEN 'CST_XLA_INV_REF_V'
409934: WHEN 7 THEN 'CST_XLA_INV_REF_V'
409935: WHEN 8 THEN 'CST_XLA_INV_REF_V'
409936: WHEN 9 THEN 'CST_XLA_INV_REF_V'
410089: FROM xla_events_gt xet
410090: , CST_XLA_INV_HEADERS_V h1
410091: , CST_XLA_INV_REF_V h3
410092: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
410093: , CST_XLA_INV_TXN_TYPES_REF_V h5
410094: , CST_XLA_PLA_CATEGORY_REF_V h6
410095: , CST_XLA_TRF_PLA_CAT_REF_V h7
410096: , fnd_lookup_values fvl85
410097: , fnd_lookup_values fvl114
410410: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
410411: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
410412: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
410413: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
410414: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
410415: TYPE t_array_source_14 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_MATERIAL_ACCT%TYPE INDEX BY BINARY_INTEGER;
410416: TYPE t_array_source_16 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_MAT_OVHD_ACCT%TYPE INDEX BY BINARY_INTEGER;
410417: TYPE t_array_source_17 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_RESOURCE_ACCT%TYPE INDEX BY BINARY_INTEGER;
410418: TYPE t_array_source_18 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_OUT_PROC_ACCT%TYPE INDEX BY BINARY_INTEGER;
410553: FROM xla_events_gt xet
410554: , CST_XLA_INV_HEADERS_V h1
410555: , CST_XLA_INV_REF_V h3
410556: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
410557: , CST_XLA_INV_TXN_TYPES_REF_V h5
410558: , CST_XLA_PLA_CATEGORY_REF_V h6
410559: , CST_XLA_TRF_PLA_CAT_REF_V h7
410560: , fnd_lookup_values fvl85
410561: , fnd_lookup_values fvl114
411542: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
411543: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
411544: WHEN 3 THEN 'CST_XLA_INV_REF_V'
411545: WHEN 4 THEN 'CST_XLA_INV_REF_V'
411546: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
411547: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
411548: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
411549: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
411550: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
411633: FROM xla_events_gt xet
411634: , CST_XLA_INV_HEADERS_V h1
411635: , CST_XLA_INV_REF_V h3
411636: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
411637: , CST_XLA_INV_TXN_TYPES_REF_V h5
411638: , CST_XLA_PLA_CATEGORY_REF_V h6
411639: , fnd_lookup_values fvl85
411640: , fnd_lookup_values fvl114
411641: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
411942: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
411943: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
411944: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
411945: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
411946: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
411947: TYPE t_array_source_23 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_ACV_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
411948: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
411949: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
411950: TYPE t_array_source_43 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_RESOURCE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
412041: FROM xla_events_gt xet
412042: , CST_XLA_INV_HEADERS_V h1
412043: , CST_XLA_INV_REF_V h3
412044: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
412045: , CST_XLA_INV_TXN_TYPES_REF_V h5
412046: , CST_XLA_PLA_CATEGORY_REF_V h6
412047: , fnd_lookup_values fvl85
412048: , fnd_lookup_values fvl114
412049: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
414275: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
414276: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
414277: WHEN 3 THEN 'CST_XLA_INV_REF_V'
414278: WHEN 4 THEN 'CST_XLA_INV_REF_V'
414279: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
414280: WHEN 6 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414281: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414282: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
414283: WHEN 9 THEN 'CST_XLA_TRF_PLA_CAT_REF_V'
414431: FROM xla_events_gt xet
414432: , CST_XLA_INV_HEADERS_V h1
414433: , CST_XLA_INV_REF_V h3
414434: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
414435: , CST_XLA_INV_TXN_TYPES_REF_V h5
414436: , CST_XLA_PLA_CATEGORY_REF_V h6
414437: , CST_XLA_TRF_PLA_CAT_REF_V h7
414438: , fnd_lookup_values fvl85
414439: , fnd_lookup_values fvl114
414752: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
414753: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
414754: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
414755: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
414756: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
414757: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414758: TYPE t_array_source_23 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_ACV_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414759: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
414760: TYPE t_array_source_25 IS TABLE OF CST_XLA_TRF_PLA_CAT_REF_V.TRF_PLA_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
414892: FROM xla_events_gt xet
414893: , CST_XLA_INV_HEADERS_V h1
414894: , CST_XLA_INV_REF_V h3
414895: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
414896: , CST_XLA_INV_TXN_TYPES_REF_V h5
414897: , CST_XLA_PLA_CATEGORY_REF_V h6
414898: , CST_XLA_TRF_PLA_CAT_REF_V h7
414899: , fnd_lookup_values fvl85
414900: , fnd_lookup_values fvl114
417199: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
417200: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
417201: WHEN 3 THEN 'CST_XLA_INV_REF_V'
417202: WHEN 4 THEN 'CST_XLA_INV_REF_V'
417203: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
417204: WHEN 6 THEN 'CST_XLA_INV_REF_V'
417205: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
417206: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
417207: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
417335: , CST_XLA_INV_HEADERS_V h3
417336: , CST_XLA_INV_ORG_PARAMS_REF_V h5
417337: , CST_XLA_INV_REF_V h6
417338: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h8
417339: , CST_XLA_INV_TXN_TYPES_REF_V h9
417340: , CST_XLA_PLA_CATEGORY_REF_V h10
417341: , CST_XLA_REP_ITEM_REF_V h11
417342: , CST_XLA_WIP_ENTITY_REF_V h13
417343: , fnd_lookup_values fvl55
417676: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
417677: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
417678: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
417679: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
417680: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
417681: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_DISTRIBUTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
417682: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.INV_ORG_AVG_COST_VAR_ACCT%TYPE INDEX BY BINARY_INTEGER;
417683: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
417684: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
417811: , CST_XLA_INV_HEADERS_V h3
417812: , CST_XLA_INV_ORG_PARAMS_REF_V h5
417813: , CST_XLA_INV_REF_V h6
417814: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h8
417815: , CST_XLA_INV_TXN_TYPES_REF_V h9
417816: , CST_XLA_PLA_CATEGORY_REF_V h10
417817: , CST_XLA_REP_ITEM_REF_V h11
417818: , CST_XLA_WIP_ENTITY_REF_V h13
417819: , fnd_lookup_values fvl55
418922: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
418923: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
418924: WHEN 3 THEN 'CST_XLA_INV_REF_V'
418925: WHEN 4 THEN 'CST_XLA_INV_REF_V'
418926: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
418927: WHEN 6 THEN 'CST_XLA_INV_REF_V'
418928: WHEN 7 THEN 'CST_XLA_INV_ORG_PARAMS_REF_V'
418929: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
418930: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
419058: , CST_XLA_INV_HEADERS_V h3
419059: , CST_XLA_INV_ORG_PARAMS_REF_V h5
419060: , CST_XLA_INV_REF_V h6
419061: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h8
419062: , CST_XLA_INV_TXN_TYPES_REF_V h9
419063: , CST_XLA_PLA_CATEGORY_REF_V h10
419064: , CST_XLA_REP_ITEM_REF_V h11
419065: , CST_XLA_WIP_ENTITY_REF_V h13
419066: , fnd_lookup_values fvl55
419399: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
419400: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
419401: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
419402: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
419403: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
419404: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_DISTRIBUTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
419405: TYPE t_array_source_21 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.INV_ORG_AVG_COST_VAR_ACCT%TYPE INDEX BY BINARY_INTEGER;
419406: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
419407: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
419534: , CST_XLA_INV_HEADERS_V h3
419535: , CST_XLA_INV_ORG_PARAMS_REF_V h5
419536: , CST_XLA_INV_REF_V h6
419537: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h8
419538: , CST_XLA_INV_TXN_TYPES_REF_V h9
419539: , CST_XLA_PLA_CATEGORY_REF_V h10
419540: , CST_XLA_REP_ITEM_REF_V h11
419541: , CST_XLA_WIP_ENTITY_REF_V h13
419542: , fnd_lookup_values fvl55
420645: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
420646: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
420647: WHEN 3 THEN 'CST_XLA_INV_REF_V'
420648: WHEN 4 THEN 'CST_XLA_INV_REF_V'
420649: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
420650: WHEN 6 THEN 'CST_XLA_INV_REF_V'
420651: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
420652: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
420653: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
420780: , CST_XLA_FLOW_SCHEDULE_REF_V h2
420781: , CST_XLA_INV_HEADERS_V h3
420782: , CST_XLA_INV_REF_V h5
420783: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h7
420784: , CST_XLA_INV_TXN_TYPES_REF_V h8
420785: , CST_XLA_PLA_CATEGORY_REF_V h9
420786: , CST_XLA_REP_ITEM_REF_V h10
420787: , CST_XLA_WIP_ENTITY_REF_V h11
420788: , fnd_lookup_values fvl55
421115: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
421116: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
421117: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
421118: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
421119: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
421120: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_DISTRIBUTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
421121: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
421122: TYPE t_array_source_24 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_EXPENSE_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
421123: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
421247: , CST_XLA_FLOW_SCHEDULE_REF_V h2
421248: , CST_XLA_INV_HEADERS_V h3
421249: , CST_XLA_INV_REF_V h5
421250: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h7
421251: , CST_XLA_INV_TXN_TYPES_REF_V h8
421252: , CST_XLA_PLA_CATEGORY_REF_V h9
421253: , CST_XLA_REP_ITEM_REF_V h10
421254: , CST_XLA_WIP_ENTITY_REF_V h11
421255: , fnd_lookup_values fvl55
422355: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
422356: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
422357: WHEN 3 THEN 'CST_XLA_INV_REF_V'
422358: WHEN 4 THEN 'CST_XLA_INV_REF_V'
422359: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
422360: WHEN 6 THEN 'CST_XLA_INV_REF_V'
422361: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
422362: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
422363: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
422485: , CST_XLA_FLOW_SCHEDULE_REF_V h2
422486: , CST_XLA_INV_HEADERS_V h3
422487: , CST_XLA_INV_REF_V h5
422488: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h7
422489: , CST_XLA_INV_TXN_TYPES_REF_V h8
422490: , CST_XLA_PLA_CATEGORY_REF_V h9
422491: , CST_XLA_REP_ITEM_REF_V h10
422492: , CST_XLA_WIP_ENTITY_REF_V h11
422493: , fnd_lookup_values fvl55
422820: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
422821: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
422822: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
422823: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
422824: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
422825: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_DISTRIBUTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
422826: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
422827: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
422828: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
422949: , CST_XLA_FLOW_SCHEDULE_REF_V h2
422950: , CST_XLA_INV_HEADERS_V h3
422951: , CST_XLA_INV_REF_V h5
422952: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h7
422953: , CST_XLA_INV_TXN_TYPES_REF_V h8
422954: , CST_XLA_PLA_CATEGORY_REF_V h9
422955: , CST_XLA_REP_ITEM_REF_V h10
422956: , CST_XLA_WIP_ENTITY_REF_V h11
422957: , fnd_lookup_values fvl55
425334: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
425335: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
425336: WHEN 3 THEN 'CST_XLA_INV_REF_V'
425337: WHEN 4 THEN 'CST_XLA_INV_REF_V'
425338: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
425339: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
425340: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
425341:
425342: ELSE null
425395: FROM xla_events_gt xet
425396: , CST_XLA_INV_HEADERS_V h1
425397: , CST_XLA_INV_REF_V h3
425398: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
425399: , CST_XLA_INV_TXN_TYPES_REF_V h5
425400: , fnd_lookup_values fvl85
425401: , fnd_lookup_values fvl114
425402: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
425403: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
425685: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
425686: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
425687: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
425688: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
425689: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
425690: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
425691: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
425692:
425693: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
425762: FROM xla_events_gt xet
425763: , CST_XLA_INV_HEADERS_V h1
425764: , CST_XLA_INV_REF_V h3
425765: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
425766: , CST_XLA_INV_TXN_TYPES_REF_V h5
425767: , fnd_lookup_values fvl85
425768: , fnd_lookup_values fvl114
425769: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
425770: and xet.event_type_code = C_EVENT_TYPE_CODE
427901: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
427902: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
427903: WHEN 3 THEN 'CST_XLA_INV_REF_V'
427904: WHEN 4 THEN 'CST_XLA_INV_REF_V'
427905: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
427906: WHEN 6 THEN 'CST_XLA_INV_REF_V'
427907: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
427908: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
427909: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
428106: , CST_XLA_FLOW_SCHEDULE_REF_V h2
428107: , CST_XLA_INV_HEADERS_V h3
428108: , CST_XLA_INV_REF_V h5
428109: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h7
428110: , CST_XLA_INV_TXN_TYPES_REF_V h8
428111: , CST_XLA_PLA_CATEGORY_REF_V h9
428112: , CST_XLA_REP_ITEM_REF_V h10
428113: , CST_XLA_REP_SCHED_REF_V h11
428114: , CST_XLA_WIP_ENTITY_REF_V h12
428442: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
428443: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
428444: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
428445: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
428446: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
428447: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_DISTRIBUTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
428448: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
428449: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
428450: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
428616: , CST_XLA_FLOW_SCHEDULE_REF_V h2
428617: , CST_XLA_INV_HEADERS_V h3
428618: , CST_XLA_INV_REF_V h5
428619: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h7
428620: , CST_XLA_INV_TXN_TYPES_REF_V h8
428621: , CST_XLA_PLA_CATEGORY_REF_V h9
428622: , CST_XLA_REP_ITEM_REF_V h10
428623: , CST_XLA_REP_SCHED_REF_V h11
428624: , CST_XLA_WIP_ENTITY_REF_V h12
429770: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
429771: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
429772: WHEN 3 THEN 'CST_XLA_INV_REF_V'
429773: WHEN 4 THEN 'CST_XLA_INV_REF_V'
429774: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
429775: WHEN 6 THEN 'CST_XLA_INV_REF_V'
429776: WHEN 7 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
429777: WHEN 8 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
429778: WHEN 9 THEN 'CST_XLA_PLA_CATEGORY_REF_V'
429975: , CST_XLA_FLOW_SCHEDULE_REF_V h2
429976: , CST_XLA_INV_HEADERS_V h3
429977: , CST_XLA_INV_REF_V h5
429978: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h7
429979: , CST_XLA_INV_TXN_TYPES_REF_V h8
429980: , CST_XLA_PLA_CATEGORY_REF_V h9
429981: , CST_XLA_REP_ITEM_REF_V h10
429982: , CST_XLA_REP_SCHED_REF_V h11
429983: , CST_XLA_WIP_ENTITY_REF_V h12
430311: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
430312: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
430313: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
430314: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
430315: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
430316: TYPE t_array_source_20 IS TABLE OF CST_XLA_INV_REF_V.INV_TXN_DISTRIBUTION_ACCT%TYPE INDEX BY BINARY_INTEGER;
430317: TYPE t_array_source_22 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_BRIDGING_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
430318: TYPE t_array_source_41 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
430319: TYPE t_array_source_42 IS TABLE OF CST_XLA_PLA_CATEGORY_REF_V.PLA_MATERIAL_OVERHEAD_ACCOUNT%TYPE INDEX BY BINARY_INTEGER;
430485: , CST_XLA_FLOW_SCHEDULE_REF_V h2
430486: , CST_XLA_INV_HEADERS_V h3
430487: , CST_XLA_INV_REF_V h5
430488: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h7
430489: , CST_XLA_INV_TXN_TYPES_REF_V h8
430490: , CST_XLA_PLA_CATEGORY_REF_V h9
430491: , CST_XLA_REP_ITEM_REF_V h10
430492: , CST_XLA_REP_SCHED_REF_V h11
430493: , CST_XLA_WIP_ENTITY_REF_V h12
431639: WHEN 1 THEN 'CST_XLA_INV_HEADERS_V'
431640: WHEN 2 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
431641: WHEN 3 THEN 'CST_XLA_INV_REF_V'
431642: WHEN 4 THEN 'CST_XLA_INV_REF_V'
431643: WHEN 5 THEN 'CST_XLA_INV_TXN_TYPES_REF_V'
431644: WHEN 6 THEN 'CST_XLA_INV_HEADERS_V'
431645: WHEN 7 THEN 'CST_XLA_INV_HEADERS_V'
431646:
431647: ELSE null
431700: FROM xla_events_gt xet
431701: , CST_XLA_INV_HEADERS_V h1
431702: , CST_XLA_INV_REF_V h3
431703: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
431704: , CST_XLA_INV_TXN_TYPES_REF_V h5
431705: , fnd_lookup_values fvl85
431706: , fnd_lookup_values fvl114
431707: ,(select rownum r from all_objects where rownum <= 7 and owner = p_apps_owner)
431708: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
431990: TYPE t_array_source_1 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
431991: TYPE t_array_source_2 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.ITEM_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
431992: TYPE t_array_source_3 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
431993: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_REF_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
431994: TYPE t_array_source_5 IS TABLE OF CST_XLA_INV_TXN_TYPES_REF_V.INV_TXN_TYPE_DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
431995: TYPE t_array_source_85 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
431996: TYPE t_array_source_114 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;
431997:
431998: TYPE t_array_source_11 IS TABLE OF CST_XLA_INV_LINES_V.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
432067: FROM xla_events_gt xet
432068: , CST_XLA_INV_HEADERS_V h1
432069: , CST_XLA_INV_REF_V h3
432070: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h4
432071: , CST_XLA_INV_TXN_TYPES_REF_V h5
432072: , fnd_lookup_values fvl85
432073: , fnd_lookup_values fvl114
432074: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
432075: and xet.event_type_code = C_EVENT_TYPE_CODE