CS_CNT_VNDRLVW

(SQL View)
 Index Back

Contract - Supplier vw

Date Initials Issue Description ========================================== 05/2007 CEL F-AHAYT-748L7 Rel Lang view to use within SCMT to get the supplier information for a given contract that is tied to a document

SELECT K.CS_DOC_ID , L.LANGUAGE_CD , L.NAME1 , L.NAME2 FROM PS_CS_DOC_PO_KEYS K ,PS_CNTRCT_HDR H , PS_VENDOR V , PS_VENDOR_LANG L WHERE K.SETID = H.SETID AND K.CNTRCT_ID = H.CNTRCT_ID AND V.SETID = H.VENDOR_SETID AND V.VENDOR_ID = H.VENDOR_ID AND V.SETID = L.SETID AND V.VENDOR_ID = L.VENDOR_ID

  • Related Language Record for CS_CNT_VNDR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    4 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2