View: CST_RESOURCE_OVERHEADS_V

Product:	BOM - Bills of Material
Description:	Resource based overheads by cost type : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_RESOURCE_OVERHEADS_V

View Text

SELECT CRO.ROWID
, CRO.COST_TYPE_ID
, CCT.COST_TYPE
, CCT.DESCRIPTION
, CRO.RESOURCE_ID
, RES.RESOURCE_CODE
, RES.DESCRIPTION
, CRO.OVERHEAD_ID
, OVH.RESOURCE_CODE
, OVH.DESCRIPTION
, OVH.COST_CODE_TYPE
, CRO.LAST_UPDATE_DATE
, CRO.LAST_UPDATED_BY
, CRO.CREATION_DATE
, CRO.CREATED_BY
, CRO.LAST_UPDATE_LOGIN
, CRO.ORGANIZATION_ID
, CRO.REQUEST_ID
, CRO.PROGRAM_APPLICATION_ID
, CRO.PROGRAM_ID
, CRO.PROGRAM_UPDATE_DATE
, CRO.ATTRIBUTE_CATEGORY
, CRO.ATTRIBUTE1
, CRO.ATTRIBUTE2
, CRO.ATTRIBUTE3
, CRO.ATTRIBUTE4
, CRO.ATTRIBUTE5
, CRO.ATTRIBUTE6
, CRO.ATTRIBUTE7
, CRO.ATTRIBUTE8
, CRO.ATTRIBUTE9
, CRO.ATTRIBUTE10
, CRO.ATTRIBUTE11
, CRO.ATTRIBUTE12
, CRO.ATTRIBUTE13
, CRO.ATTRIBUTE14
, CRO.ATTRIBUTE15
FROM BOM_RESOURCES RES
, BOM_RESOURCES OVH
, CST_COST_TYPES CCT
, CST_RESOURCE_OVERHEADS CRO
WHERE CCT.COST_TYPE_ID = CRO.COST_TYPE_ID
AND RES.RESOURCE_ID = CRO.RESOURCE_ID
AND OVH.RESOURCE_ID = CRO.OVERHEAD_ID

Columns