Hello everyone, am using Oracle Application R12,
I need the following details for the all purchased item,
how to get the item_id,item_name,vendor_name,ordered_quantity,rec eived_quantity,
returned_quantity.
Thank you.

Hi Mahendra,
I have checked the table there is no Retun to Vendor details for the particular Po_header_id,I need all the item details even if it is not returned,so the rcv.quantity (returned_quantity) will be 0 for the item which are not returned. Right?So I need to get the all item details which are returned and as well as not returned. Kindly tell me How to modify the code?
Thank you.