APPS.OKE_DELIVERABLE_ACTIONS_PKG dependencies on MRP_SCHEDULE_ITEMS

Line 67: FROM mrp_schedule_items mrp

63: INTO Dummy
64: FROM dual
65: WHERE NOT EXISTS (
66: SELECT 1
67: FROM mrp_schedule_items mrp
68: , oke_deliverables_b oke
69: , oke_deliverable_actions oka
70: WHERE oka.action_id = p_action_id
71: AND oke.deliverable_id = oka.deliverable_id

Line 165: INSERT INTO mrp_schedule_items (

161: INTO l_id
162: FROM dual;
163:
164: IF Check_Item_Unique ( P_Action_ID ) THEN
165: INSERT INTO mrp_schedule_items (
166: inventory_item_id
167: , organization_id
168: , schedule_designator
169: , last_update_date