CS_PUR_VNDRLVW

(SQL View)
 Index Back

scmt - Purchasing - supplier v

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 doc id/po that is tied to a document

SELECT K.CS_DOC_ID , L.LANGUAGE_CD , V.NAME1 , V.NAME2 FROM PS_CS_DOC_PUR_KEYS K , PS_PO_HDR H , PS_VENDOR V , PS_VENDOR_LANG L WHERE K.BUSINESS_UNIT = H.BUSINESS_UNIT AND K.PO_ID = H.PO_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_PUR_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