FND Design Data [Home] [Help]

View: CSI_COUNTER_DER_FILTERS_V

Product: CSI - Install Base
Description: Counter derived filters view
Implementation/DBA Data: ViewAPPS.CSI_COUNTER_DER_FILTERS_V
View Text

SELECT CCDF.COUNTER_DERIVED_FILTER_ID COUNTER_DERIVED_FILTER_ID
, CCPV.NAME COUNTER_NAME
, CCDF.COUNTER_ID COUNTER_ID
, CCDF.SEQ_NO SEQ_NO
, CCDF.LEFT_PARENT LEFT_PARENT
, CCDF.COUNTER_PROPERTY_ID COUNTER_PROPERTY_ID
, CCDF.RELATIONAL_OPERATOR RELATIONAL_OPERATOR
, CCDF.RIGHT_VALUE RIGHT_VALUE
, CCDF.RIGHT_PARENT RIGHT_PARENT
, CCDF.LOGICAL_OPERATOR LOGICAL_OPERATOR
, CCDF.START_DATE_ACTIVE START_DATE_ACTIVE
, CCDF.END_DATE_ACTIVE END_DATE_ACTIVE
, CCDF.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCDF.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCDF.LAST_UPDATED_BY LAST_UPDATED_BY
, CCDF.CREATION_DATE CREATION_DATE
, CCDF.CREATED_BY CREATED_BY
, CCDF.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCDF.ATTRIBUTE1 ATTRIBUTE1
, CCDF.ATTRIBUTE2 ATTRIBUTE2
, CCDF.ATTRIBUTE3 ATTRIBUTE3
, CCDF.ATTRIBUTE4 ATTRIBUTE4
, CCDF.ATTRIBUTE5 ATTRIBUTE5
, CCDF.ATTRIBUTE6 ATTRIBUTE6
, CCDF.ATTRIBUTE7 ATTRIBUTE7
, CCDF.ATTRIBUTE8 ATTRIBUTE8
, CCDF.ATTRIBUTE9 ATTRIBUTE9
, CCDF.ATTRIBUTE10 ATTRIBUTE10
, CCDF.ATTRIBUTE11 ATTRIBUTE11
, CCDF.ATTRIBUTE12 ATTRIBUTE12
, CCDF.ATTRIBUTE13 ATTRIBUTE13
, CCDF.ATTRIBUTE14 ATTRIBUTE14
, CCDF.ATTRIBUTE15 ATTRIBUTE15
, CCDF.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CCDF.SECURITY_GROUP_ID SECURITY_GROUP_ID
, CCDF.MIGRATED_FLAG MIGRATED_FLAG
FROM CSI_COUNTER_DERIVED_FILTERS CCDF
, CSI_COUNTER_PROPERTIES_VL CCPV
WHERE CCDF.COUNTER_PROPERTY_ID = CCPV.COUNTER_PROPERTY_ID(+)

Columns

Name
COUNTER_DERIVED_FILTER_ID
COUNTER_NAME
COUNTER_ID
SEQ_NO
LEFT_PARENT
COUNTER_PROPERTY_ID
RELATIONAL_OPERATOR
RIGHT_VALUE
RIGHT_PARENT
LOGICAL_OPERATOR
START_DATE_ACTIVE
END_DATE_ACTIVE
OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE_CATEGORY
SECURITY_GROUP_ID
MIGRATED_FLAG