APPS.MTL_SERIAL_CHECK dependencies on DUAL

Line 42: | quantity of individual serial numbers which fall between them and

38: ===========================================================================*/
39: /*==========================================================================+
40: | TITLE: qtybtwn (user exit QTYBTWN)
41: | PURPOSE: Takes two alphanumeric serial numbers and returns both the
42: | quantity of individual serial numbers which fall between them and
43: | the alpha prefix of the first serial number.
44: |
45: | PARAMETERS:
46: | P_FROM_SERIAL_NUMBER and P_TO_SERIAL_NUMBER specify the range of

Line 432: INTO l_obj_seq_num FROM DUAL;

428: * into GEN_OBJECT_ID field : Object Genealogy
429: */
430:
431: SELECT MTL_GEN_OBJECT_ID_S.NEXTVAL
432: INTO l_obj_seq_num FROM DUAL;
433:
434:
435: IF NOT FND_API.to_Boolean(p_simulate) THEN
436: l_user_id := FND_GLOBAL.USER_ID ;