DBA Data[Home] [Help]

APPS.WIP_UTILITIES dependencies on DUAL

Line 177: from sys.dual;

173: -- transaction interface id not assigned to mti, probably no lot/serial
174: -- generate one
175:
176: select mtl_material_transactions_s.nextval into l_temp_id
177: from sys.dual;
178: update mtl_transactions_interface
179: set transaction_interface_id = l_temp_id
180: where rowid = inv_rec.rowid;
181: else

Line 223: from sys.dual;

219: if (inv_rec.transaction_temp_id is null) then
220: -- temp id not assigned to mmtt record (probably no lot/serial),
221: -- generate one
222: select mtl_material_transactions_s.nextval into l_temp_id
223: from sys.dual;
224: update mtl_material_transactions_temp
225: set transaction_temp_id = l_temp_id
226: where rowid = inv_rec.rowid;
227: else

Line 696: FROM dual

692: 'Lot Attributes',
693: p_org_id,
694: p_item_id)
695: INTO l_require_lot_attr
696: FROM dual
697: WHERE NOT EXISTS -- new lot
698: (SELECT 'X'
699: FROM mtl_lot_numbers mln
700: WHERE mln.organization_id = p_org_id