SCC_TM_INATSKVW

(SQL View)
 Index Back

SELECT DISTINCT D.OPRID , A.SCC_TM_LIST_ID , A.SCC_TM_LABEL , A.PORTAL_NAME ,A.SCC_TM_PARENT_TMPL , ITML.SCC_TM_DUE_DATE , A.LAST_UPDATE_DTTM FROM PS_SCC_TM_PTAILIST A , PS_SCC_TM_CONFIG B , PSOPRDEFN D , PS_SCC_TM_PTAIITEM ITML WHERE A.SCC_TM_PARENT_TMPL = B.SCC_TM_TASK_ID AND A.SCC_TM_IS_TMPL='N' AND A.SCC_TM_LIST_STATUS ='CP' AND A.SCC_TM_LIST_ID = ITML.SCC_TM_LIST_ID AND ITML.SCC_TM_PTAI_SEQ = ( SELECT MAX(ITM1.SCC_TM_PTAI_SEQ) FROM PS_SCC_TM_PTAIITEM ITM1 WHERE A.SCC_TM_LIST_ID = ITM1.SCC_TM_LIST_ID ) AND (EXISTS ( SELECT 'X' FROM PS_SCC_TM_PTAILPRV F WHERE F.SCC_TM_LIST_ID = A.SCC_TM_LIST_ID AND EXISTS ( SELECT 'X' FROM PSROLEUSER X WHERE X.ROLEUSER = D.OPRID AND ((F.SCC_TM_PTAIMBRTYPE = 'USER' AND F.SCC_TM_PTAIMBRNAME = X.ROLEUSER) OR (F.SCC_TM_PTAIMBRTYPE = 'ROLE' AND F.SCC_TM_PTAIMBRNAME = X.ROLENAME))))) AND EXISTS ( SELECT 'X' FROM PS_SCC_TM_PTAICNTX cntx WHERE cntx.SCC_TM_LIST_ID =A.SCC_TM_LIST_ID AND cntx.SCC_TM_CTX_KEY='Y' AND cntx.FIELDNAME ='EMPLID' AND %Upper(cntx.SCC_TM_KEY_VALUE) = D.EMPLID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 SCC_TM_LIST_ID Character(31) VARCHAR2(31) NOT NULL Instance ID
3 SCC_TM_LABEL Character(100) VARCHAR2(100) NOT NULL Title
4 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

Prompt Table: PSPRDMDEFN

5 SCC_TM_PARENT_TMPL Character(31) VARCHAR2(31) NOT NULL Parent Template ID
6 SCC_TM_DUE_DATE Date(10) DATE Due Date
7 SCC_TM_LASTUPDDTTM DateTime(26) TIMESTAMP Last Updated