DBA Data[Home] [Help]

VIEW: APPS.CS_COUNTER_DER_FILTERS_V

Source

View Text - Preformatted

SELECT a.ROWID ,a.COUNTER_DER_FILTER_ID ,a.COUNTER_ID ,a.SEQ_NO ,a.LEFT_PAREN ,a.COUNTER_PROPERTY_ID ,b.NAME ,a.RELATIONAL_OPERATOR ,a.RIGHT_PAREN ,a.RIGHT_VALUE ,a.LOGICAL_OPERATOR ,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.object_version_number FROM CS_COUNTER_DER_FILTERS a, CS_COUNTER_PROPERTIES b WHERE a.COUNTER_PROPERTY_ID = b.COUNTER_PROPERTY_ID(+)
View Text - HTML Formatted

SELECT A.ROWID
, A.COUNTER_DER_FILTER_ID
, A.COUNTER_ID
, A.SEQ_NO
, A.LEFT_PAREN
, A.COUNTER_PROPERTY_ID
, B.NAME
, A.RELATIONAL_OPERATOR
, A.RIGHT_PAREN
, A.RIGHT_VALUE
, A.LOGICAL_OPERATOR
, 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.OBJECT_VERSION_NUMBER
FROM CS_COUNTER_DER_FILTERS A
, CS_COUNTER_PROPERTIES B
WHERE A.COUNTER_PROPERTY_ID = B.COUNTER_PROPERTY_ID(+)