APPS.WIP_EAMMTLPROC_PRIV dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 423: from mtl_serial_numbers_temp

419: --we have already checked the serial_control_code so a serial number must be in MSNT
420: if(p_compRec.lotControlCode = wip_constants.no_lot) then
421: select fm_serial_number
422: bulk collect into l_serialNumTbl
423: from mtl_serial_numbers_temp
424: where transaction_temp_id = p_compRec.txnTmpID;
425: else
426: select fm_serial_number
427: bulk collect into l_serialNumTbl

Line 428: from mtl_serial_numbers_temp

424: where transaction_temp_id = p_compRec.txnTmpID;
425: else
426: select fm_serial_number
427: bulk collect into l_serialNumTbl
428: from mtl_serial_numbers_temp
429: where transaction_temp_id = (select serial_transaction_temp_id
430: from mtl_transaction_lots_temp
431: where transaction_temp_id = p_compRec.txnTmpID);
432: end if;