ACD_CONCEPTS_PROJ_TASKS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ACD
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
CONCEPT_STRUCTURE_ID TASKIDCOUNT |
問合せ
| 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 |