CS_VENDOR_VW

(SQL View)
 Index Back

View of Active Suppliers


SELECT DISTINCT H.setid , H.VENDOR_SETID , H.vendor_id , V.vendor_name_short FROM PS_CS_DOC_HDR A , PS_CS_DOC_PO_KEYS B , PS_CNTRCT_HDR H , PS_VENDOR V WHERE A.CS_SOURCE_TRANS = '02' AND A.CS_IMPORT_CODE = '1' AND A.CS_DOC_BLD_STATUS = '1' AND B.CS_DOC_ID = A.CS_DOC_ID AND H.SETID = B.SETID AND H.CNTRCT_ID = B.CNTRCT_ID AND V.SETID = H.VENDOR_SETID AND V.VENDOR_ID = H.VENDOR_ID AND V.VENDOR_STATUS = 'A' AND V.VENDOR_PERSISTENCE <> 'S' AND EXISTS( SELECT 'X' FROM PS_CS_DOC_FILES F WHERE F.CS_DOC_ID = A.CS_DOC_ID AND F.CS_DOC_TYPE = '001')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name