APPS.WMS_ASN_LOT_ATT dependencies on DUAL

Line 19: FROM dual;

15:
16:
17: SELECT fnd_profile.value('INV_DEBUG_TRACE')
18: INTO l_trace_on
19: FROM dual;
20:
21: IF l_trace_on = 1 THEN
22: FND_FILE.put_line(FND_FILE.LOG, 'WMS_ASN_LOT_ATT : ' || p_err_msg);
23: END IF;

Line 449: select mtl_gen_object_id_s.nextval into l_object_id from dual;

445: END IF;
446:
447: --Get The Values for Lot Related Attributes
448:
449: select mtl_gen_object_id_s.nextval into l_object_id from dual;
450:
451: populatelotattributescolumn;
452:
453: l_progress := '30';

Line 599: FROM DUAL;

595:
596: if(l_shelf_life_code = 2) then
597: SELECT SYSDATE + l_shelf_life_days
598: INTO l_expiration_date
599: FROM DUAL;
600: elsif(l_shelf_life_code = 4) then
601: fnd_message.set_name('INV','INV_LOT_EXPREQD');
602: fnd_msg_pub.add;
603: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1490: select mtl_gen_object_id_s.nextval into x_object_id from dual;

1486: IF (l_debug = 1) THEN
1487: print_debug('At Step = '|| l_progress,4);
1488: END IF;
1489:
1490: select mtl_gen_object_id_s.nextval into x_object_id from dual;
1491:
1492: l_progress := '30';
1493: IF (l_debug = 1) THEN
1494: print_debug('At Step = '|| l_progress,4);