APPS.BOM_VALIDATE_REF_DESIGNATOR dependencies on BOM_BILL_OF_MATERIALS

Line 250: FROM bom_bill_of_materials

246: If bom_globals.get_debug = 'Y' then Error_Handler.write_debug('Ref Desg: Checking for editable common bill...'); END IF;
247: BEGIN
248: SELECT 1
249: INTO l_dummy
250: FROM bom_bill_of_materials
251: WHERE bill_sequence_id = source_bill_sequence_id
252: AND bill_sequence_id = p_ref_desg_unexp_rec.bill_sequence_id;
253: EXCEPTION
254: WHEN NO_DATA_FOUND THEN

Line 282: bom_bill_of_materials bbom

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;
286:

Line 479: FROM bom_bill_of_materials bom,

475: SELECT 'Planning Bill'
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