PTLT_SCOMP_LVW1

(SQL View)
 Index Back

Rel Lang vw for PTLT_SCOMP_VW1

Related Language view for PTLT_SCOMP_VW1

SELECT A.PTLT_TASK_CODE , A.LANGUAGE_CD , B.DESCR FROM %Table(PTLT_TASK_LANG) A , %Table(PSPNLGDEFNLANG) B WHERE A.PTLT_TASK_CODE = %Sql(PTLT_TASK_CODE, B.PNLGRPNAME(+), B.MARKET(+))

  • Related Language Record for PTLT_SCOMP_VW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTLT_TASK_CODE Character(30) VARCHAR2(30) NOT NULL Task Code

    Prompt Table: PTLT_PNLGRP_VW2

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description