1. Tables and Views for Project Management
  2. PJC_ALLOC_OFFSET_PROJECTS_V

PJC_ALLOC_OFFSET_PROJECTS_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

PROJECT_ID

PROJECT_NUMBER

NAME

ORG_ID

Query

SQL_Statement

SELECT

pap.project_id,

pap.segment1 PROJECT_NUMBER,

pap.name,

pap.org_id

FROM pjf_projects_all_vl pap

WHERE pap.template_flag <> 'Y'

AND pap.project_category = 'FIN_EXEC'

AND pap.org_id <> -1

AND 'Y' ='Y'