CNTRCT_EREQ_VW2

(SQL View)
Index Back

Contract Requisition Events


SELECT DISTINCT A.SETID , A.CNTRCT_ID , B.VENDOR_SETID , B.VENDOR_ID , V.VENDOR_NAME_SHORT FROM PS_CNTRCT_EVT_REQ A , PS_CNTRCT_HDR B , PS_VENDOR V , PS_REQ_LN_DISTRIB R WHERE A.EVENT_STATUS = 'A' AND A.SETID = B.SETID AND A.CNTRCT_ID = B.CNTRCT_ID AND B.VENDOR_SETID = V.SETID AND B.VENDOR_ID = V.VENDOR_ID AND R.REQ_ID = A.REQ_ID AND R.BUSINESS_UNIT = A.BUSINESS_UNIT AND R.LINE_NBR = A.LINE_NBR AND R.DISTRIB_LN_STATUS = 'O' AND B.CNTRCT_STATUS = 'A'

  • Related Language Record: CNTRCT_EREQ_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name