VIEW: APPS.CST_RESOURCE_OVERHEADS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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