DBA Data[Home] [Help]

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 560: FROM Bom_Bill_Of_Materials bbm

556: -- Raising Business event
557:
558: SELECT bbm.Organization_Id, bbm.alternate_bom_designator, bbm.assembly_item_id, bbm.specific_assembly_comment
559: INTO org_id, alt_bom_code, ass_item_id, s_ass_comment
560: FROM Bom_Bill_Of_Materials bbm
561: WHERE bbm.Bill_Sequence_Id = X_Bill_Sequence_Id;
562:
563:
564: Bom_Business_Event_PKG.Raise_Bill_Event