PJF_TASKS_ALL_EXPEND_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
PROJECT_ID PROJECT_NUMBER TASK_ID TASK_NUMBER TASK_NAME DESCRIPTION START_DATE LABOR_COST_MULTIPLIER_NAME COMPLETION_DATE CHARGEABLE_FLAG ALLOW_CROSS_CHARGE_FLAG BILLABLE_FLAG CARRYING_OUT_ORGANIZATION_ID ORG_ID

Query

SQL_Statement

SELECT T.PROJECT_ID , P.SEGMENT1 PROJECT_NUMBER , T.PROJ_ELEMENT_ID TASK_ID , T.ELEMENT_NUMBER TASK_NUMBER , TTL.NAME TASK_NAME ,TTL.DESCRIPTION , T.START_DATE , T.LABOR_COST_MULTIPLIER_NAME , T.COMPLETION_DATE , T.CHARGEABLE_FLAG ,T.allow_cross_charge_flag ,T.billable_flag ,T.CARRYING_OUT_ORGANIZATION_ID ,IMP.ORG_ID FROM PJF_PROJ_ELEMENTS_B T, PJF_PROJ_ELEMENTS_TL TTL, HR_ALL_ORGANIZATION_UNITS_F HR, PJF_PROJECTS_ALL_B P, PJF_BU_IMPL_ALL IMP WHERE T.project_id = TTL.project_id AND HR.ORGANIZATION_ID (+) = imp.org_id AND (P.project_id = t.project_id AND (imp.org_id = p.org_id OR T.allow_cross_charge_flag = 'Y')) AND t.proj_element_id = ttl.proj_element_id and ttl.language =userenv('LANG') AND T.OBJECT_TYPE='PJF_TASKS' AND T.ELEMENT_TYPE='FINANCIAL' AND P.PROJECT_CATEGORY IN ('FINANCIAL', 'FIN_EXEC')