[Home] [Help]
View: PJM_TASKS_V
Product: | PJM - Project Manufacturing |
Description: | Tasks view |
Implementation/DBA Data: |
APPS.PJM_TASKS_V
|
View Text
SELECT T.PROJECT_ID
, PJM_PROJECT.ALL_PROJ_IDTONUM(T.PROJECT_ID)
, PJM_PROJECT.ALL_PROJ_IDTONAME(T.PROJECT_ID)
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.WBS_SORT_ORDER
, T.START_DATE
, T.COMPLETION_DATE
, T.BILLABLE_FLAG
, T.CHARGEABLE_FLAG
, T.ALLOW_CROSS_CHARGE_FLAG
FROM PA_TASKS_EXPEND_V T
Columns
Name |
PROJECT_ID |
PROJECT_NUMBER |
PROJECT_NAME |
TASK_ID |
TASK_NUMBER |
TASK_NAME |
WBS_SORT_ORDER |
START_DATE |
COMPLETION_DATE |
BILLABLE_FLAG |
CHARGEABLE_FLAG |
ALLOW_CROSS_CHARGE_FLAG |