Query to get receipt number from serial or lot num

[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

[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

[anandsoni]

Hi Kamlesh ,

above query not working .

Regards,

Anand

[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