PTLT_SCOMP_VW1

(SQL View)
 Index Back

Extract Setup Tasks

Join View on PTLT_TASK and PSPNLGRPDEFN

SELECT A.PTLT_TASK_CODE , B.DESCR FROM %Table(PTLT_TASK) A , %Table(PSPNLGRPDEFN) B WHERE A.PTLT_TASK_CODE = %Sql(PTLT_TASK_CODE, B.PNLGRPNAME(+), B.MARKET(+))

  • Related Language Record: PTLT_SCOMP_LVW1

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description