1. Tables and Views for Project Management
  2. PJF_TASKS_V

PJF_TASKS_V

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

ROW_ID

TASK_ID

PROJECT_ID

TASK_NUMBER

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

TASK_NAME

TOP_TASK_ID

WBS_LEVEL

PARENT_TASK_ID

DESCRIPTION

CARRYING_OUT_ORGANIZATION_ID

SERVICE_TYPE_CODE

TASK_MANAGER_PERSON_ID

CHARGEABLE_FLAG

BILLABLE_FLAG

LIMIT_TO_TXN_CONTROLS_FLAG

START_DATE

COMPLETION_DATE

LABOR_COST_MULTIPLIER_NAME

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

COST_IND_RATE_SCH_ID

COST_IND_SCH_FIXED_DATE

PM_TASK_REFERENCE

PM_PRODUCT_CODE

LEAF_NODE_FLAG

ALLOW_CROSS_CHARGE_FLAG

CC_PROCESS_LABOR_FLAG

LABOR_TP_SCHEDULE_ID

LABOR_TP_FIXED_DATE

CC_PROCESS_NL_FLAG

NL_TP_SCHEDULE_ID

NL_TP_FIXED_DATE

RECEIVE_PROJECT_INVOICE_FLAG

WORK_TYPE_ID

OBJECT_VERSION_NUMBER

RETIREMENT_COST_FLAG

CINT_ELIGIBLE_FLAG

CINT_STOP_DATE

CLIN_TASK_ID

GEN_ETC_SOURCE_CODE

CREATED_FROM_SOURCE_ID

PLANNING_START_DATE

PLANNING_END_DATE

BASELINE_START_DATE

BASELINE_FINISH_DATE

ETC_CALC_METHOD

PERCENT_COMP_CALC_METHOD

SITE_USE_ID

PLANNING_DATES_ROLLUP_FLAG

CAPITALIZABLE_FLAG

DENORM_ELEM_VER_ID

DENORM_PARENT_STRUCT_VER_ID

DENORM_PARENT_ELEM_VER_ID

DENORM_PARENT_OBJECT_TYPE

DENORM_WBS_NUMBER

DENORM_DISPLAY_SEQUENCE

IC_CLIN_ELEMENT_ID

CRITICAL_FLAG

MILESTONE_FLAG

OVR_COST_IND_RATE_SCH_ID

Query

SQL_Statement

SELECT

TASK.ROWID ROW_ID,

TASK.PROJ_ELEMENT_ID TASK_ID,

TASK.PROJECT_ID,

TASK.ELEMENT_NUMBER TASK_NUMBER,

TASK.CREATION_DATE,

TASK.CREATED_BY,

TASK.LAST_UPDATE_DATE,

TASK.LAST_UPDATED_BY,

TASK.LAST_UPDATE_LOGIN,

PPETL.NAME TASK_NAME,

TASK.DENORM_TOP_ELEMENT_ID TOP_TASK_ID,

TASK.DENORM_WBS_LEVEL WBS_LEVEL,

TASK.DENORM_PARENT_ELEMENT_ID PARENT_TASK_ID,

PPETL.DESCRIPTION,

TASK.CARRYING_OUT_ORGANIZATION_ID,

TASK.SERVICE_TYPE_CODE,

TASK.MANAGER_PERSON_ID TASK_MANAGER_PERSON_ID,

TASK.CHARGEABLE_FLAG,

TASK.BILLABLE_FLAG,

TASK.LIMIT_TO_TXN_CONTROLS_FLAG,

TASK.START_DATE,

TASK.COMPLETION_DATE,

TASK.LABOR_COST_MULTIPLIER_NAME,

TASK.ATTRIBUTE_CATEGORY,

TASK.ATTRIBUTE1,

TASK.ATTRIBUTE2,

TASK.ATTRIBUTE3,

TASK.ATTRIBUTE4,

TASK.ATTRIBUTE5,

TASK.ATTRIBUTE6,

TASK.ATTRIBUTE7,

TASK.ATTRIBUTE8,

TASK.ATTRIBUTE9,

TASK.ATTRIBUTE10,

TASK.ATTRIBUTE11,

TASK.ATTRIBUTE12,

TASK.ATTRIBUTE13,

TASK.ATTRIBUTE14,

TASK.ATTRIBUTE15,

TASK.COST_IND_RATE_SCH_ID,

TASK.COST_IND_SCH_FIXED_DATE,

TASK.PM_SOURCE_REFERENCE PM_TASK_REFERENCE,

TASK.PM_SOURCE_CODE PM_PRODUCT_CODE,

TASK.LEAF_NODE_FLAG,

TASK.ALLOW_CROSS_CHARGE_FLAG,

TASK.CC_PROCESS_LABOR_FLAG,

TASK.LABOR_TP_SCHEDULE_ID,

TASK.LABOR_TP_FIXED_DATE,

TASK.CC_PROCESS_NL_FLAG,

TASK.NL_TP_SCHEDULE_ID,

TASK.NL_TP_FIXED_DATE,

TASK.RECEIVE_PROJECT_INVOICE_FLAG,

TASK.WORK_TYPE_ID,

TASK.OBJECT_VERSION_NUMBER,

TASK.RETIREMENT_COST_FLAG,

TASK.CINT_ELIGIBLE_FLAG,

TASK.CINT_STOP_DATE,

TASK.CLIN_ELEMENT_ID CLIN_TASK_ID,

TASK.GEN_ETC_SOURCE_CODE,

TASK.CREATED_FROM_SOURCE_ID,

TASK.PLANNING_START_DATE,

TASK.PLANNING_END_DATE,

TASK.BASELINE_START_DATE,

TASK.BASELINE_FINISH_DATE,

TASK.ETC_CALC_METHOD,

TASK.PERCENT_COMP_CALC_METHOD,

TASK.SITE_USE_ID,

TASK.PLANNING_DATES_ROLLUP_FLAG,

TASK.CAPITALIZABLE_FLAG,

TASK.DENORM_ELEM_VER_ID,

TASK.DENORM_PARENT_STRUCT_VER_ID,

TASK.DENORM_PARENT_ELEM_VER_ID,

TASK.DENORM_PARENT_OBJECT_TYPE,

TASK.DENORM_WBS_NUMBER,

TASK.DENORM_DISPLAY_SEQUENCE,

TASK.IC_CLIN_ELEMENT_ID,

TASK.CRITICAL_FLAG,

TASK.MILESTONE_FLAG,

TASK.OVR_COST_IND_RATE_SCH_ID

FROM

PJF_PROJ_ELEMENTS_B TASK,

PJF_PROJ_ELEMENTS_TL PPETL

WHERE

TASK.PROJ_ELEMENT_ID = PPETL.PROJ_ELEMENT_ID AND PPETL.LANGUAGE = USERENV('LANG') AND TASK.ELEMENT_TYPE = 'FINANCIAL' AND TASK.OBJECT_TYPE = 'PJF_TASKS'