FND Design Data [Home] [Help]

View: CS_CTR_ESTIMATION_METHODS_V

Product: CS - Service
Description:
Implementation/DBA Data: ViewAPPS.CS_CTR_ESTIMATION_METHODS_V
View Text

SELECT A.ROWID
, A.ESTIMATION_ID
, A.ESTIMATION_NAME
, A.ESTIMATION_TYPE
, A.ESTIMATION_AVG_TYPE
, A.FIXED_VALUE
, A.USAGE_MARKUP
, A.DEFAULT_VALUE
, A.COUNTER_GROUP_ID
, A.COUNTER_ID
, A.START_DATE_ACTIVE
, A.END_DATE_ACTIVE
, 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. ATTRIBUTE_CATEGORY
, A.OBJECT_VERSION_NUMBER
, B.NAME AS COUNTER_GROUP_NAME
, C.NAME AS COUNTER_NAME
, A.COUNTER_DESCRIPTION FROM CS_CTR_ESTIMATION_METHODS A
, CS_COUNTER_GROUPS B
, CS_COUNTERS C
WHERE A.COUNTER_GROUP_ID=B.COUNTER_GROUP_ID(+)
AND A.COUNTER_ID=C.COUNTER_ID(+)

Columns

Name
ROW_ID
ESTIMATION_ID
ESTIMATION_NAME
ESTIMATION_TYPE
ESTIMATION_AVG_TYPE
FIXED_VALUE
USAGE_MARKUP
DEFAULT_VALUE
COUNTER_GROUP_ID
COUNTER_ID
START_DATE_ACTIVE
END_DATE_ACTIVE
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
OBJECT_VERSION_NUMBER
COUNTER_DESCRIPTION