PJO_PROJ_PLAN_ANALYTICS_V

Details

• Schema: FUSION

• Object owner: PJO

• Object type: VIEW

Columns

Name
PROJECT_ID PLAN_VERSION_ID MEASURE_CODE MEASURE_DESCRIPTION PLAN_VALUE_DATE PLAN_VALUE_NUMBER BASELINE_VALUE_DATE BASELINE_VALUE_NUMBER PLAN_BAS_VARIANCE DISPLAY_ORDER

Query

SQL_Statement

select ppa.project_id ,ppa.plan_version_id ,ppa.measure_code ,lu.meaning||ppa.project_currency_code MEASURE_DESCRIPTION ,ppa.PLAN_VALUE_DATE ,ppa.PLAN_VALUE_NUMBER ,ppa.BASELINE_VALUE_DATE ,ppa.BASELINE_VALUE_NUMBER ,ppa.PLAN_BAS_VARIANCE ,ppa.display_order from pjo_plan_versions_b pv, table( pjo_task_assignment_utils.proj_plan_analytics(pv.project_id, pv.plan_version_id)) ppa, pjo_lookups lu where pv.structure_version_id IS NOT NULL and pv.plan_status_code = 'W' and pv.current_plan_status_flag = 'Y' and pv.plan_version_id = ppa.plan_version_id and pv.project_id = ppa.project_id and ppa.measure_code = lu.lookup_code and lu.lookup_type = 'PJO_PROJ_PLAN_ANALYTICS' order by ppa.display_order