PJO_PROJ_PLAN_TASKS_COUNT_V

Details

• Schema: FUSION

• Object owner: PJO

• Object type: VIEW

Columns

Name
PROJECT_ID MEASURE_CODE MEANING TASKS_COUNT DISPLAY_ORDER

Query

SQL_Statement

select ppa.project_id ,ppa.measure_code ,lu.meaning ,ppa.tasks_count ,ppa.display_order from pjf_projects_all_b pa, table( pjo_task_assignment_utils.proj_plan_tasks_count(pa.project_id)) ppa, pjo_lookups lu where pa.project_id = ppa.project_id and ppa.measure_code = lu.lookup_code and lu.lookup_type = 'PJO_PROJ_PLAN_ANALYTICS' and pa.project_category in ('FINANCIAL', 'FIN_EXEC') order by ppa.display_order