query script output duplicate records
select DISTINCT
XPRG.GRN_NUMBER,
XPRG.OPERATING_UNIT,
XPRG.PO_NUM,
XPRG.RELEASE_NUM,
XPRG.PO_CREATION_DATE,
XPRG.PO_DESCRIPTION,
XPRG.ITEM_NUM,
XPRG.ITEM_DESC,
XPRG.UOM,
XPRG.PO_QTY,
XPRG.PO_ACC_QTY,
XPRG.DELIVERY_NOTE_QTY,
XPRG.DELIVERY_DATE,
(XPRG.DELIVERY_NOTE_QTY-XPRG.PO_ACC_QTY) PO_REJ_QTY,
(XPRG.PO_QTY-XPRG.PO_ACC_QTY) po_due_qty,
rsh.RECEIPT_NUM,
trunc(rsh.creation_date),
trunc(xprg.DELIVERY_DATE),
TRUNC(xprg.DELIVERY_DATE-rsh.creation_date) Aging,
rt.po_header_id,
pll.QUANTITY,
pll.QUANTITY_RECEIVED,
pll.QUANTITY-pll.QUANTITY_RECEIVED "Qty Due"
from
apps.rcv_transactions rt,