APPS.BOM_REF_DESIG_PKG dependencies on BOM_INVENTORY_COMPONENTS

Line 46: FROM Bom_Inventory_Components bic,

42: --* Checking whether reference designator record exists in implemented
43: --* or unimplemented status. If the reference designator is being added
44: --* for the first time, furthur validations will be ignored.
45: SELECT Count(1) INTO rec_exist
46: FROM Bom_Inventory_Components bic,
47: bom_reference_designators brd
48: WHERE --Nvl(bic.Old_Component_Sequence_Id,bic.Component_Sequence_Id) = X_Old_Component_Sequence_Id
49: --commented out previous line and added line below for bug 8719529
50: --Removed nvl function to improve performance. Both lines have same logic

Line 81: FROM Bom_Inventory_Components bic,

77:
78: SELECT Acd_Type INTO rec_exist
79: FROM Bom_Reference_Designators
80: WHERE Component_Sequence_Id = ( SELECT Max(bic.Component_Sequence_Id)
81: FROM Bom_Inventory_Components bic,
82: bom_reference_designators brd
83: WHERE bic.Old_Component_Sequence_Id = X_Old_Component_Sequence_Id
84: AND bic.Change_Notice <> X_Change_Notice
85: AND bic.Implementation_Date IS NULL

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;