APPS.ENG_VALIDATE_REVISED_ITEM dependencies on MRP_SYSTEM_ITEMS

Line 220: FROM mrp_system_items

216: l_err_text VARCHAR2(2000) := NULL;
217:
218: CURSOR USE_UP_PLAN IS
219: SELECT 'VALID'
220: FROM mrp_system_items
221: WHERE inventory_item_id = p_use_up_item_id
222: AND organization_id = p_organization_id
223: AND compile_designator = p_use_up_plan_name
224: AND inventory_use_up_date >= SYSDATE;

Line 1293: FROM mrp_system_items

1289: RETURN BOOLEAN
1290: IS
1291: CURSOR c_CheckUseUpDate IS
1292: SELECT inventory_use_up_date
1293: FROM mrp_system_items
1294: WHERE inventory_use_up_date = p_schedule_date
1295: AND inventory_item_id = p_revised_item_id
1296: AND organization_id = p_organization_id
1297: AND compile_designator = p_use_up_plan;

Line 4437: -- for that plan and item in MRP_System_Items

4433: /********************************************************************
4434: --
4435: -- If the use_up_plan is given then verify that the schedule_date
4436: -- for the revised component matches with the inventory_use_up_date
4437: -- for that plan and item in MRP_System_Items
4438: -- Similarly if the user is trying to update the schedule_date and
4439: -- the use_up_item is not null, then check if the new_effective_date
4440: -- matches the inventory_use_up_date
4441: --