Skip to content
[Home] [Help]
View: PJM_TASK_ATTR_USAGES
View Text
SELECT B.ASSIGNMENT_TYPE
, B.ASSIGNMENT_TYPE
, B.ATTRIBUTE_CODE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.SEQUENCE_NUMBER
, T.PROMPT
FROM PJM_TASK_ATTR_USAGES_TL T
, PJM_TASK_ATTR_USAGES_B B
WHERE B.ASSIGNMENT_TYPE = T.ASSIGNMENT_TYPE
AND B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
AND T.LANGUAGE = USERENV('LANG')
Columns
| Name |
| ROW_ID |
| ASSIGNMENT_TYPE |
| ATTRIBUTE_CODE |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_LOGIN |
| SEQUENCE_NUMBER |
| PROMPT |
APPS.PJM_TASK_ATTR_USAGES