Requisition

[nareshkutti]

in requisition form,i want to develop a query using
colums are:
Requisition num, Requisition type, Preparer, Status, Currency code, Total amount, Line num, Line type, Item, Category, Description, UOM, Quantity, Unit Price, Line amount, Destination type, Requestor, Inventory org, Sub inventory, Location, Distribution num, Charge a/c, Operation unit..

paramaeters to enter:
Requisition Num (Mandatory), operating unit name (OPtional), Preparer (OPtional)...

header tables :
po_requisition_headers_all ,
po_requisition_lines_all ,
po_req_distributions_all.....

join conditons:
.requisition_header_id is join condition btw header and line tables,
requisition_line _id is join condition btw iines and ditribution tables ,