DBA Data[Home] [Help]

APPS.MRP_VALIDATE_FLOW_SCHEDULE dependencies on MTL_SYSTEM_ITEMS

Line 708: FROM mtl_system_items

704: l_see_eng_items := FND_PROFILE.Value('WIP_SEE_ENG_ITEMS');
705:
706: SELECT 'VALID'
707: INTO l_dummy
708: FROM mtl_system_items
709: WHERE organization_id = l_flow_schedule_rec.organization_id
710: AND inventory_item_id = l_flow_schedule_rec.primary_item_id
711: AND build_in_wip_flag = 'Y'
712: AND pick_components_flag = 'N'