eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1228: FROM mrp_system_items

1224: RETURN BOOLEAN
1225: IS
1226: CURSOR c_CheckUseUpDate IS
1227: SELECT inventory_use_up_date
1228: FROM mrp_system_items
1229: WHERE inventory_use_up_date = p_schedule_date
1230: AND inventory_item_id = p_revised_item_id
1231: AND organization_id = p_organization_id
1232: AND compile_designator = p_use_up_plan;

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

4356: /********************************************************************
4357: --
4358: -- If the use_up_plan is given then verify that the schedule_date
4359: -- for the revised component matches with the inventory_use_up_date
4360: -- for that plan and item in MRP_System_Items
4361: -- Similarly if the user is trying to update the schedule_date and
4362: -- the use_up_item is not null, then check if the new_effective_date
4363: -- matches the inventory_use_up_date
4364: --