APPS.WSH_ITM_EXPORT_SCREENING dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 226: FROM mtl_serial_numbers_temp mt

222: CURSOR c_get_serial_num_range(c_transaction_temp_id IN NUMBER, c_delivery_detail_id IN NUMBER)
223: IS
224: SELECT c_delivery_detail_id,c_transaction_temp_id,mt.fm_serial_number,
225: nvl(mt.to_serial_number, mt.fm_serial_number) , to_number(mt.serial_prefix) quantity
226: FROM mtl_serial_numbers_temp mt
227: WHERE mt.transaction_temp_id = c_transaction_temp_id;
228:
229: --
230: --Bug 12727459 : Added nvl condition on to_serial_number.