VIEW: APPS.CST_RESOURCE_COSTS_V

Source

View Text - Preformatted

SELECT CRC.ROWID , CRC.RESOURCE_ID , CRC.COST_TYPE_ID , CCT.COST_TYPE , CCT.DESCRIPTION , CRC.LAST_UPDATE_DATE , CRC.LAST_UPDATED_BY , CRC.CREATION_DATE , CRC.CREATED_BY , CRC.LAST_UPDATE_LOGIN , CRC.ORGANIZATION_ID , CRC.RESOURCE_RATE , CRC.ATTRIBUTE_CATEGORY , CRC.ATTRIBUTE1 , CRC.ATTRIBUTE2 , CRC.ATTRIBUTE3 , CRC.ATTRIBUTE4 , CRC.ATTRIBUTE5 , CRC.ATTRIBUTE6 , CRC.ATTRIBUTE7 , CRC.ATTRIBUTE8 , CRC.ATTRIBUTE9 , CRC.ATTRIBUTE10 , CRC.ATTRIBUTE11 , CRC.ATTRIBUTE12 , CRC.ATTRIBUTE13 , CRC.ATTRIBUTE14 , CRC.ATTRIBUTE15 , CRC.REQUEST_ID , CRC.PROGRAM_APPLICATION_ID , CRC.PROGRAM_ID , CRC.PROGRAM_UPDATE_DATE , CCT.ALLOW_UPDATES_FLAG FROM CST_COST_TYPES CCT , CST_RESOURCE_COSTS CRC WHERE CCT.COST_TYPE_ID = CRC.COST_TYPE_ID

View Text - HTML Formatted

SELECT CRC.ROWID
, CRC.RESOURCE_ID
, CRC.COST_TYPE_ID
, CCT.COST_TYPE
, CCT.DESCRIPTION
, CRC.LAST_UPDATE_DATE
, CRC.LAST_UPDATED_BY
, CRC.CREATION_DATE
, CRC.CREATED_BY
, CRC.LAST_UPDATE_LOGIN
, CRC.ORGANIZATION_ID
, CRC.RESOURCE_RATE
, CRC.ATTRIBUTE_CATEGORY
, CRC.ATTRIBUTE1
, CRC.ATTRIBUTE2
, CRC.ATTRIBUTE3
, CRC.ATTRIBUTE4
, CRC.ATTRIBUTE5
, CRC.ATTRIBUTE6
, CRC.ATTRIBUTE7
, CRC.ATTRIBUTE8
, CRC.ATTRIBUTE9
, CRC.ATTRIBUTE10
, CRC.ATTRIBUTE11
, CRC.ATTRIBUTE12
, CRC.ATTRIBUTE13
, CRC.ATTRIBUTE14
, CRC.ATTRIBUTE15
, CRC.REQUEST_ID
, CRC.PROGRAM_APPLICATION_ID
, CRC.PROGRAM_ID
, CRC.PROGRAM_UPDATE_DATE
, CCT.ALLOW_UPDATES_FLAG
FROM CST_COST_TYPES CCT
, CST_RESOURCE_COSTS CRC
WHERE CCT.COST_TYPE_ID = CRC.COST_TYPE_ID