invoice on hold report

[sunildutt_b]

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

[amitm_66]

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