PV_RTVLN_UPD_VW

(SQL View)
Index Back

RTV (Supplier) Line


SELECT C.BUSINESS_UNIT , C.RTV_ID , C.ASSET_FLG , C.BUSINESS_UNIT_PO , C.BUSINESS_UNIT_RECV , C.DESCR254_MIXED , C.INV_FLG , C.INV_ITEM_ID , C.ITM_SETID , C.PO_ID , C.PRICE_PO , C.RECEIVER_ID , C.RECV_REQ , C.RETURN_ACTION , C.RETURN_REASON , C.RMA_ID , A.ENTERED_BY , A.ENTERED_DT , A.RETURN_SETID , A.RETURN_VENDOR , A.RTV_STATUS , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.BUYER_ID , B.NAME1 , COUNT(*) , SUM(C.QTY_LN_RETRN_VUOM) , SUM(C.QTY_LN_SHIP_VUOM) , ' ' FROM PS_RTV_HDR A , PS_VENDOR B , PS_RTV_LN C WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.RTV_ID = C.RTV_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT GROUP BY C.BUSINESS_UNIT , C.RTV_ID , C.ASSET_FLG , C.BUSINESS_UNIT_PO , C.BUSINESS_UNIT_RECV , C.DESCR254_MIXED , C.INV_FLG , C.INV_ITEM_ID ,C.ITM_SETID , C.PO_ID , C.PRICE_PO , C.RECEIVER_ID , C.RECV_REQ , C.RETURN_ACTION , C.RETURN_REASON , C.RMA_ID , A.ENTERED_BY , A.ENTERED_DT , A.RETURN_SETID , A.RETURN_VENDOR , A.RTV_STATUS , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC, A.BUYER_ID, B.NAME1, C.RTV_ID

  • Related Language Record: PV_RTVLN_UPD_LN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
    3 ASSET_FLG Character(1) VARCHAR2(1) NOT NULL Assets Applicable
    4 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
    5 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
    6 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    7 INV_FLG Character(1) VARCHAR2(1) NOT NULL Inventory Applicable
    N=No
    Y=Yes
    8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    9 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    10 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    11 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
    12 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
    13 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
    N=Optional
    X=Do Not
    Y=Required
    14 RETURN_ACTION Character(1) VARCHAR2(1) NOT NULL Return Action
    C=Credit
    E=Exchange
    R=Replace
    15 RETURN_REASON Character(10) VARCHAR2(10) NOT NULL Reason Code
    16 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
    17 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by
    18 ENTERED_DT Date(10) DATE Entered on
    19 RETURN_SETID Character(5) VARCHAR2(5) NOT NULL RTV (Supplier) SetID
    20 RETURN_VENDOR Character(10) VARCHAR2(10) NOT NULL Return to Vendor
    21 RTV_STATUS Character(1) VARCHAR2(1) NOT NULL Return Status
    C=Closed
    O=Open
    S=Shipped
    X=Cancelled
    22 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    23 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    24 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    25 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
    26 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    27 LINE_COUNT Number(5,0) INTEGER NOT NULL Line Count
    28 QTY_LN_RETRN_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Vndr Returned Qty
    29 QTY_LN_SHIP_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Supp Shipped Qty
    30 PV_NORECVROWS Character(100) VARCHAR2(100) NOT NULL No Receipt Rows