DBA Data[Home] [Help]

APPS.WSH_ITM_EXPORT_SCREENING dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 213: FROM mtl_serial_numbers_temp mt , wsh_delivery_details wdd

209: CURSOR c_get_serial_num_range(c_transaction_temp_id IN NUMBER, c_delivery_detail_id IN NUMBER)
210: IS
211: SELECT wdd.delivery_detail_id,wdd.transaction_temp_id,mt.fm_serial_number,
212: mt.to_serial_number , to_number(mt.serial_prefix) quantity
213: FROM mtl_serial_numbers_temp mt , wsh_delivery_details wdd
214: WHERE mt.transaction_temp_id = c_transaction_temp_id
215: AND wdd.transaction_temp_id = mt.transaction_temp_id
216: AND wdd.delivery_detail_id = c_delivery_detail_id;
217: