ERPstuff - Oracle EBS Community

Hi friends,

can any one post me the sql code for this report (invoice on hold report)
the columns and tables are

holdtype---------------ap_holds_all
hold reason---------------ap_holds_all
vendor number---------------po_vendors
vendor name---------------po_vendors
invoice date---------------ap_invoices
invoice number---------------ap_invoices
created by------------------fnd_user
amount onhold
po line on hold
line detail part no
po no---------------po_vendors
invoice quantity---------------ap_invoices
po quantity--------------ap_invoices
received quantity

i am able to retrieve all columns but i am unable to retrieve these columns:

amount onhold
po line on hold
line detail part no
received quantity

can any one help me friends

thanks in advance

quantity received you can get from po distributions table

po line which is on hold you can get from ap_holds_all.line_location_id