Product: | CSI - Install Base |
---|---|
Description: | Backward compatible view for CS_COUNTER_GROUPS |
Implementation/DBA Data: | APPS.CSI_COUNTER_GROUPS_BC_V |
SELECT CCG.COUNTER_GROUP_ID COUNTER_GROUP_ID
, CCG.NAME NAME
, CCG.DESCRIPTION DESCRIPTION
, CCG.TEMPLATE_FLAG TEMPLATE_FLAG
, CCG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCG.LAST_UPDATED_BY LAST_UPDATED_BY
, CCG.CREATION_DATE CREATION_DATE
, CCG.CREATED_BY CREATED_BY
, CCG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCG.START_DATE_ACTIVE START_DATE_ACTIVE
, CCG.END_DATE_ACTIVE END_DATE_ACTIVE
, CCG.ATTRIBUTE1 ATTRIBUTE1
, CCG.ATTRIBUTE2 ATTRIBUTE2
, CCG.ATTRIBUTE3 ATTRIBUTE3
, CCG.ATTRIBUTE4 ATTRIBUTE4
, CCG.ATTRIBUTE5 ATTRIBUTE5
, CCG.ATTRIBUTE6 ATTRIBUTE6
, CCG.ATTRIBUTE7 ATTRIBUTE7
, CCG.ATTRIBUTE8 ATTRIBUTE8
, CCG.ATTRIBUTE9 ATTRIBUTE9
, CCG.ATTRIBUTE10 ATTRIBUTE10
, CCG.ATTRIBUTE11 ATTRIBUTE11
, CCG.ATTRIBUTE12 ATTRIBUTE12
, CCG.ATTRIBUTE13 ATTRIBUTE13
, CCG.ATTRIBUTE14 ATTRIBUTE14
, CCG.ATTRIBUTE15 ATTRIBUTE15
, CCG.CONTEXT CONTEXT
, CCG.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCG.CREATED_FROM_CTR_GRP_TMPL_ID CREATED_FROM_CTR_GRP_TMPL_ID
, DECODE(CCG.ASSOCIATION_TYPE
, 'TRACKABLE'
, 'PROD_ITEM'
, 'CONTRACT'
, 'SVC_ITEM'
, NULL) ASSOCIATION_TYPE
, NULL SOURCE_OBJECT_CODE
, NULL SOURCE_OBJECT_ID
, CCG.SOURCE_COUNTER_GROUP_ID SOURCE_COUNTER_GROUP_ID
, CCG.SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM CS_COUNTER_GROUPS CCG
WHERE CCG.TEMPLATE_FLAG = 'Y' UNION ALL SELECT CCG.COUNTER_GROUP_ID COUNTER_GROUP_ID
, CCG.NAME NAME
, CCG.DESCRIPTION DESCRIPTION
, CCG.TEMPLATE_FLAG TEMPLATE_FLAG
, CCG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCG.LAST_UPDATED_BY LAST_UPDATED_BY
, CCG.CREATION_DATE CREATION_DATE
, CCG.CREATED_BY CREATED_BY
, CCG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCG.START_DATE_ACTIVE START_DATE_ACTIVE
, CCG.END_DATE_ACTIVE END_DATE_ACTIVE
, CCG.ATTRIBUTE1 ATTRIBUTE1
, CCG.ATTRIBUTE2 ATTRIBUTE2
, CCG.ATTRIBUTE3 ATTRIBUTE3
, CCG.ATTRIBUTE4 ATTRIBUTE4
, CCG.ATTRIBUTE5 ATTRIBUTE5
, CCG.ATTRIBUTE6 ATTRIBUTE6
, CCG.ATTRIBUTE7 ATTRIBUTE7
, CCG.ATTRIBUTE8 ATTRIBUTE8
, CCG.ATTRIBUTE9 ATTRIBUTE9
, CCG.ATTRIBUTE10 ATTRIBUTE10
, CCG.ATTRIBUTE11 ATTRIBUTE11
, CCG.ATTRIBUTE12 ATTRIBUTE12
, CCG.ATTRIBUTE13 ATTRIBUTE13
, CCG.ATTRIBUTE14 ATTRIBUTE14
, CCG.ATTRIBUTE15 ATTRIBUTE15
, CCG.CONTEXT CONTEXT
, CCG.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCG.CREATED_FROM_CTR_GRP_TMPL_ID CREATED_FROM_CTR_GRP_TMPL_ID
, CCG.ASSOCIATION_TYPE ASSOCIATION_TYPE
, CCA.SOURCE_OBJECT_CODE SOURCE_OBJECT_CODE
, CCG.SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, CCG.SOURCE_COUNTER_GROUP_ID SOURCE_COUNTER_GROUP_ID
, CCG.SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM CS_COUNTER_GROUPS CCG
, CSI_COUNTER_ASSOCIATIONS CCA
, CSI_COUNTERS_BC_V CCB
WHERE CCG.COUNTER_GROUP_ID = CCB.COUNTER_GROUP_ID
AND CCB.COUNTER_ID = CCA.COUNTER_ID
AND CCG.TEMPLATE_FLAG = 'N'