[Home] [Help]
307778: SELECT xet.event_id event_id
307779: , 0 line_number
307780: , CASE r
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'
307873: FROM xla_events_gt xet
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
308187: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
308188: --
308189:
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;
308291: FROM xla_events_gt xet
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
309290: SELECT xet.event_id event_id
309291: , 0 line_number
309292: , CASE r
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'
309353: END source_meaning
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)
309646: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
309647: --
309648:
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;
309727: , fvl114.meaning source_114_meaning
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
310665: SELECT xet.event_id event_id
310666: , 0 line_number
310667: , CASE r
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'
310728: END source_meaning
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)
311021: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
311022: --
311023:
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;
311102: , fvl114.meaning source_114_meaning
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
312040: SELECT xet.event_id event_id
312041: , 0 line_number
312042: , CASE r
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'
312154: FROM xla_events_gt xet
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
312464: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
312465: --
312466:
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;
312577: FROM xla_events_gt xet
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
314980: SELECT xet.event_id event_id
314981: , 0 line_number
314982: , CASE r
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'
315139: FROM xla_events_gt xet
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
315454: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
315455: --
315456:
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;
315594: FROM xla_events_gt xet
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
316925: SELECT xet.event_id event_id
316926: , 0 line_number
316927: , CASE r
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'
317039: FROM xla_events_gt xet
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
317350: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
317351: --
317352:
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;
317463: FROM xla_events_gt xet
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
318663: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
318664: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
318665: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
318666: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
318667: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
318668: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'
318669: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'
318670: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'
318671: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
318760: END source_meaning
318761: FROM xla_events_gt xet
318762: , CST_XLA_DISCRETE_JOB_REF_V h1
318763: , CST_XLA_FLOW_SCHEDULE_REF_V h2
318764: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
318765: , CST_XLA_REP_ITEM_REF_V h4
318766: , CST_XLA_WIP_ENTITY_REF_V h5
318767: , CST_XLA_WIP_HEADERS_V h6
318768: , fnd_lookup_values fvl7
319042: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
319043: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
319044: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
319045: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
319046: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
319047: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
319048: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;
319049: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
319050: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
319135: , fvl114.meaning source_114_meaning
319136: FROM xla_events_gt xet
319137: , CST_XLA_DISCRETE_JOB_REF_V h1
319138: , CST_XLA_FLOW_SCHEDULE_REF_V h2
319139: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
319140: , CST_XLA_REP_ITEM_REF_V h4
319141: , CST_XLA_WIP_ENTITY_REF_V h5
319142: , CST_XLA_WIP_HEADERS_V h6
319143: , fnd_lookup_values fvl7
320174: SELECT xet.event_id event_id
320175: , 0 line_number
320176: , CASE r
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'
320248: FROM xla_events_gt xet
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)
320542: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
320543: --
320544:
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;
320630: FROM xla_events_gt xet
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
321598: SELECT xet.event_id event_id
321599: , 0 line_number
321600: , CASE r
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'
321697: FROM xla_events_gt xet
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
322007: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
322008: --
322009:
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;
322112: FROM xla_events_gt xet
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
323099: SELECT xet.event_id event_id
323100: , 0 line_number
323101: , CASE r
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'
323258: FROM xla_events_gt xet
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
323572: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
323573: --
323574:
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;
323713: FROM xla_events_gt xet
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
325000: SELECT xet.event_id event_id
325001: , 0 line_number
325002: , CASE r
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'
325164: FROM xla_events_gt xet
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
325478: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
325479: --
325480:
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;
325622: FROM xla_events_gt xet
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
326911: SELECT xet.event_id event_id
326912: , 0 line_number
326913: , CASE r
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'
327032: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
327342: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
327343: --
327344:
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;
327460: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
328598: SELECT xet.event_id event_id
328599: , 0 line_number
328600: , CASE r
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'
328709: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
329019: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
329020: --
329021:
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;
329131: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
330163: SELECT xet.event_id event_id
330164: , 0 line_number
330165: , CASE r
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'
330269: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
330584: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
330585: --
330586:
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;
330695: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
331699: SELECT xet.event_id event_id
331700: , 0 line_number
331701: , CASE r
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'
331855: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
332174: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
332175: --
332176:
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;
332315: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
333395: SELECT xet.event_id event_id
333396: , 0 line_number
333397: , CASE r
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'
333516: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
333826: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
333827: --
333828:
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;
333944: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
335150: SELECT xet.event_id event_id
335151: , 0 line_number
335152: , CASE r
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'
335271: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
335581: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
335582: --
335583:
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;
335699: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
338419: SELECT xet.event_id event_id
338420: , 0 line_number
338421: , CASE r
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'
338523: FROM xla_events_gt xet
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
338828: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
338829: --
338830:
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;
338934: FROM xla_events_gt xet
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
339874: SELECT xet.event_id event_id
339875: , 0 line_number
339876: , CASE r
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'
340027: END source_meaning
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
340351: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
340352: --
340353:
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;
340489: , fvl114.meaning source_114_meaning
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
341496: SELECT xet.event_id event_id
341497: , 0 line_number
341498: , CASE r
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'
341622: FROM xla_events_gt xet
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
341932: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
341933: --
341934:
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;
342046: FROM xla_events_gt xet
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
343111: SELECT xet.event_id event_id
343112: , 0 line_number
343113: , CASE r
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'
343237: FROM xla_events_gt xet
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
343547: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
343548: --
343549:
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;
343661: FROM xla_events_gt xet
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
344729: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
344730: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
344731: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
344732: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
344733: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
344734: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'
344735: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'
344736: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'
344737: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
344826: END source_meaning
344827: FROM xla_events_gt xet
344828: , CST_XLA_DISCRETE_JOB_REF_V h1
344829: , CST_XLA_FLOW_SCHEDULE_REF_V h2
344830: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
344831: , CST_XLA_REP_ITEM_REF_V h4
344832: , CST_XLA_WIP_ENTITY_REF_V h5
344833: , CST_XLA_WIP_HEADERS_V h6
344834: , fnd_lookup_values fvl7
345108: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
345109: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
345110: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
345111: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
345112: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
345113: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
345114: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;
345115: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
345116: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
345201: , fvl114.meaning source_114_meaning
345202: FROM xla_events_gt xet
345203: , CST_XLA_DISCRETE_JOB_REF_V h1
345204: , CST_XLA_FLOW_SCHEDULE_REF_V h2
345205: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
345206: , CST_XLA_REP_ITEM_REF_V h4
345207: , CST_XLA_WIP_ENTITY_REF_V h5
345208: , CST_XLA_WIP_HEADERS_V h6
345209: , fnd_lookup_values fvl7
346240: SELECT xet.event_id event_id
346241: , 0 line_number
346242: , CASE r
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'
346335: FROM xla_events_gt xet
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
346649: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
346650: --
346651:
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;
346753: FROM xla_events_gt xet
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
347718: SELECT xet.event_id event_id
347719: , 0 line_number
347720: , CASE r
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'
347813: FROM xla_events_gt xet
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
348127: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
348128: --
348129:
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;
348231: FROM xla_events_gt xet
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
351704: SELECT xet.event_id event_id
351705: , 0 line_number
351706: , CASE r
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'
351813: END source_meaning
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
352127: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
352128: --
352129:
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;
352239: , fvl114.meaning source_114_meaning
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
353308: SELECT xet.event_id event_id
353309: , 0 line_number
353310: , CASE r
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'
353402: END source_meaning
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
353716: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
353717: --
353718:
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;
353819: , fvl114.meaning source_114_meaning
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
354710: SELECT xet.event_id event_id
354711: , 0 line_number
354712: , CASE r
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'
354804: END source_meaning
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
355118: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
355119: --
355120:
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;
355221: , fvl114.meaning source_114_meaning
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
356112: SELECT xet.event_id event_id
356113: , 0 line_number
356114: , CASE r
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'
356221: END source_meaning
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
356535: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
356536: --
356537:
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;
356647: , fvl114.meaning source_114_meaning
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
357716: SELECT xet.event_id event_id
357717: , 0 line_number
357718: , CASE r
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'
357864: END source_meaning
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
358176: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
358177: --
358178:
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;
358310: , fvl114.meaning source_114_meaning
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
359591: SELECT xet.event_id event_id
359592: , 0 line_number
359593: , CASE r
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'
359739: END source_meaning
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
360051: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
360052: --
360053:
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;
360185: , fvl114.meaning source_114_meaning
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
361466: SELECT xet.event_id event_id
361467: , 0 line_number
361468: , CASE r
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'
361619: END source_meaning
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
361931: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
361932: --
361933:
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;
362068: , fvl114.meaning source_114_meaning
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
363351: SELECT xet.event_id event_id
363352: , 0 line_number
363353: , CASE r
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'
363439: END source_meaning
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
363748: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
363749: --
363750:
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;
363846: , fvl114.meaning source_114_meaning
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
364794: SELECT xet.event_id event_id
364795: , 0 line_number
364796: , CASE r
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'
364882: END source_meaning
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
365191: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
365192: --
365193:
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;
365289: , fvl114.meaning source_114_meaning
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
366169: SELECT xet.event_id event_id
366170: , 0 line_number
366171: , CASE r
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'
366232: END source_meaning
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)
366521: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
366522: --
366523:
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;
366599: , fvl114.meaning source_114_meaning
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
367447: SELECT xet.event_id event_id
367448: , 0 line_number
367449: , CASE r
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'
367535: END source_meaning
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
367845: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
367846: --
367847:
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;
367942: , fvl114.meaning source_114_meaning
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
368859: WHEN 1 THEN 'CST_XLA_WIP_HEADERS_V'
368860: WHEN 2 THEN 'CST_XLA_WIP_HEADERS_V'
368861: WHEN 3 THEN 'CST_XLA_WIP_HEADERS_V'
368862: WHEN 4 THEN 'CST_XLA_WIP_HEADERS_V'
368863: WHEN 5 THEN 'CST_XLA_INV_SYSTEM_ITEMS_REF_V'
368864: WHEN 6 THEN 'CST_XLA_DISCRETE_JOB_REF_V'
368865: WHEN 7 THEN 'CST_XLA_WIP_ENTITY_REF_V'
368866: WHEN 8 THEN 'CST_XLA_FLOW_SCHEDULE_REF_V'
368867: WHEN 9 THEN 'CST_XLA_REP_ITEM_REF_V'
368956: END source_meaning
368957: FROM xla_events_gt xet
368958: , CST_XLA_DISCRETE_JOB_REF_V h1
368959: , CST_XLA_FLOW_SCHEDULE_REF_V h2
368960: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
368961: , CST_XLA_REP_ITEM_REF_V h4
368962: , CST_XLA_WIP_ENTITY_REF_V h5
368963: , CST_XLA_WIP_HEADERS_V h6
368964: , fnd_lookup_values fvl7
369238: TYPE t_array_source_1 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
369239: TYPE t_array_source_4 IS TABLE OF CST_XLA_WIP_HEADERS_V.TRANSACTION_UOM%TYPE INDEX BY BINARY_INTEGER;
369240: TYPE t_array_source_6 IS TABLE OF CST_XLA_WIP_HEADERS_V.PRIMARY_QUANTITY%TYPE INDEX BY BINARY_INTEGER;
369241: TYPE t_array_source_7 IS TABLE OF CST_XLA_WIP_HEADERS_V.WIP_TRANSACTION_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
369242: TYPE t_array_source_53 IS TABLE OF CST_XLA_INV_SYSTEM_ITEMS_REF_V.INV_ITEM_EXPENSE_ACCT%TYPE INDEX BY BINARY_INTEGER;
369243: TYPE t_array_source_54 IS TABLE OF CST_XLA_DISCRETE_JOB_REF_V.DIS_JOB_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
369244: TYPE t_array_source_55 IS TABLE OF CST_XLA_WIP_ENTITY_REF_V.WIP_ENTITY_TYPE%TYPE INDEX BY BINARY_INTEGER;
369245: TYPE t_array_source_56 IS TABLE OF CST_XLA_FLOW_SCHEDULE_REF_V.FLO_SCH_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
369246: TYPE t_array_source_57 IS TABLE OF CST_XLA_REP_ITEM_REF_V.REP_ITM_BRIDGING_ACCT%TYPE INDEX BY BINARY_INTEGER;
369331: , fvl114.meaning source_114_meaning
369332: FROM xla_events_gt xet
369333: , CST_XLA_DISCRETE_JOB_REF_V h1
369334: , CST_XLA_FLOW_SCHEDULE_REF_V h2
369335: , CST_XLA_INV_SYSTEM_ITEMS_REF_V h3
369336: , CST_XLA_REP_ITEM_REF_V h4
369337: , CST_XLA_WIP_ENTITY_REF_V h5
369338: , CST_XLA_WIP_HEADERS_V h6
369339: , fnd_lookup_values fvl7
371797: SELECT xet.event_id event_id
371798: , 0 line_number
371799: , CASE r
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'
371951: FROM xla_events_gt xet
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
372275: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
372276: --
372277:
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;
372416: FROM xla_events_gt xet
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
373713: SELECT xet.event_id event_id
373714: , 0 line_number
373715: , CASE r
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'
373872: FROM xla_events_gt xet
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
374196: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
374197: --
374198:
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;
374340: FROM xla_events_gt xet
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
376966: SELECT xet.event_id event_id
376967: , 0 line_number
376968: , CASE r
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'
377029: END source_meaning
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)
377318: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
377319: --
377320:
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;
377396: , fvl114.meaning source_114_meaning
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
380740: SELECT xet.event_id event_id
380741: , 0 line_number
380742: , CASE r
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'
380894: FROM xla_events_gt xet
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
381218: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
381219: --
381220:
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;
381359: FROM xla_events_gt xet
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
382656: SELECT xet.event_id event_id
382657: , 0 line_number
382658: , CASE r
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'
382744: END source_meaning
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
383053: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
383054: --
383055:
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;
383151: , fvl114.meaning source_114_meaning
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
384133: SELECT xet.event_id event_id
384134: , 0 line_number
384135: , CASE r
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'
384221: END source_meaning
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
384530: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
384531: --
384532:
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;
384628: , fvl114.meaning source_114_meaning
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
385597: SELECT xet.event_id event_id
385598: , 0 line_number
385599: , CASE r
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'
385685: END source_meaning
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
385994: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
385995: --
385996:
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;
386092: , fvl114.meaning source_114_meaning
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
387074: SELECT xet.event_id event_id
387075: , 0 line_number
387076: , CASE r
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'
387169: FROM xla_events_gt xet
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
387483: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
387484: --
387485:
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;
387587: FROM xla_events_gt xet
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
388552: SELECT xet.event_id event_id
388553: , 0 line_number
388554: , CASE r
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'
388675: END source_meaning
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
388982: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
388983: --
388984:
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;
389101: , fvl114.meaning source_114_meaning
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
390088: SELECT xet.event_id event_id
390089: , 0 line_number
390090: , CASE r
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'
390221: END source_meaning
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
390540: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
390541: --
390542:
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;
390667: , fvl114.meaning source_114_meaning
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
391673: SELECT xet.event_id event_id
391674: , 0 line_number
391675: , CASE r
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'
391782: FROM xla_events_gt xet
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
392090: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
392091: --
392092:
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;
392201: FROM xla_events_gt xet
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
394978: SELECT xet.event_id event_id
394979: , 0 line_number
394980: , CASE r
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'
395087: FROM xla_events_gt xet
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
395395: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
395396: --
395397:
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;
395506: FROM xla_events_gt xet
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
396686: SELECT xet.event_id event_id
396687: , 0 line_number
396688: , CASE r
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'
396811: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
397119: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
397120: --
397121:
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;
397240: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
398426: SELECT xet.event_id event_id
398427: , 0 line_number
398428: , CASE r
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'
398545: FROM xla_events_gt xet
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
398853: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
398854: --
398855:
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;
398970: FROM xla_events_gt xet
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
400120: SELECT xet.event_id event_id
400121: , 0 line_number
400122: , CASE r
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'
400245: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
400553: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
400554: --
400555:
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;
400674: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
401860: SELECT xet.event_id event_id
401861: , 0 line_number
401862: , CASE r
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'
401966: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
402279: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
402280: --
402281:
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;
402390: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
403379: SELECT xet.event_id event_id
403380: , 0 line_number
403381: , CASE r
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'
403500: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
403808: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
403809: --
403810:
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;
403926: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
405117: SELECT xet.event_id event_id
405118: , 0 line_number
405119: , CASE r
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'
405243: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
405551: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
405552: --
405553:
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;
405672: , CST_XLA_INTERORG_PARAMS_REF_V h1
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
406868: SELECT xet.event_id event_id
406869: , 0 line_number
406870: , CASE r
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'
406977: FROM xla_events_gt xet
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
407285: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
407286: --
407287:
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;
407396: FROM xla_events_gt xet
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
408474: SELECT xet.event_id event_id
408475: , 0 line_number
408476: , CASE r
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'
408578: FROM xla_events_gt xet
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
408881: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
408882: --
408883:
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;
408987: FROM xla_events_gt xet
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
409925: SELECT xet.event_id event_id
409926: , 0 line_number
409927: , CASE r
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'
410088: END source_meaning
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
410407: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
410408: --
410409:
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;
410552: , fvl114.meaning source_114_meaning
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
411539: SELECT xet.event_id event_id
411540: , 0 line_number
411541: , CASE r
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'
411632: END source_meaning
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
411939: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
411940: --
411941:
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;
412040: , fvl114.meaning source_114_meaning
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
414272: SELECT xet.event_id event_id
414273: , 0 line_number
414274: , CASE r
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'
414430: END source_meaning
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
414749: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
414750: --
414751:
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;
414891: , fvl114.meaning source_114_meaning
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
417196: SELECT xet.event_id event_id
417197: , 0 line_number
417198: , CASE r
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'
417334: , CST_XLA_FLOW_SCHEDULE_REF_V h2
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
417673: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
417674: --
417675:
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;
417810: , CST_XLA_FLOW_SCHEDULE_REF_V h2
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
418919: SELECT xet.event_id event_id
418920: , 0 line_number
418921: , CASE r
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'
419057: , CST_XLA_FLOW_SCHEDULE_REF_V h2
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
419396: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
419397: --
419398:
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;
419533: , CST_XLA_FLOW_SCHEDULE_REF_V h2
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
420642: SELECT xet.event_id event_id
420643: , 0 line_number
420644: , CASE r
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'
420779: , CST_XLA_DISCRETE_JOB_REF_V h1
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
421112: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
421113: --
421114:
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;
421246: , CST_XLA_DISCRETE_JOB_REF_V h1
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
422352: SELECT xet.event_id event_id
422353: , 0 line_number
422354: , CASE r
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'
422484: , CST_XLA_DISCRETE_JOB_REF_V h1
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
422817: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
422818: --
422819:
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;
422948: , CST_XLA_DISCRETE_JOB_REF_V h1
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
425331: SELECT xet.event_id event_id
425332: , 0 line_number
425333: , CASE r
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'
425394: END source_meaning
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)
425682: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
425683: --
425684:
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;
425761: , fvl114.meaning source_114_meaning
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
427898: SELECT xet.event_id event_id
427899: , 0 line_number
427900: , CASE r
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'
428105: , CST_XLA_DISCRETE_JOB_REF_V h1
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
428439: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
428440: --
428441:
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;
428615: , CST_XLA_DISCRETE_JOB_REF_V h1
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
429767: SELECT xet.event_id event_id
429768: , 0 line_number
429769: , CASE r
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'
429974: , CST_XLA_DISCRETE_JOB_REF_V h1
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
430308: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
430309: --
430310:
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;
430484: , CST_XLA_DISCRETE_JOB_REF_V h1
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
431636: SELECT xet.event_id event_id
431637: , 0 line_number
431638: , CASE r
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'
431699: END source_meaning
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)
431987: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
431988: --
431989:
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;
432066: , fvl114.meaning source_114_meaning
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