[Home] [Help]
View: PA_SST_VIEW_PROJECTS_TASKS_V
| Product: | PA - Projects |
|---|
| Description: | For View Projects and Tasks function in SST |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DISTINCT OP.PROJECT_NUMBER
, OP.PROJECT_NAME
, OP.PROJECT_ID
, OP.START_DATE
, OP.COMPLETION_DATE
, OP.CARRYING_OUT_ORGANIZATION_ID
, OT.TASK_NUMBER
, OT.TASK_NAME
, OT.TASK_ID
, OT.BILLABLE_FLAG
, OT.START_DATE
, OT.COMPLETION_DATE
, OT.CHARGEABLE_FLAG
FROM PA_ONLINE_PROJECTS_V OP
, PA_ONLINE_TASKS_V OT
WHERE OP.PROJECT_ID = OT.PROJECT_ID
Columns
| Name |
| PROJECT_NUMBER |
| PROJECT_NAME |
| PROJECT_ID |
| PROJECT_START_DATE |
| PROJECT_COMPLETION_DATE |
| CARRYING_OUT_ORGANIZATION_ID |
| TASK_NUMBER |
| TASK_NAME |
| TASK_ID |
| BILLABLE_FLAG |
| TASK_START_DATE |
| TASK_COMPLETION_DATE |
| CHARGEABLE_FLAG |