APPS.WIP_UTILITIES dependencies on DUAL

Line 167: from sys.dual;

163: if (inv_rec.transaction_interface_id is null) then
164: -- transaction interface id not assigned to mti, probably no lot/serial
165: -- generate one
166: select mtl_material_transactions_s.nextval into l_temp_id
167: from sys.dual;
168: update mtl_transactions_interface
169: set transaction_interface_id = l_temp_id
170: where rowid = inv_rec.rowid;
171: else

Line 191: from sys.dual;

187: if (inv_rec.transaction_temp_id is null) then
188: -- temp id not assigned to mmtt record (probably no lot/serial),
189: -- generate one
190: select mtl_material_transactions_s.nextval into l_temp_id
191: from sys.dual;
192: update mtl_material_transactions_temp
193: set transaction_temp_id = l_temp_id
194: where rowid = inv_rec.rowid;
195: else

Line 638: FROM dual

634: 'Lot Attributes',
635: p_org_id,
636: p_item_id)
637: INTO l_require_lot_attr
638: FROM dual
639: WHERE NOT EXISTS -- new lot
640: (SELECT 'X'
641: FROM mtl_lot_numbers mln
642: WHERE mln.organization_id = p_org_id