PTLT_CMPTASKLVW(SQL View) |
Index Back |
---|
SELECT A.PTLT_TASK_CODE , A.LANGUAGE_CD FROM %Table(PTLT_TASK_LANG) A , %Table(PTLT_TASK) B WHERE A.PTLT_TASK_CODE = B.PTLT_TASK_CODE AND B.PTLT_TASK_TYPE = 'C' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PTLT_TASK_CODE | Character(30) | VARCHAR2(30) NOT NULL | Task Code |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |