IN_TM_DFN_RLVW

(SQL View)
Index Back

SELECT A.IN_TM_CODE , A.IN_TM_CATEGORY , A.IN_TM_SUB_CATEGORY , B.LANGUAGE_CD , B.DESCR FROM PS_IN_TM_DEFN_SCAT A , PS_IN_TM_DEFS_LANG B WHERE A.SYSTEM_DATA_FLG = 'N' AND A.IN_TM_CODE = B.IN_TM_CODE AND A.IN_TM_CATEGORY = B.IN_TM_CATEGORY AND A.IN_TM_SUB_CATEGORY = B.IN_TM_SUB_CATEGORY

  • Related Language Record for IN_TM_DFN_SCTVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IN_TM_CODE Character(15) VARCHAR2(15) NOT NULL Template Code
    2 IN_TM_CATEGORY Character(15) VARCHAR2(15) NOT NULL Template Category
    3 IN_TM_SUB_CATEGORY Character(15) VARCHAR2(15) NOT NULL Template Subcategory
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description