1. Tables and Views for Project Management
  2. PJC_PROJECTS_EXPEND_V

PJC_PROJECTS_EXPEND_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

CARRYING_OUT_ORG_NAME

PROJECT_CURRENCY_CODE

ALLOW_CROSS_CHARGE_FLAG

ORG_ID

BU_NAME

EXPENDITURE_ORG_ID

PROJFUNC_CURRENCY_CODE

PROJECT_UNIT_ID

PROJECT_UNIT_NAME

PRJFUNC_COST_RATE_DATE_CODE

PROJFUNC_COST_RATE_TYPE

PROJECT_STATUS_CODE

PROJECT_ACTION_ALLOWED_FLAG

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,

HRVL.Name Carrying_Out_Org_Name,

Prj.Project_Currency_Code,

Prj.Allow_Cross_Charge_Flag,

Prj.Org_Id,

Prj.Bu_Name,

Impl.Org_Id Expenditure_Org_Id,

Prj.Projfunc_Currency_Code,

Prj.Project_Unit_Id,

PU.Name Project_Unit_Name,

Impl.default_rate_date_code Prjfunc_Cost_Rate_Date_Code,

Impl.default_rate_type Projfunc_Cost_Rate_Type,

Prj.Project_status_Code,

pjf_project_stus_utils.Check_prj_stus_action_allowed(Project_status_Code,'NEW_TXNS') Project_Action_Allowed_Flag

FROM

Pjf_Projects_Basic_V Prj,

Pjf_Bu_Impl_V Impl,

Hr_All_Organization_Units_F_VL HRVL,

Hr_Organization_V PU

WHERE

( ( Prj.Org_Id = Impl.Org_Id )

OR

( Prj.Org_Id <> Impl.Org_Id

AND Prj.Allow_Cross_Charge_Flag = 'Y'

AND NOT EXISTS (SELECT NULL

FROM Pjc_CC_Prj_Bu_Relationships CCY

WHERE Prj.Project_Id = CCY.Project_Id

AND Impl.Org_Id = CCY.Bu_Id)

)

OR

( Prj.Org_Id <> Impl.Org_Id

AND Prj.Allow_Cross_Charge_Flag = 'N'

AND EXISTS (SELECT NULL

FROM Pjc_CC_Prj_Bu_Relationships CCN

WHERE Prj.Project_Id = CCN.Project_Id

AND Impl.Org_Id = CCN.Bu_Id)

)

)

AND Prj.Carrying_Out_Organization_Id = HRVL.Organization_Id

AND trunc(sysdate) between hrvl.effective_start_date and hrvl.effective_end_date

AND Prj.Project_Unit_Id = PU.Organization_Id

AND PU.Classification_Code = 'PRJ_PROJECT_UNIT'

AND trunc(sysdate) between pu.effective_start_date and pu.effective_end_date

AND Prj.project_category = 'FIN_EXEC'

AND Prj.org_id <> -1