APPS.BOM_VALIDATE_REF_DESIGNATOR dependencies on MTL_SYSTEM_ITEMS

Line 281: FROM mtl_system_items_b msi,

277:
278: /*Check BOM enabled flag of the assembly*/
279: SELECT msi.bom_enabled_flag
280: INTO l_assy_bom_enabled
281: FROM mtl_system_items_b msi,
282: bom_bill_of_materials bbom
283: WHERE bbom.bill_sequence_id = p_Ref_Desg_Unexp_Rec.bill_sequence_id
284: AND bbom.assembly_item_id = msi.inventory_item_id
285: AND bbom.organization_id = msi.organization_id;

Line 480: mtl_system_items msi,

476: INTO l_dummy
477: FROM sys.dual
478: WHERE EXISTS (SELECT 'Planning Item'
479: FROM bom_bill_of_materials bom,
480: mtl_system_items msi,
481: bom_inventory_components bic
482: WHERE msi.bom_item_type = 3 /* PLANNING */
483: AND msi.inventory_item_id = bom.assembly_item_id
484: AND msi.organization_id = bom.organization_id