1. Tables and Views for Project Management
  2. PJC_ALL_PROJECTS_CCW_V

PJC_ALL_PROJECTS_CCW_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

PROJECT_ID

PROJECT_NUMBER

PROJECT_NAME

PROJECT_DESCRIPTION

PROJECT_ACTION_ALLOWED_FLAG

Query

SQL_Statement

SELECT

Prj.Project_Id,

Prj.Segment1 Project_Number,

Prj.Name Project_Name,

Prj.Description Project_Description,

nvl(psc.allow_overrides_flag,'N') AS Project_Action_Allowed_Flag

FROM

PJF_PROJECTS_ALL_VL Prj,

pjf_proj_status_controls psc

WHERE Prj.template_flag = 'N'

AND prj.project_status_code = psc.project_status_code

AND psc.action_code = 'NEW_TXNS'