PTLT_SCOMP_VW1

Platform	View Text
Default	No Text
DB2	SELECT A.PTLT_TASK_CODE , B.DESCR FROM %Table(PTLT_TASK) A LEFT OUTER JOIN %Table(PSPNLGRPDEFN) B ON A.PTLT_TASK_CODE = (%Sql(PTLT_TASK_CODE, B.PNLGRPNAME, B.MARKET))
Oracle	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(+))
Informix	SELECT A.PTLT_TASK_CODE , B.DESCR FROM %Table(PTLT_TASK) A , OUTER %Table(PSPNLGRPDEFN) B WHERE A.PTLT_TASK_CODE = (%Sql(PTLT_TASK_CODE, B.PNLGRPNAME, B.MARKET))
DB2/UNIX	SELECT A.PTLT_TASK_CODE , B.DESCR FROM %Table(PTLT_TASK) A LEFT OUTER JOIN %Table(PSPNLGRPDEFN) B ON A.PTLT_TASK_CODE = (%Sql(PTLT_TASK_CODE, B.PNLGRPNAME, B.MARKET))
Sybase	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))
Microsoft	SELECT X.PTLT_TASK_CODE , Y.DESCR FROM %Table(PTLT_TASK) X LEFT OUTER JOIN %Table(PSPNLGRPDEFN) Y ON X.PTLT_TASK_CODE = (%Sql(PTLT_TASK_CODE, Y.PNLGRPNAME, Y.MARKET))

PeopleSoft Field Name	Description
PTLT_TASK_CODE	Task Code Prompt Table: PTLT_PNLGRP_VW2
DESCR	Description

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010