DBA Data[Home] [Help]

APPS.BOM_REF_DESIG_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 509: FROM Bom_Bill_Of_Materials bbm, Bom_Inventory_Components bic, Mtl_System_Items_Kfv msi

505: SELECT bic.Bill_Sequence_Id, bbm.Organization_Id, bic.Component_Item_Id,
506: bic.Component_Remarks, msi.Concatenated_Segments
507: INTO l_Bill_Sequence_Id, l_Organization_Id, l_Component_Item_Id,
508: l_Component_Remarks, l_Component_Item_Name
509: FROM Bom_Bill_Of_Materials bbm, Bom_Inventory_Components bic, Mtl_System_Items_Kfv msi
510: WHERE bbm.Bill_Sequence_Id = bic.Bill_Sequence_Id
511: And msi.Inventory_Item_Id = bic.Component_Item_Id
512: And msi.Organization_Id = bbm.Organization_Id
513: And bic.Component_Sequence_Id = p_Component_Sequence_Id;