Product: | CSI - Install Base |
---|---|
Description: | Counter property template view language |
Implementation/DBA Data: | APPS.CSI_CTR_PROP_TEMPLATE_VL |
SELECT CCPB.COUNTER_PROPERTY_ID COUNTER_PROPERTY_ID
, CCPT.NAME NAME
, CCPT.DESCRIPTION DESCRIPTION
, CCPB.COUNTER_ID COUNTER_ID
, CCPB.PROPERTY_DATA_TYPE PROPERTY_DATA_TYPE
, CCPB.PROPERTY_LOV_TYPE PROPERTY_LOV_TYPE
, CCPB.IS_NULLABLE IS_NULLABLE
, CCPB.DEFAULT_VALUE DEFAULT_VALUE
, CCPB.MINIMUM_VALUE MINIMUM_VALUE
, CCPB.MAXIMUM_VALUE MAXIMUM_VALUE
, CCPB.UOM_CODE UOM_CODE
, CCPB.START_DATE_ACTIVE START_DATE_ACTIVE
, CCPB.END_DATE_ACTIVE END_DATE_ACTIVE
, CCPB.SECURITY_GROUP_ID SECURITY_GROUP_ID
, CCPB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCPB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCPB.LAST_UPDATED_BY LAST_UPDATED_BY
, CCPB.CREATION_DATE CREATION_DATE
, CCPB.CREATED_BY CREATED_BY
, CCPB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCPB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CCPB.ATTRIBUTE1 ATTRIBUTE1
, CCPB.ATTRIBUTE2 ATTRIBUTE2
, CCPB.ATTRIBUTE3 ATTRIBUTE3
, CCPB.ATTRIBUTE4 ATTRIBUTE4
, CCPB.ATTRIBUTE5 ATTRIBUTE5
, CCPB.ATTRIBUTE6 ATTRIBUTE6
, CCPB.ATTRIBUTE7 ATTRIBUTE7
, CCPB.ATTRIBUTE8 ATTRIBUTE8
, CCPB.ATTRIBUTE9 ATTRIBUTE9
, CCPB.ATTRIBUTE10 ATTRIBUTE10
, CCPB.ATTRIBUTE11 ATTRIBUTE11
, CCPB.ATTRIBUTE12 ATTRIBUTE12
, CCPB.ATTRIBUTE13 ATTRIBUTE13
, CCPB.ATTRIBUTE14 ATTRIBUTE14
, CCPB.ATTRIBUTE15 ATTRIBUTE15
, CCPB.MIGRATED_FLAG MIGRATED_FLAG
FROM CSI_CTR_PROPERTY_TEMPLATE_B CCPB
, CSI_CTR_PROPERTY_TEMPLATE_TL CCPT
WHERE CCPB.COUNTER_PROPERTY_ID = CCPT.COUNTER_PROPERTY_ID
AND CCPT.LANGUAGE = USERENV('LANG')