AUC_NOIA_RS_BDR

(SQL View)
 Index Back

NOIA Bidder

NOIA Bidder

SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.BIDDER_SETID , A.BIDDER_ID , A.BIDDER_TYPE , A.BIDDER_LOC , A.CNTCT_SEQ_NUM , A.ADDR_SEQ_NUM , A.AUC_NOIA_BID_RESP , A.AUC_LAST_NTFY_DTTM , A.AUC_SELECT , A.EMAILID , A.AUC_INVITATION_TYP , A.AUC_NOIA_VERSION FROM PS_AUC_NOIA_BIDDER A , PS_RESP_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION AND A.BIDDER_SETID = B.BIDDER_SETID AND A.BIDDER_ID = B.BIDDER_ID AND A.BIDDER_TYPE = B.BIDDER_TYPE AND B.AUC_BID_STATUS = 'P'

  • Parent record: AUC_NOIA_HDR

    • # 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 BIDDER_LOC Character(10) VARCHAR2(10) NOT NULL Bidder Location
    9 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
    10 ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
    11 AUC_NOIA_BID_RESP Character(1) VARCHAR2(1) NOT NULL Responded
    A=Yes
    D=No
    N=No
    12 AUC_LAST_NTFY_DTTM DateTime(26) TIMESTAMP Last Notified DateTime
    13 AUC_SELECT Character(1) VARCHAR2(1) NOT NULL Select
    N=No
    Y=Yes

    Default Value: N

    14 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    15 AUC_INVITATION_TYP Character(1) VARCHAR2(1) NOT NULL Invitation Type
    B=Both
    I=Invited
    P=Public
    16 AUC_NOIA_VERSION Number(3,0) SMALLINT NOT NULL NOIA Version