Procurement - EBS (MOSC)

MOSC Banner

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center