This content has been marked as final. Show 2 replies
Try following query
From wsh_serial_NUMBERS wsn,
Where wsn.delivery_detail_id = wdd.delivery_detail_id
And &serial between wsn.fm_serial_number
and nvl(wsn.ti_serial_number, wsn.fm_serial_number)
thanks you for your reply.
its working but i am not able to see the required item serail number.
Bit confused its their in mtl_serial_number but its not their in sales order.
How is it possible.
In mtl_serial_number its current_status is '4'
Can you please hlep me.