eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOT_API_PUB dependencies on DUAL

Line 452: FROM DUAL;

448:
449: IF ( l_shelf_life_code = 2 ) THEN
450: SELECT SYSDATE + l_shelf_life_days
451: INTO p_expiration_date
452: FROM DUAL;
453: ELSIF ( l_shelf_life_code = 4 ) THEN
454: fnd_message.set_name ('INV' , 'INV_LOT_EXPREQD' );
455: fnd_msg_pub.ADD;
456: x_return_status := fnd_api.g_ret_sts_error;

Line 467: FROM DUAL;

463: END IF;
464:
465: SELECT mtl_gen_object_id_s.NEXTVAL
466: INTO x_object_id
467: FROM DUAL;
468:
469: populateattributescolumn ( );
470: IF (l_debug = 1) THEN
471: inv_pick_wave_pick_confirm_pub.tracelog ( 'After calling populateattributesColumn' , 'INV_LOT_API_PUB');

Line 3331: FROM sys.DUAL;

3327:
3328: -- get next org level lot number
3329: SELECT TO_CHAR ( mtl_lot_numeric_suffix_s.NEXTVAL )
3330: INTO l_lot_suffix
3331: FROM sys.DUAL;
3332: IF (l_debug =1 ) THEN
3333: print_debug('lot prefix is ' || l_lot_prefix || 'suffix is ' || l_lot_suffix,9);
3334: END IF;
3335: -- find lengths