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
invoice on hold report
Who is online
Users browsing this forum: No registered users and 1 guest