PTLT_CMPMENU_VW

index back

SELECT PS_PTLT_TASK.PTLT_TASK_CODE , PSMENUITEM.MENUNAME , COUNT(*) FROM PS_PTLT_TASK , PSMENUITEM WHERE PS_PTLT_TASK.PTLT_TASK_CODE = %Sql(PTLT_TASK_CODE,PSMENUITEM.PNLGRPNAME,PSMENUITEM.MARKET) AND EXISTS ( SELECT 'X' FROM PSPNLGRPDEFN WHERE PS_PTLT_TASK.PTLT_TASK_CODE = %Sql(PTLT_COMP_CODE) ) GROUP BY PS_PTLT_TASK.PTLT_TASK_CODE, PSMENUITEM.MENUNAME

PeopleSoft Field Name Field Type Column Type Description
PTLT_TASK_CODE Character(30) VARCHAR2(30) NOT NULL Task Code
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
COUNT_1 Number(3,0) SMALLINT NOT NULL Count Work Field
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19