PJO_PROJECTS_V

Details

• Schema: FUSION

• Object owner: PJO

• Object type: VIEW

Columns

Name

PROJECT_ID SEGMENT1 NAME FLEX_VALUE_ATTRIBUTE1 FLEX_VALUE_ATTRIBUTE2 FLEX_VALUE_ATTRIBUTE3 FLEX_VALUE_ATTRIBUTE4 FLEX_VALUE_ATTRIBUTE5 FLEX_VALUE_ATTRIBUTE6 FLEX_VALUE_ATTRIBUTE7 FLEX_VALUE_ATTRIBUTE8 FLEX_VALUE_ATTRIBUTE9 FLEX_VALUE_ATTRIBUTE10 FLEX_VALUE_ATTRIBUTE11 FLEX_VALUE_ATTRIBUTE12 FLEX_VALUE_ATTRIBUTE13 FLEX_VALUE_ATTRIBUTE14 FLEX_VALUE_ATTRIBUTE15 FLEX_VALUE_ATTRIBUTE16 FLEX_VALUE_ATTRIBUTE17 FLEX_VALUE_ATTRIBUTE18 FLEX_VALUE_ATTRIBUTE19 FLEX_VALUE_ATTRIBUTE20 SUMMARY_FLAG

Query

SQL_Statement

select ppa.PROJECT_ID, ppa.segment1, ppa.NAME, 'N' FLEX_VALUE_ATTRIBUTE1, 'N' FLEX_VALUE_ATTRIBUTE2, NULL FLEX_VALUE_ATTRIBUTE3, NULL FLEX_VALUE_ATTRIBUTE4, NULL FLEX_VALUE_ATTRIBUTE5, NULL FLEX_VALUE_ATTRIBUTE6, NULL FLEX_VALUE_ATTRIBUTE7, NULL FLEX_VALUE_ATTRIBUTE8, NULL FLEX_VALUE_ATTRIBUTE9, NULL FLEX_VALUE_ATTRIBUTE10, NULL FLEX_VALUE_ATTRIBUTE11, NULL FLEX_VALUE_ATTRIBUTE12, NULL FLEX_VALUE_ATTRIBUTE13, NULL FLEX_VALUE_ATTRIBUTE14, NULL FLEX_VALUE_ATTRIBUTE15, NULL FLEX_VALUE_ATTRIBUTE16, NULL FLEX_VALUE_ATTRIBUTE17, NULL FLEX_VALUE_ATTRIBUTE18, NULL FLEX_VALUE_ATTRIBUTE19, NULL FLEX_VALUE_ATTRIBUTE20, 'N' SUMMARY_FLAG from pjf_projects_all_vl ppa where ppa.template_flag='N' and exists(select 1 from pjo_plan_versions_b ppv where ppa.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')