DBA Data[Home] [Help]

APPS.INV_LOT_API_PUB dependencies on MTL_LOT_NUMERIC_SUFFIX_S

Line 3329: SELECT TO_CHAR ( mtl_lot_numeric_suffix_s.NEXTVAL )

3325: -- set lot prefix
3326: l_lot_prefix := lot_prefix;
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);