APPS.BOM_DEFAULT_BOM_COMPONENT dependencies on BOM_INVENTORY_COMPONENTS

Line 64: SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence

60: FUNCTION Get_Component_Sequence
61: RETURN NUMBER
62: IS
63: CURSOR Comp_Seq IS
64: SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence
65: FROM SYS.DUAL;
66: BEGIN
67:
68: FOR c_Comp_Seq IN Comp_Seq LOOP

Line 82: FROM BOM_Inventory_Components

78: RETURN VARCHAR2
79: IS
80: CURSOR c_To_End_Item_Number IS
81: SELECT To_End_Item_Unit_Number
82: FROM BOM_Inventory_Components
83: WHERE component_sequence_id =
84: g_rev_comp_unexp_rec.old_component_sequence_id;
85: BEGIN
86: FOR To_End_Item_Number IN c_To_End_Item_Number

Line 108: FROM bom_inventory_components

104: IS
105: p_Item_Seq_Increment NUMBER;
106: CURSOR GetItemSeq IS
107: SELECT nvl(max(item_num), 0) + P_Item_Seq_Increment default_seq
108: FROM bom_inventory_components
109: WHERE bill_sequence_id = g_rev_Comp_Unexp_rec.Bill_Sequence_Id;
110: BEGIN
111: p_Item_Seq_Increment :=
112: fnd_profile.value('BOM:ITEM_SEQUENCE_INCREMENT');

Line 431: SELECT BOM_INVENTORY_COMPONENTS_S.NextVal

427: CLOSE c_CheckForNew;
428:
429: IF l_Bill_Sequence_Id IS NULL
430: THEN
431: SELECT BOM_INVENTORY_COMPONENTS_S.NextVal
432: INTO l_Bill_Sequence_Id
433: FROM SYS.DUAL;
434:
435: RETURN l_Bill_Sequence_id;