1. Tables and Views for Common Features
  2. PATCH_ARTIFACT_CHG_STATUS

PATCH_ARTIFACT_CHG_STATUS

Details

  • Schema: FUSION

  • Object type: VIEW

Columns

Name

APP_ID

TYPE

CHANGE_TYPE

TOTAL_COUNT

Query

SQL_Statement

SELECT APP_ID, TYPE, CHANGE_TYPE, COUNT(1) TOTAL_COUNT FROM (

SELECT APP_ID, TYPE, 'CONFLICTS' CHANGE_TYPE FROM PATCH_ARTIFACT

WHERE

CHG_TYPE IN ('MODIFICATIONS_CONFLICTS_2WAY', 'ADDITIONS_CONFLICTS_MODIFIED', 'MODIFICATIONS_CONFLICTS_3WAY', 'DELETIONS_CONFLICTS_MOD')

UNION ALL

SELECT APP_ID, TYPE, 'CHANGES' CHANGE_TYPE FROM PATCH_ARTIFACT

WHERE

CHG_TYPE IN ('ADDITIONS_SAFE', 'MODIFICATIONS_SAFE', 'DELETIONS_SAFE')

)

GROUP BY APP_ID, TYPE, CHANGE_TYPE