APPS.BOM_DEFAULT_BOM_COMPONENT dependencies on BOM_INVENTORY_COMPONENTS

Line 136: SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence

132: FUNCTION Get_Component_Sequence
133: RETURN NUMBER
134: IS
135: CURSOR Comp_Seq IS
136: SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence
137: FROM SYS.DUAL;
138: BEGIN
139:
140: FOR c_Comp_Seq IN Comp_Seq LOOP

Line 154: FROM BOM_Inventory_Components

150: RETURN VARCHAR2
151: IS
152: CURSOR c_To_End_Item_Number IS
153: SELECT To_End_Item_Unit_Number
154: FROM BOM_Inventory_Components
155: WHERE component_sequence_id =
156: g_rev_comp_unexp_rec.old_component_sequence_id;
157: BEGIN
158: FOR To_End_Item_Number IN c_To_End_Item_Number

Line 180: FROM bom_inventory_components

176: IS
177: p_Item_Seq_Increment NUMBER;
178: CURSOR GetItemSeq IS
179: SELECT nvl(max(item_num), 0) + P_Item_Seq_Increment default_seq
180: FROM bom_inventory_components
181: WHERE bill_sequence_id = g_rev_Comp_Unexp_rec.Bill_Sequence_Id;
182: BEGIN
183: p_Item_Seq_Increment :=
184: fnd_profile.value('BOM:ITEM_SEQUENCE_INCREMENT');

Line 506: SELECT BOM_INVENTORY_COMPONENTS_S.NextVal

502: CLOSE c_CheckForNew;
503:
504: IF l_Bill_Sequence_Id IS NULL
505: THEN
506: SELECT BOM_INVENTORY_COMPONENTS_S.NextVal
507: INTO l_Bill_Sequence_Id
508: FROM SYS.DUAL;
509:
510: RETURN l_Bill_Sequence_id;