DBA Data[Home] [Help]

APPS.BOM_VALIDATE_COMP_OPERATION dependencies on BOM_BILL_OF_MATERIALS

Line 324: FROM bom_bill_of_materials

320:
321: BEGIN
322: SELECT 1
323: INTO p_dummy
324: FROM bom_bill_of_materials
325: WHERE bill_sequence_id = source_bill_sequence_id
326: AND bill_sequence_id = p_bom_comp_ops_unexp_rec.bill_Sequence_id;
327: EXCEPTION
328: WHEN NO_DATA_FOUND THEN

Line 344: bom_bill_of_materials bbom

340:
341: SELECT msi.bom_enabled_flag
342: INTO l_assy_bom_enabled
343: FROM mtl_system_items_b msi,
344: bom_bill_of_materials bbom
345: WHERE bbom.bill_sequence_id = p_bom_comp_ops_Unexp_Rec.bill_sequence_id
346: AND bbom.assembly_item_id = msi.inventory_item_id
347: AND bbom.organization_id = msi.organization_id;
348: