ERPstuff - Oracle EBS Community

Hi ,

I think there is no template registred for the data defination.
Check the is there template or not ? check is there data defination ..?

If above all is ok then..Check for options menu what is the output format for the CP while submitting.


Regards,
Kamlesh Nikhade.

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