VIEW: APPS.CST_ACTIVITY_COSTS_V

Source

View Text - Preformatted

SELECT CAC.ROWID , CAC.ACTIVITY_ID , CA.ACTIVITY , CAC.COST_TYPE_ID , CCT.COST_TYPE , CCT.DESCRIPTION , CAC.ORGANIZATION_ID , CAC.CREATED_BY , CAC.CREATION_DATE , CAC.LAST_UPDATED_BY , CAC.LAST_UPDATE_DATE , CAC.LAST_UPDATE_LOGIN , CCT.ALLOW_UPDATES_FLAG , CAC.TOTAL_ACTIVITY_UNITS , CAC.TOTAL_COST , CAC.UNIT_COST , CAC.ATTRIBUTE_CATEGORY , CAC.ATTRIBUTE1 , CAC.ATTRIBUTE2 , CAC.ATTRIBUTE3 , CAC.ATTRIBUTE4 , CAC.ATTRIBUTE5 , CAC.ATTRIBUTE6 , CAC.ATTRIBUTE7 , CAC.ATTRIBUTE8 , CAC.ATTRIBUTE9 , CAC.ATTRIBUTE10 , CAC.ATTRIBUTE11 , CAC.ATTRIBUTE12 , CAC.ATTRIBUTE13 , CAC.ATTRIBUTE14 , CAC.ATTRIBUTE15 FROM CST_ACTIVITY_COSTS CAC , CST_ACTIVITIES CA , CST_COST_TYPES CCT WHERE CA.ACTIVITY_ID = CAC.ACTIVITY_ID AND CCT.COST_TYPE_ID = CAC.COST_TYPE_ID

View Text - HTML Formatted

SELECT CAC.ROWID
, CAC.ACTIVITY_ID
, CA.ACTIVITY
, CAC.COST_TYPE_ID
, CCT.COST_TYPE
, CCT.DESCRIPTION
, CAC.ORGANIZATION_ID
, CAC.CREATED_BY
, CAC.CREATION_DATE
, CAC.LAST_UPDATED_BY
, CAC.LAST_UPDATE_DATE
, CAC.LAST_UPDATE_LOGIN
, CCT.ALLOW_UPDATES_FLAG
, CAC.TOTAL_ACTIVITY_UNITS
, CAC.TOTAL_COST
, CAC.UNIT_COST
, CAC.ATTRIBUTE_CATEGORY
, CAC.ATTRIBUTE1
, CAC.ATTRIBUTE2
, CAC.ATTRIBUTE3
, CAC.ATTRIBUTE4
, CAC.ATTRIBUTE5
, CAC.ATTRIBUTE6
, CAC.ATTRIBUTE7
, CAC.ATTRIBUTE8
, CAC.ATTRIBUTE9
, CAC.ATTRIBUTE10
, CAC.ATTRIBUTE11
, CAC.ATTRIBUTE12
, CAC.ATTRIBUTE13
, CAC.ATTRIBUTE14
, CAC.ATTRIBUTE15
FROM CST_ACTIVITY_COSTS CAC
, CST_ACTIVITIES CA
, CST_COST_TYPES CCT
WHERE CA.ACTIVITY_ID = CAC.ACTIVITY_ID
AND CCT.COST_TYPE_ID = CAC.COST_TYPE_ID