1. Tables and Views for Project Management
  2. PJC_TASKS_CCW_TEAMMEMBER_V

PJC_TASKS_CCW_TEAMMEMBER_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

PROJECT_ID

TASK_ID

TASK_NUMBER

TASK_NAME

START_DATE

COMPLETION_DATE

Query

SQL_Statement

SELECT tvl.project_id ,

Tvl.PROJ_ELEMENT_ID TASK_ID ,

Tvl.ELEMENT_NUMBER TASK_NUMBER ,

Tvl.NAME TASK_NAME, Tvl.START_DATE, Tvl.COMPLETION_DATE

FROM PJF_PROJ_ELEMENTS_vl tvl,

PJF_PROJECTS_ALL_B P

WHERE Tvl.chargeable_flag = 'Y'

AND P.project_id = Tvl.project_id

AND Tvl.OBJECT_TYPE ='PJF_TASKS'

AND Tvl.ELEMENT_TYPE ='FINANCIAL'

AND P.project_category = 'FIN_EXEC'

AND P.org_id <> -1