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 NameField TypeColumn TypeDescription
PTLT_TASK_CODECharacter(30)VARCHAR2(30) NOT NULLTask Code
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).
COUNT_1Number(3,0)SMALLINT NOT NULLCount Work Field
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19