View: CST_DEPARTMENT_OVERHEADS_V

Product:	BOM - Bills of Material
Description:	Departmental overheads : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_DEPARTMENT_OVERHEADS_V

View Text

SELECT CDO.ROWID
, CDO.DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, BD.DESCRIPTION
, CDO.COST_TYPE_ID
, CCT.COST_TYPE
, CCT.DESCRIPTION
, CDO.OVERHEAD_ID
, OVH.RESOURCE_CODE
, OVH.DESCRIPTION
, OVH.COST_CODE_TYPE
, CDO.LAST_UPDATE_DATE
, CDO.LAST_UPDATED_BY
, CDO.CREATION_DATE
, CDO.CREATED_BY
, CDO.LAST_UPDATE_LOGIN
, CDO.ORGANIZATION_ID
, CDO.BASIS_TYPE
, CDO.RATE_OR_AMOUNT
, CDO.ACTIVITY_ID
, CA.ACTIVITY
, CDO.ATTRIBUTE_CATEGORY
, CDO.ATTRIBUTE1
, CDO.ATTRIBUTE2
, CDO.ATTRIBUTE3
, CDO.ATTRIBUTE4
, CDO.ATTRIBUTE5
, CDO.ATTRIBUTE6
, CDO.ATTRIBUTE7
, CDO.ATTRIBUTE8
, CDO.ATTRIBUTE9
, CDO.ATTRIBUTE10
, CDO.ATTRIBUTE11
, CDO.ATTRIBUTE12
, CDO.ATTRIBUTE13
, CDO.ATTRIBUTE14
, CDO.ATTRIBUTE15
, CDO.REQUEST_ID
, CDO.PROGRAM_APPLICATION_ID
, CDO.PROGRAM_ID
, CDO.PROGRAM_UPDATE_DATE
FROM BOM_RESOURCES OVH
, BOM_DEPARTMENTS BD
, CST_ACTIVITIES CA
, CST_COST_TYPES CCT
, CST_DEPARTMENT_OVERHEADS CDO
WHERE CCT.COST_TYPE_ID = CDO.COST_TYPE_ID
AND OVH.RESOURCE_ID = CDO.OVERHEAD_ID
AND BD.DEPARTMENT_ID = CDO.DEPARTMENT_ID
AND CA.ACTIVITY_ID (+) = CDO.ACTIVITY_ID

Columns