APPS.ENG_DEFAULT_REV_COMPONENT dependencies on BOM_INVENTORY_COMPONENTS

Line 33: SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence

29: FUNCTION Get_Component_Sequence
30: RETURN NUMBER
31: IS
32: CURSOR Comp_Seq IS
33: SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence
34: FROM SYS.DUAL;
35: BEGIN
36:
37: FOR c_Comp_Seq IN Comp_Seq LOOP

Line 51: FROM BOM_Inventory_Components

47: RETURN VARCHAR2
48: IS
49: CURSOR c_To_End_Item_Number IS
50: SELECT To_End_Item_Unit_Number
51: FROM BOM_Inventory_Components
52: WHERE component_sequence_id =
53: g_rev_comp_unexp_rec.old_component_sequence_id;
54: BEGIN
55: FOR To_End_Item_Number IN c_To_End_Item_Number

Line 76: FROM bom_inventory_components

72: IS
73: p_Item_Seq_Increment NUMBER;
74: CURSOR GetItemSeq IS
75: SELECT nvl(max(item_num), 0) + P_Item_Seq_Increment default_seq
76: FROM bom_inventory_components
77: WHERE bill_sequence_id = g_rev_Comp_Unexp_rec.Bill_Sequence_Id;
78: BEGIN
79: p_Item_Seq_Increment:=fnd_profile.value('BOM:ITEM_SEQUENCE_INCREMENT');
80:

Line 341: SELECT BOM_INVENTORY_COMPONENTS_S.NextVal

337: CLOSE c_CheckForNew;
338:
339: IF l_Bill_Sequence_Id IS NULL
340: THEN
341: SELECT BOM_INVENTORY_COMPONENTS_S.NextVal
342: INTO l_Bill_Sequence_Id
343: FROM SYS.DUAL;
344:
345: RETURN l_Bill_Sequence_id;