PJO_PROJECTS_V

Details

• Schema: FUSION

• Object owner: PJO

• Object type: VIEW

Columns

Name
PROJECT_ID SEGMENT1 NAME

Query

SQL_Statement

select ppb.PROJECT_ID, ppb.segment1, pptl.NAME from pjf_projects_all_b ppb, pjf_projects_all_tl pptl where ppb.template_flag='N' and ppb.project_id = pptl.project_id and pptl.LANGUAGE = USERENV('LANG') and exists(select 1 from pjo_plan_versions_b ppv where ppb.project_id = ppv.project_id and ppv.structure_version_id is null and ppv.plan_class_code = 'BUDGET' and nvl(ppv.budgetary_controls_flag,'N') = 'Y')