Product: | CS - Service |
---|---|
Description: | Counter properties view |
Implementation/DBA Data: | APPS.CS_COUNTER_PROPERTIES_V |
SELECT A.ROWID
, A.COUNTER_PROPERTY_ID
, A.COUNTER_ID
, A.NAME
, A.DESCRIPTION
, A.PROPERTY_DATA_TYPE
, A.IS_NULLABLE
, DECODE(A.PROPERTY_LOV_TYPE
, NULL
, A.DEFAULT_VALUE
, C.MEANING) AS DEFAULT_VALUE
, A.MINIMUM_VALUE
, A.MAXIMUM_VALUE
, A.UOM_CODE
, B.UNIT_OF_MEASURE
, A.SOURCE_COUNTER_PROP_ID
, A.CREATED_FROM_CTR_PROP_TMPL_ID
, A.START_DATE_ACTIVE
, A.END_DATE_ACTIVE
, A.OBJECT_VERSION_NUMBER
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.CONTEXT
, A.PROPERTY_LOV_TYPE
, C.MEANING PROPERTY_LOV_NAME
, DECODE(A.PROPERTY_LOV_TYPE
, NULL
, NULL
, A.DEFAULT_VALUE) AS DEFAULT_VALUE_CODE
FROM CS_COUNTER_PROPERTIES A
, MTL_UNITS_OF_MEASURE B
, FND_LOOKUPS C
WHERE A.UOM_CODE = B.UOM_CODE(+)
AND A.PROPERTY_LOV_TYPE = C.LOOKUP_CODE(+)
AND C.LOOKUP_TYPE (+) = 'CS_COUNTER_PROPERTY_LOV'