CNT_DST_SRH_LVW

(SQL View)
 Index Back

Distributor Cntrct Prmpt Lang

PO002 Manufacturer Contract. Distributor Contract Language View for Distributor Contract prompt on Manufacturer Contract Page.

SELECT DISTINCT A.SETID , A.CNTRCT_ID , SL.LANGUAGE_CD , SL.CNTRCT_STYLE_NAME , VL.VENDOR_NAME_SHORT , VL.NAME1 FROM PS_CNTRCT_HDR A , PS_VENDOR B , PS_CNTRCT_STYLE S , PS_CNTRCT_STL_LNG SL , PS_VENDOR_LANG VL WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.CNTRCT_STYLE = S.CNTRCT_STYLE AND B.SETID = VL.SETID AND B.VENDOR_ID = VL.VENDOR_ID AND S.CNTRCT_STYLE = SL.CNTRCT_STYLE AND VL.LANGUAGE_CD = SL.LANGUAGE_CD AND A.CNTRCT_STATUS = 'A' AND A.VERSION_STATUS = 'C' AND A.CNTRCT_PROC_OPT = 'DST' AND (A.CNTRCT_EXPIRE_DT IS NULL OR (A.CNTRCT_EXPIRE_DT IS NOT NULL AND A.CNTRCT_EXPIRE_DT >= %CurrentDateIn))

  • Related Language Record for CNTRCT_DST_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CNTRCT_ID_DST Character(25) VARCHAR2(25) NOT NULL Contract ID To
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Style
    5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1