DBA Data[Home] [Help]

APPS.ENG_DEFAULT_REVISED_ITEM dependencies on MRP_PLANS

Line 1254: FROM mrp_plans pl2

1250: AND si.compile_designator = p_use_up_plan_name
1251: AND si.inventory_item_id = bl.assembly_item_id
1252: AND si.inventory_use_up_date >= trunc(sysdate)
1253: AND (EXISTS ( SELECT 'valid'
1254: FROM mrp_plans pl2
1255: WHERE pl2.organization_id = p_organization_id
1256: AND pl2.explosion_completion_date <=
1257: pl2.data_completion_date
1258: AND pl2.data_completion_date <=