PTLT_TASKOTHLVW

(SQL View)
 Index Back

SELECT A.PTLT_TASK_CODE , A.LANGUAGE_CD , A.PTLT_TASK_NAME , A.NAVIGATION , A.DESCR254_MIXED FROM %Table(PTLT_TASK_LANG) A , %Table(PTLT_TASK) B WHERE A.PTLT_TASK_CODE = B.PTLT_TASK_CODE AND B.PTLT_TASK_TYPE = 'O'

  • Related Language Record for PTLT_TASKOTH_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTLT_TASK_CODE Character(30) VARCHAR2(30) NOT NULL Task Code
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 PTLT_TASK_NAME Character(30) VARCHAR2(30) NOT NULL Task Name
    4 NAVIGATION Character(254) VARCHAR2(254) NOT NULL Navigation
    5 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description