APPS.CSP_PROD_TASK_PARTS_HISTORY dependencies on MTL_SYSTEM_ITEMS_B

Line 34: mtl_system_items_b msib,

30: from csf_debrief_lines cdl,
31: csf_debrief_headers cdh,
32: jtf_task_assignments jta,
33: jtf_tasks_b jtb,
34: mtl_system_items_b msib,
35: cs_incidents_all cia
36: where cdl.statistics_updated is null
37: and cdl.spare_update_status = 'SUCCEEDED'
38: and cdl.issuing_sub_inventory_code is not null

Line 425: from mtl_system_items_b

421: order by ctp.actual_times_used desc;
422:
423: cursor primary_uom is
424: select primary_uom_code
425: from mtl_system_items_b
426: where inventory_item_id = l_supersede_item;
427:
428: Type v_cur_type IS REF CURSOR;
429: