[Home] [Help]
View: PJM_TASK_ATTR_USAGES_V
View Text
SELECT PTAU.ROWID
, PTAU.ASSIGNMENT_TYPE
, PTAU.ATTRIBUTE_CODE
, PTA.ATTRIBUTE_NAME
, PTAU.CREATION_DATE
, PTAU.CREATED_BY
, PTAU.LAST_UPDATE_DATE
, PTAU.LAST_UPDATED_BY
, PTAU.LAST_UPDATE_LOGIN
, PTAU.SEQUENCE_NUMBER
, PTAU.PROMPT
FROM PJM_TASK_ATTR_USAGES PTAU
, PJM_TASK_ATTRIBUTES PTA
WHERE PTAU.ASSIGNMENT_TYPE = PTA.ASSIGNMENT_TYPE
AND PTAU.ATTRIBUTE_CODE = PTA.ATTRIBUTE_CODE
Columns
Name |
ROW_ID |
ASSIGNMENT_TYPE |
ATTRIBUTE_CODE |
ATTRIBUTE_NAME |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
SEQUENCE_NUMBER |
PROMPT |