Product: | CSI - Install Base |
---|---|
Description: | Backward compatible views for CS_COUNTER_PROPERTIES |
Implementation/DBA Data: | APPS.CSI_CTR_PROPERTIES_BC_V |
SELECT COUNTER_PROPERTY_ID COUNTER_PROPERTY_ID
, COUNTER_ID COUNTER_ID
, NAME NAME
, DESCRIPTION DESCRIPTION
, PROPERTY_DATA_TYPE PROPERTY_DATA_TYPE
, IS_NULLABLE IS_NULLABLE
, DEFAULT_VALUE DEFAULT_VALUE
, MINIMUM_VALUE MINIMUM_VALUE
, MAXIMUM_VALUE MAXIMUM_VALUE
, UOM_CODE UOM_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY CONTEXT
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, NULL CREATED_FROM_CTR_PROP_TMPL_ID
, NULL SOURCE_COUNTER_PROP_ID
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, PROPERTY_LOV_TYPE PROPERTY_LOV_TYPE
FROM CSI_CTR_PROP_TEMPLATE_VL UNION ALL SELECT COUNTER_PROPERTY_ID COUNTER_PROPERTY_ID
, COUNTER_ID COUNTER_ID
, NAME NAME
, DESCRIPTION DESCRIPTION
, PROPERTY_DATA_TYPE PROPERTY_DATA_TYPE
, IS_NULLABLE IS_NULLABLE
, DEFAULT_VALUE DEFAULT_VALUE
, MINIMUM_VALUE MINIMUM_VALUE
, MAXIMUM_VALUE MAXIMUM_VALUE
, UOM_CODE UOM_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY CONTEXT
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, NULL CREATED_FROM_CTR_PROP_TMPL_ID
, NULL SOURCE_COUNTER_PROP_ID
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, PROPERTY_LOV_TYPE PROPERTY_LOV_TYPE
FROM CSI_COUNTER_PROPERTIES_VL