View: CST_ACTIVITY_COSTS_V

Product:	BOM - Bills of Material
Description:	Activity cost by cost type : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_ACTIVITY_COSTS_V

View Text

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

Columns