View: CSI_CTR_ESTIMATE_METHODS_VL

Product:	CSI - Install Base
Description:	Counter estimation methods view language
Implementation/DBA Data:	APPS.CSI_CTR_ESTIMATE_METHODS_VL

View Text

SELECT CCEB.ESTIMATION_ID ESTIMATION_ID
, CCET.NAME NAME
, CCET.DESCRIPTION DESCRIPTION
, CCEB.ESTIMATION_TYPE ESTIMATION_TYPE
, CCEB.FIXED_VALUE FIXED_VALUE
, CCEB.USAGE_MARKUP USAGE_MARKUP
, CCEB.DEFAULT_VALUE DEFAULT_VALUE
, CCEB.ESTIMATION_AVG_TYPE ESTIMATION_AVG_TYPE
, CCEB.START_DATE_ACTIVE START_DATE_ACTIVE
, CCEB.END_DATE_ACTIVE END_DATE_ACTIVE
, CCEB.SECURITY_GROUP_ID SECURITY_GROUP_ID
, CCEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCEB.LAST_UPDATED_BY LAST_UPDATED_BY
, CCEB.CREATION_DATE CREATION_DATE
, CCEB.CREATED_BY CREATED_BY
, CCEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CCEB.ATTRIBUTE1 ATTRIBUTE1
, CCEB.ATTRIBUTE2 ATTRIBUTE2
, CCEB.ATTRIBUTE3 ATTRIBUTE3
, CCEB.ATTRIBUTE4 ATTRIBUTE4
, CCEB.ATTRIBUTE5 ATTRIBUTE5
, CCEB.ATTRIBUTE6 ATTRIBUTE6
, CCEB.ATTRIBUTE7 ATTRIBUTE7
, CCEB.ATTRIBUTE8 ATTRIBUTE8
, CCEB.ATTRIBUTE9 ATTRIBUTE9
, CCEB.ATTRIBUTE10 ATTRIBUTE10
, CCEB.ATTRIBUTE11 ATTRIBUTE11
, CCEB.ATTRIBUTE12 ATTRIBUTE12
, CCEB.ATTRIBUTE13 ATTRIBUTE13
, CCEB.ATTRIBUTE14 ATTRIBUTE14
, CCEB.ATTRIBUTE15 ATTRIBUTE15
, CCEB.MIGRATED_FLAG MIGRATED_FLAG
FROM CSI_CTR_ESTIMATION_METHODS_B CCEB
, CSI_CTR_ESTIMATION_METHODS_TL CCET
WHERE CCEB.ESTIMATION_ID = CCET.ESTIMATION_ID
AND CCET.LANGUAGE = USERENV('LANG')

Columns