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 563: FROM DUAL;

559:
560: IF ( l_shelf_life_code = 2 ) THEN
561: SELECT SYSDATE + l_shelf_life_days
562: INTO p_expiration_date
563: FROM DUAL;
564: ELSIF ( l_shelf_life_code = 4 ) THEN
565: fnd_message.set_name ('INV' , 'INV_LOT_EXPREQD' );
566: fnd_msg_pub.ADD;
567: x_return_status := fnd_api.g_ret_sts_error;

Line 578: FROM DUAL;

574: END IF;
575:
576: SELECT mtl_gen_object_id_s.NEXTVAL
577: INTO x_object_id
578: FROM DUAL;
579:
580: populateattributescolumn ( );
581: IF (l_debug = 1) THEN
582: inv_pick_wave_pick_confirm_pub.tracelog ( 'After calling populateattributesColumn' , 'INV_LOT_API_PUB');

Line 3490: FROM sys.DUAL;

3486:
3487: -- get next org level lot number
3488: SELECT TO_CHAR ( mtl_lot_numeric_suffix_s.NEXTVAL )
3489: INTO l_lot_suffix
3490: FROM sys.DUAL;
3491: IF (l_debug =1 ) THEN
3492: print_debug('lot prefix is ' || l_lot_prefix || 'suffix is ' || l_lot_suffix,9);
3493: END IF;
3494: -- find lengths

Line 11234: FROM FND_DUAL;

11230:
11231: CURSOR GET_CONV_SEQ
11232: IS
11233: SELECT MTL_CONVERSION_ID_S.NEXTVAL
11234: FROM FND_DUAL;
11235:
11236: BEGIN
11237: --IF (l_debug = 1) THEN
11238: inv_log_util.trace('create_lot_UOM_conv_orgtxf: start ', g_pkg_name, 9);