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