PJF_TASKS_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 WORK_TYPE_ID WORK_TYPE_NAME TP_AMT_TYPE_CODE ORG_ID DENORM_WBS_NUMBER EXPENDITURE_ORG_ID

Query

SQL_Statement

SELECT Tvl.PROJECT_ID , P.SEGMENT1 PROJECT_NUMBER , Tvl.PROJ_ELEMENT_ID TASK_ID , Tvl.ELEMENT_NUMBER TASK_NUMBER , Tvl.NAME TASK_NAME ,Tvl.description , Tvl.START_DATE , Tvl.LABOR_COST_MULTIPLIER_NAME , Tvl.COMPLETION_DATE , Tvl.CHARGEABLE_FLAG ,Tvl.allow_cross_charge_flag ,Tvl.billable_flag ,Tvl.carrying_out_organization_id ,Tvl.work_type_id ,WTvl.NAME WORK_TYPE_NAME ,WTvl.TP_AMT_TYPE_CODE ,P.ORG_ID, TVL.DENORM_WBS_NUMBER, Impl.Org_Id Expenditure_Org_Id FROM PJF_PROJ_ELEMENTS_vl tvl, PJF_PROJECTS_ALL_B P, PJF_WORK_TYPES_vl wtvl, PJF_BU_IMPL_V IMPL WHERE ( ( P.Org_Id = IMPL.Org_Id ) OR ( P.Org_Id <> IMPL.Org_Id AND Tvl.allow_cross_charge_flag = 'Y' AND P.Allow_Cross_Charge_Flag = 'Y' AND NOT EXISTS (SELECT NULL FROM Pjc_CC_Prj_Bu_Relationships CCY WHERE P.Project_Id = CCY.Project_Id AND Impl.org_id = CCY.BU_ID ) ) OR ( P.Org_Id <> IMPL.Org_Id AND Tvl.allow_cross_charge_flag = 'Y' AND P.Allow_Cross_Charge_Flag = 'N' AND EXISTS (SELECT NULL FROM Pjc_CC_Prj_Bu_Relationships CCN WHERE P.Project_Id = CCN.Project_Id AND IMPL.ORG_ID = CCN.BU_ID ) ) ) AND WTvl.WORK_TYPE_ID(+) = tvl.WORK_TYPE_ID AND P.project_id = Tvl.project_id AND Tvl.OBJECT_TYPE='PJF_TASKS' AND Tvl.ELEMENT_TYPE='FINANCIAL' AND P.PROJECT_CATEGORY IN ('FINANCIAL', 'FIN_EXEC')