VIEW: APPS.CS_COUNTER_PROPERTIES_V

Source

View Text - Preformatted

SELECT a.ROWID ,a.COUNTER_PROPERTY_ID ,a.COUNTER_ID ,a.NAME ,a.DESCRIPTION ,a.PROPERTY_DATA_TYPE ,a.IS_NULLABLE ,a.DEFAULT_VALUE 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 ,decode(a.property_lov_type,null,null,c1.meaning)  as PROPERTY_LOV_NAME,decode(a.property_lov_type,null,null,c.lookup_code) as DEFAULT_VALUE_CODE FROM CS_COUNTER_PROPERTIES a, MTL_UNITS_OF_MEASURE b,FND_LOOKUPS c ,(select lookup_type,lookup_code,meaning from fnd_lookups where  lookup_type (+) = 'CS_COUNTER_PROPERTY_LOV')  c1  WHERE a.UOM_CODE = b.UOM_CODE(+) and c.lookup_type(+)=a.property_lov_type  and c1.lookup_code(+)=c.lookup_type  and c.meaning (+) = a.default_value

View Text - HTML Formatted

SELECT A.ROWID
, A.COUNTER_PROPERTY_ID
, A.COUNTER_ID
, A.NAME
, A.DESCRIPTION
, A.PROPERTY_DATA_TYPE
, A.IS_NULLABLE
, A.DEFAULT_VALUE 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
, DECODE(A.PROPERTY_LOV_TYPE
, NULL
, NULL
, C1.MEANING) AS PROPERTY_LOV_NAME
, DECODE(A.PROPERTY_LOV_TYPE
, NULL
, NULL
, C.LOOKUP_CODE) AS DEFAULT_VALUE_CODE
FROM CS_COUNTER_PROPERTIES A
, MTL_UNITS_OF_MEASURE B
, FND_LOOKUPS C
, (SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE (+) = 'CS_COUNTER_PROPERTY_LOV') C1
WHERE A.UOM_CODE = B.UOM_CODE(+)
AND C.LOOKUP_TYPE(+)=A.PROPERTY_LOV_TYPE
AND C1.LOOKUP_CODE(+)=C.LOOKUP_TYPE
AND C.MEANING (+) = A.DEFAULT_VALUE