DBA Data[Home] [Help]

APPS.WMA_COMPLETION dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 145: from mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

141:
142: if(cmpRecord.item_lot_control_code = wip_constants.lot) then
143: select fm_serial_number
144: into l_serialNum
145: from mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
146: where mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
147: and mtlt.transaction_temp_id = cmpRecord.transaction_interface_id;
148: else
149: select fm_serial_number