APPS.BOM_INV_COMPS1_PKG dependencies on BOM_BILL_OF_MATERIALS

Line 79: FROM bom_bill_of_materials bbom,

75: eng_items_for_mfg_ecos_flag := 'YES';
76: end if;
77:
78: SELECT 1 INTO dummy
79: FROM bom_bill_of_materials bbom,
80: mtl_system_items msi1
81: WHERE bbom.source_bill_sequence_id = X_Bill_Sequence_Id
82: AND bbom.organization_id <> X_Organization_Id
83: AND msi1.inventory_item_id = bbom.assembly_item_id

Line 552: FROM Bom_Bill_Of_Materials bbm

548: -- Raising Business event
549:
550: SELECT bbm.Organization_Id, bbm.alternate_bom_designator, bbm.assembly_item_id, bbm.specific_assembly_comment
551: INTO org_id, alt_bom_code, ass_item_id, s_ass_comment
552: FROM Bom_Bill_Of_Materials bbm
553: WHERE bbm.Bill_Sequence_Id = X_Bill_Sequence_Id;
554:
555:
556: Bom_Business_Event_PKG.Raise_Bill_Event