[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 |