Page 1 of 1
Query to get receipt number from serial or lot num
Posted: Thu Mar 19, 2009 1:46 am
by anandsoni
Dear All ,
I have some serial numbers & Lot numbes of some items for which i need to get receipt number in our Inventory from backend . Kindly give me sql query for the same .
Regards,
Anand Soni
Posted: Thu Mar 19, 2009 2:38 am
by kamlesh3659
Hi Anand ,
You can try the following querry :-
select c.receipt_num from
mtl_serial_numbers am,
rcv_transactions b,
rcv_shipment_headers c
where am.LAST_TRANSACTION_ID=b.TRANSACTION_ID and
b.SHIPMENT_HEADER_ID=c.SHIPMENT_HEADER_ID
Regards,
Kamlesh Nikhade
Posted: Fri Mar 20, 2009 3:24 am
by anandsoni
Hi Kamlesh ,
above query not working .
Regards,
Anand
Posted: Wed Apr 08, 2009 6:47 am
by divakerp
Hi Anand,
The SQL provided by kamlesh should work.. Hope you might be working on the tool (SQL Plus or Toad) with userid other than APPS.
Try the below query with very small changes in Kamlesh Script.
select c.receipt_num from
apps.mtl_serial_numbers am,
apps.rcv_transactions b,
apps.rcv_shipment_headers c
where am.LAST_TRANSACTION_ID=b.TRANSACTION_ID and
b.SHIPMENT_HEADER_ID=c.SHIPMENT_HEADER_ID
Thanks
Diwaker Babu