APPS.BOM_BILL_OF_MATLS_PKG dependencies on BOM_INVENTORY_COMPONENTS

Line 50: FROM bom_inventory_components

46: Where mif.inventory_item_id = P_Base_Item_Id
47: And mif.organization_id = P_Org_Id;
48: CURSOR GetItemSeq IS
49: SELECT nvl(max(item_num), 0) + P_Item_Seq_Increment default_seq
50: FROM bom_inventory_components
51: WHERE bill_sequence_id = P_Bill_Sequence_Id;
52: No_Revision_Found EXCEPTION;
53: Pragma exception_init(no_revision_found, -20001);
54: BEGIN

Line 176: CURSOR C2 IS SELECT bom_inventory_components_s.nextval FROM sys.dual;

172: l_preferred_flag Varchar2(1);
173: x_err_text varchar2(2000);
174: CURSOR C IS SELECT rowid FROM BOM_BILL_OF_MATERIALS
175: WHERE bill_sequence_id = X_Bill_Sequence_Id;
176: CURSOR C2 IS SELECT bom_inventory_components_s.nextval FROM sys.dual;
177: BEGIN
178: if (X_Bill_Sequence_Id is NULL) then
179: OPEN C2;
180: FETCH C2 INTO X_Bill_Sequence_Id;