SELECT R.SEGMENT1 "Req number",
  Rl.Line_Num "Req line",
  (SELECT DISTINCT Description
  FROM Apps.Mtl_Categories
  WHERE Category_Id=Rl.Category_Id
  ) "Req Line Category Description",
  (SELECT DISTINCT segment1
    ||'.'
    ||segment2
  FROM Apps.Mtl_Categories
  WHERE Category_Id=rl.category_id
  ) "Requisition Line Category" ,
  TO_CHAR(R.APPROVED_DATE,'dd-MON-RR HH24:MI:SS') "Req Approved Date",
  P.SEGMENT1 "PO Number",
  p.revision_num "Revision number",
  PL.LINE_NUM "PO Line",
  TO_CHAR(P.CREATION_DATE,'DD-MON-RRRR HH24:MI:SS') "PO Created Date",
  PL.quantity "Quantity",
  pl.unit_price "Item_Price",
  (PL.quantity*pl.unit_price) "Amount",
  pagen.agent_name "PO buyer",
  p.attribute10 "Contract Type",
  (SELECT NVL(short_code,name)
  FROM apps.hr_operating_units
  WHERE organization_id = p.org_id
  ) org_code, p.org_id
FROM APPS.PO_HEADERS_ALL P,
  apps.po_lines_all pl,
  APPS.PO_DISTRIBUTIONS_ALL D,
  apps.po_agents_v pagen,
  apps.po_req_distributions_all rd,
  apps.po_requisition_lines_all rl,
  apps.po_requisition_headers_all r
WHERE P.PO_HEADER_ID         = D.PO_HEADER_ID
AND P.PO_HEADER_ID           = PL.PO_HEADER_ID
AND PL.PO_LINE_ID            = D.PO_LINE_ID
AND pagen.agent_id           = p.agent_id
AND d.req_distribution_id    = rd.distribution_id
AND rd.requisition_line_id   = rl.requisition_line_id
AND RL.REQUISITION_HEADER_ID = R.REQUISITION_HEADER_ID
AND P.Org_Id                IN (82,83, 367, 370, 627, 628, 629, 388, 630, 395, 376, 396, 382,393,378,828,
    393,
    382,
    287,147,127 )
AND TRUNC(P.Creation_Date)  >='01-MAR-2019'
AND TRUNC(P.Creation_DATE)  <='31-MAR-2019'
  /*GROUP BY r.segment1,
  r.creation_date,
  r.authorization_status,
  p.segment1,
  p.creation_Date,
  R.APPROVED_DATE,
  P.ORG_ID,
  RL.LINE_NUM,
  PL.LINE_NUM,
  pagen.agent_name
  */
ORDER BY p.org_id,
    TO_CHAR(P.CREATION_DATE,'DD-MON-RRRR HH24:MI:SS'),  
  P.Segment1,
  Pl.Line_Num