VIEW: APPS.CS_CTR_ESTIMATION_METHODS_V

Source

View Text - Preformatted

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.estimation_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(+)

View Text - HTML Formatted

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.ESTIMATION_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(+)