1. Tables and Views for Project Management
  2. PJC_ALLOC_TARGET_PROJ_V

PJC_ALLOC_TARGET_PROJ_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

PROJECT_ID

SEGMENT1

NAME

PROJECT_TYPE_ID

CARRYING_OUT_ORGANIZATION_ID

CLASS_CATEGORY_ID

CLASS_CODE_ID

ORG_ID

Query

SQL_Statement

SELECT DISTINCT pap.project_id

,pap.segment1

,pap.name

,pap.project_type_id

,pap.carrying_out_organization_id

,ppc.class_category_id

,ppc.class_code_id

,pap.org_id

FROM pjf_projects_all_vl pap

,pjf_project_classes ppc

WHERE ppc.project_id(+) = pap.project_id

AND NVL(pap.template_flag,'N') <> 'Y'

AND (PJF_PROJECT_STUS_UTILS.is_project_closed(pap.project_id) = 'N')

AND pap.project_category = 'FIN_EXEC'

AND pap.org_id <> -1

AND 'N' = 'N'