DBA Data[Home] [Help]

APPS.WIP_EAMMTLPROC_PRIV dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 431: from mtl_serial_numbers_temp

427: --we have already checked the serial_control_code so a serial number must be in MSNT
428: if(p_compRec.lotControlCode = wip_constants.no_lot) then
429: select fm_serial_number
430: bulk collect into l_serialNumTbl
431: from mtl_serial_numbers_temp
432: where transaction_temp_id = p_compRec.txnTmpID;
433:
434: select to_serial_number
435: bulk collect into l_to_serialNumTbl

Line 436: from mtl_serial_numbers_temp

432: where transaction_temp_id = p_compRec.txnTmpID;
433:
434: select to_serial_number
435: bulk collect into l_to_serialNumTbl
436: from mtl_serial_numbers_temp
437: where transaction_temp_id = p_compRec.txnTmpID; --bug 10262178
438:
439: else
440: select fm_serial_number

Line 442: from mtl_serial_numbers_temp

438:
439: else
440: select fm_serial_number
441: bulk collect into l_serialNumTbl
442: from mtl_serial_numbers_temp
443: where transaction_temp_id = (select serial_transaction_temp_id
444: from mtl_transaction_lots_temp
445: where transaction_temp_id = p_compRec.txnTmpID);
446:

Line 449: from mtl_serial_numbers_temp

445: where transaction_temp_id = p_compRec.txnTmpID);
446:
447: select to_serial_number
448: bulk collect into l_to_serialNumTbl
449: from mtl_serial_numbers_temp
450: where transaction_temp_id = (select serial_transaction_temp_id
451: from mtl_transaction_lots_temp
452: where transaction_temp_id = p_compRec.txnTmpID); --bug 10262178
453: