1. Tables and Views for SCM
  2. ACD_CONCEPTS_PROJ_TASKS_V

ACD_CONCEPTS_PROJ_TASKS_V

Details

  • Schema: FUSION

  • Object owner: ACD

  • Object type: VIEW

Columns

Name

CONCEPT_STRUCTURE_ID

TASKIDCOUNT

Query

SQL_Statement

SELECT ACS.CONCEPT_STRUCTURE_ID,

SUM(

CASE

WHEN POA.OBJECT_ID IS NOT NULL

THEN 1

ELSE 0

END) AS TaskIdCount

FROM PJE_OBJECT_ASSOCIATIONS POA,

(SELECT ACS.CONCEPT_STRUCTURE_ID,

CASE

WHEN ACS.FROM_TYPE = 'CONCEPT'

THEN ACS.FROM_ID

WHEN ACS.TO_TYPE = 'CONCEPT'

THEN ACS.TO_ID

END AS RELATED_CONCEPT_ID

FROM ACD_CONCEPT_STRUCTURE ACS

WHERE CONCEPT_STRUCTURE_ID IN

(SELECT SRC_OBJ_ID

FROM aca_cs_relationship

WHERE src_obj_type = 'CONCEPT'

AND dest_obj_type = 'Projects'

)

) ACS

WHERE POA.ASSOCIATED_OBJECT_SUB_TYPE_ID IN

(SELECT DELIVERABLE_TYPE_ID

FROM PJE_DELIVERABLE_TYPES_VL CONCEPTCLASS

WHERE CONCEPTCLASS.DELIVERABLE_TYPE_CLASS='PLM_CONCEPT'

)

AND POA.ASSOCIATED_OBJECT_ID = ACS.RELATED_CONCEPT_ID

GROUP BY ACS.CONCEPT_STRUCTURE_ID