[Home] [Help]
View: PJM_TASK_WIP_ACCT_CLASSES_V
View Text
SELECT P.ROWID
, P.ORGANIZATION_ID
, P.PROJECT_ID
, P.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_LOGIN
, P.WIP_ACCT_CLASS_CODE
, P.EAM_ACCT_CLASS_CODE
FROM PJM_TASK_WIP_ACCT_CLASSES P
, PA_TASKS T
WHERE T.TASK_ID = P.TASK_ID
Columns
Name |
ROW_ID |
ORGANIZATION_ID |
PROJECT_ID |
TASK_ID |
TASK_NUMBER |
TASK_NAME |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
WIP_ACCT_CLASS_CODE |
EAM_ACCT_CLASS_CODE |