1. Tables and Views for Project Management
  2. PJC_TASKS_CCW_V

PJC_TASKS_CCW_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

PROJECT_ID

TASK_ID

TASK_NUMBER

PROJECT_NUMBER

TASK_NAME

START_DATE

COMPLETION_DATE

EXPENDITURE_ORG_ID

CREATION_DATE

LAST_UPDATE_DATE

LIMIT_TO_TXN_CONTROLS_FLAG

Query

SQL_Statement

SELECT tvl.project_id ,

Tvl.PROJ_ELEMENT_ID TASK_ID ,

Tvl.ELEMENT_NUMBER TASK_NUMBER ,

P.SEGMENT1 PROJECT_NUMBER,

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

Impl.Org_Id Expenditure_Org_Id,

tvl.CREATION_DATE,

tvl.LAST_UPDATE_DATE,

tvl.LIMIT_TO_TXN_CONTROLS_FLAG

FROM PJF_PROJ_ELEMENTS_vl tvl,

PJF_PROJECTS_ALL_B P,

PJF_BU_IMPL_ALL IMPL

WHERE ( ( P.Org_Id = IMPL.Org_Id ) OR

(Tvl.allow_cross_charge_flag = 'Y'))

AND 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