APPS.ENG_DEFAULT_REVISED_ITEM dependencies on DUAL

Line 156: FROM DUAL;

152: BEGIN
153:
154: SELECT eng_revised_items_s.NEXTVAL
155: INTO l_revised_item_seq_id
156: FROM DUAL;
157:
158: RETURN l_revised_item_seq_id;
159:
160: EXCEPTION

Line 1142: cursor bill_seq_id is select bom_inventory_components_s.nextval from sys.dual;

1138: FUNCTION Initialize_Bill_Sequence_Id
1139: RETURN NUMBER
1140: IS
1141: l_bill_sequence_id NUMBER;
1142: cursor bill_seq_id is select bom_inventory_components_s.nextval from sys.dual;
1143: BEGIN
1144: open bill_seq_id;
1145: fetch bill_seq_id into l_bill_sequence_id;
1146: close bill_seq_id;

Line 1766: -- and the assembly item is model or optional or it is dual UOM contralled

1762: Error_Handler.Write_Debug('After Check if revision eff structure is existing...'||to_char(l_revEffStrc_exists)) ;
1763: END IF;
1764: -- Added check for OPM Convergence
1765: -- Bills shouldnt get created when the organization is a process enabled org
1766: -- and the assembly item is model or optional or it is dual UOM contralled
1767: -- then cannot create the bill
1768: IF (l_revEffStrc_exists = 2
1769: AND (l_Org_Details_Rec.process_enabled_flag = 'N'
1770: OR (l_Org_Details_Rec.process_enabled_flag = 'Y' AND l_Item_Details_Rec.bom_item_type NOT IN (1,2)))