SSF_SSTERMVWLNG

(SQL View)
 Index Back

Related Lang View

SSF_SSTERMVWLNG is the language record view related to SSF_SS_TERM_VW

SELECT DISTINCT A.STRM , A.LANGUAGE_CD , A.DESCR , A.DESCRSHORT FROM PS_SF_TERM_VWLNG A , PS_ITEM_SF B , PS_ISET_BU_DTL C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.ITEM_TERM = A.STRM AND B.SA_ID_TYPE = 'P'

  • Related Language Record for SSF_SS_TERM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description