View: CSI_CTR_RELATIONSHIPS_V

Product:	CSI - Install Base
Description:	Counter relationships view
Implementation/DBA Data:	APPS.CSI_CTR_RELATIONSHIPS_V

View Text

SELECT CCR.RELATIONSHIP_ID RELATIONSHIP_ID
, CCR.CTR_ASSOCIATION_ID CTR_ASSOCIATION_ID
, CCR.RELATIONSHIP_TYPE_CODE RELATIONSHIP_TYPE_CODE
, CCR.SOURCE_COUNTER_ID SOURCE_COUNTER_ID
, CCV.NAME SOURCE_COUNTER_NAME
, CCR.OBJECT_COUNTER_ID OBJECT_COUNTER_ID
, CCV2.NAME OBJECT_COUNTER_NAME
, CCR.BIND_VARIABLE_NAME BIND_VARIABLE_NAME
, CCR.FACTOR FACTOR
, CCR.ACTIVE_START_DATE ACTIVE_START_DATE
, CCR.ACTIVE_END_DATE ACTIVE_END_DATE
, CCR.SECURITY_GROUP_ID SECURITY_GROUP_ID
, CCR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCR.LAST_UPDATED_BY LAST_UPDATED_BY
, CCR.CREATION_DATE CREATION_DATE
, CCR.CREATED_BY CREATED_BY
, CCR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CCR.ATTRIBUTE1 ATTRIBUTE1
, CCR.ATTRIBUTE2 ATTRIBUTE2
, CCR.ATTRIBUTE3 ATTRIBUTE3
, CCR.ATTRIBUTE4 ATTRIBUTE4
, CCR.ATTRIBUTE5 ATTRIBUTE5
, CCR.ATTRIBUTE6 ATTRIBUTE6
, CCR.ATTRIBUTE7 ATTRIBUTE7
, CCR.ATTRIBUTE8 ATTRIBUTE8
, CCR.ATTRIBUTE9 ATTRIBUTE9
, CCR.ATTRIBUTE10 ATTRIBUTE10
, CCR.ATTRIBUTE11 ATTRIBUTE11
, CCR.ATTRIBUTE12 ATTRIBUTE12
, CCR.ATTRIBUTE13 ATTRIBUTE13
, CCR.ATTRIBUTE14 ATTRIBUTE14
, CCR.ATTRIBUTE15 ATTRIBUTE15
, CCR.MIGRATED_FLAG MIGRATED_FLAG
FROM CSI_COUNTER_RELATIONSHIPS CCR
, CSI_COUNTERS_VL CCV
, CSI_COUNTERS_VL CCV2
WHERE CCR.SOURCE_COUNTER_ID = CCV.COUNTER_ID
AND CCR.OBJECT_COUNTER_ID = CCV2.COUNTER_ID

Columns