VIEW: APPS.CST_DEPARTMENT_OVERHEADS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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