DBA Data[Home] [Help]

APPS.MRP_END_ASSY dependencies on MRP_PLAN_ORGANIZATIONS_V

Line 29: mrp_plan_organizations_v plans

25: c_component number) IS
26: SELECT bom.using_assembly_id using_assembly_item_id,
27: sum(bom.usage_quantity) operation_usage_quantity
28: FROM mrp_bom_components bom,
29: mrp_plan_organizations_v plans
30: WHERE bom.compile_designator = c_compile_desig
31: AND bom.compile_designator = plans.compile_designator
32: AND trunc(bom.effectivity_date) <= trunc(plans.CUTOFF_DATE)
33: AND bom.organization_id = plans.planned_organization