EM_CATEG_LNG_VW

(SQL View)
 Index Back

Category Desc Lang View

Category Description Language View

SELECT A.SETID , A.CATEGORY_TYPE , A.CATEGORY_ID , L.LANGUAGE_CD , L.DESCR60 FROM PS_ITM_CAT_TBL A , PS_ITM_CAT_TBL_LNG L WHERE A.SETID = L.SETID AND A.CATEGORY_TYPE = L.CATEGORY_TYPE AND A.CATEGORY_ID = L.CATEGORY_ID AND A.EFFDT = L.EFFDT AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ITM_CAT_TBL A1 WHERE A1.SETID = A.SETID AND A1.CATEGORY_TYPE = A.CATEGORY_TYPE AND A1.CATEGORY_ID = A.CATEGORY_ID AND A1.EFFDT <= %CurrentDateIn)

  • Related Language Record for EM_CATEGORY_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CATEGORY_TYPE Character(3) VARCHAR2(3) NOT NULL Category Type
    PSF=User Def
    UNS=UN/SPSC

    Default Value: INSTALLATION_PO.CATEGORY_TYPE

    3 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description