SS_BIDDER_SVW

(SQL View)
 Index Back

Sourcing Bidder


SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE ,B.NAME1 %Concat ' ' %Concat B.NAME2 %Concat ' ' %Concat B.VENDOR_NAME_SHORT ,B.NAME1 FROM PS_AUC_DISP_HDR A , PS_VENDOR B WHERE A.BIDDER_SETID = B.SETID AND A.BIDDER_ID = B.VENDOR_ID AND B.VENDOR_STATUS = 'A' AND B.VNDR_STATUS_PO = 'Y' AND B.VENDOR_PERSISTENCE <> 'S' AND A.BIDDER_TYPE = 'V' UNION SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , B.AUC_COMPANY_NAME , '' FROM PS_AUC_DISP_HDR A , PS_AUC_BIDDER_VW B WHERE A.BIDDER_SETID = B.SETID AND A.BIDDER_ID = B.BIDDER_ID AND A.BIDDER_LOC = B.BIDDER_LOC AND A.BIDDER_TYPE = 'B'

  • Related Language Record: SS_BIDDER_SLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
    3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
    4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
    5 BIDDER_SETID Character(5) VARCHAR2(5) NOT NULL Bidder Setid
    6 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
    7 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
    B=Bidder
    C=Customer
    P=Public
    U=Uploaded
    V=Supplier
    8 SES_BIDDER_NAME Character(100) VARCHAR2(100) NOT NULL All Vendor Names
    9 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1