PURCHASE REQUISITION WITHOUT PO SELECT prh.segment1 "PR NUM", TRUNC (prh.creation_date) "CREATED ON", TRUNC (prl.creation_date) "Line Creation Date", prl.line_num "Seq #", msi.segment1 "Item Num", prl.item_description "Description", prl.quantity "Qty", TRUNC (prl.need_by_date) "Required By", ppf1.full_name "REQUESTOR", ppf2.agent_name "BUYER" FROM po.po_requisition_headers_all prh, po.po_requisition_lines_all prl, apps.per_people_f ppf1, ( SELECT DISTINCT agent_id, agent_name FROM apps.po_agents_v) ...
PO details query in oracle apps R12 SELECT HOU.SHORT_CODE OU, PHA.CREATION_DATE PO_CREATION_DATE, PHA.APPROVED_DATE PO_APPROVED_DATE, NVL(PRH.INTERFACE_SOURCE_CODE, PRH.APPS_SOURCE_CODE) REQUISITION_SOURCE, ...
