PJC_PROJECTS_CCW_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
PROJECT_ID PROJECT_NUMBER PROJECT_NAME PROJECT_DESCRIPTION START_DATE COMPLETION_DATE PROJECT_TYPE_ID CARRYING_OUT_ORG_ID PROJECT_CURRENCY_CODE ALLOW_CROSS_CHARGE_FLAG ORG_ID EXPENDITURE_ORG_ID PROJFUNC_CURRENCY_CODE PROJECT_UNIT_ID PRJFUNC_COST_RATE_DATE_CODE PROJFUNC_COST_RATE_TYPE LIMIT_TO_TXN_CONTROLS_FLAG PROJECT_STATUS_CODE PROJECT_ACTION_ALLOWED_FLAG CREATION_DATE LAST_UPDATE_DATE

Query

SQL_Statement

Select Prj.Project_Id, Prj.Segment1 Project_Number, Prj.Name Project_Name, Prj.Description Project_Description, Prj.Start_Date , Prj.Completion_Date , Prj.Project_Type_Id , Prj.Carrying_Out_Organization_Id Carrying_Out_Org_Id, Prj.Project_Currency_Code , Prj.Allow_Cross_Charge_Flag , Prj.Org_Id , Impl.Org_Id Expenditure_Org_Id, Prj.Projfunc_Currency_Code , Prj.Project_Unit_Id , Impl.default_rate_date_code Prjfunc_Cost_Rate_Date_Code, Impl.default_rate_type Projfunc_Cost_Rate_Type, Prj.LIMIT_TO_TXN_CONTROLS_FLAG LIMIT_TO_TXN_CONTROLS_FLAG, Prj.Project_status_Code , nvl(psc.allow_overrides_flag,'N') AS Project_Action_Allowed_Flag, Prj.CREATION_DATE, Prj.LAST_UPDATE_DATE FROM PJF_PROJECTS_ALL_VL Prj, Pjf_Bu_Impl_ALL Impl, pjf_proj_status_controls psc , Pjc_CC_Prj_Bu_Relationships rel WHERE Prj.template_flag = 'N' AND Prj.Project_Id = rel.Project_Id(+) AND Impl.Org_Id = rel.Bu_Id(+) AND ( ( Prj.Org_Id = Impl.Org_Id ) OR ( Prj.Org_Id <> Impl.Org_Id AND Prj.Allow_Cross_Charge_Flag = 'Y' AND rel.project_id is null AND rel.bu_id is null ) OR ( Prj.Org_Id <> Impl.Org_Id AND Prj.Allow_Cross_Charge_Flag = 'N' AND rel.project_id is not null AND rel.bu_id is not null ) ) AND prj.project_status_code = psc.project_status_code AND psc.action_code = 'NEW_TXNS'