VIEW: APPS.CS_COV_BILL_RATES_V

Source

View Text - Preformatted

SELECT CBR.ROWID ROW_ID , CBR.COVERAGE_BILL_RATE_ID , CBR.COVERAGE_BILLING_TYPE_ID , CBR.RATE_TYPE_CODE , CSL.MEANING , CBR.UNIT_OF_MEASURE_CODE , UOM.UNIT_OF_MEASURE , CBR.FLAT_RATE , CBR.PERCENT_RATE , CBR.LAST_UPDATE_DATE , CBR.LAST_UPDATED_BY , CBR.CREATION_DATE , CBR.CREATED_BY , CBR.LAST_UPDATE_LOGIN , CBR.ATTRIBUTE1 , CBR.ATTRIBUTE2 , CBR.ATTRIBUTE3 , CBR.ATTRIBUTE4 , CBR.ATTRIBUTE5 , CBR.ATTRIBUTE6 , CBR.ATTRIBUTE7 , CBR.ATTRIBUTE8 , CBR.ATTRIBUTE9 , CBR.ATTRIBUTE10 , CBR.ATTRIBUTE11 , CBR.ATTRIBUTE12 , CBR.ATTRIBUTE13 , CBR.ATTRIBUTE14 , CBR.ATTRIBUTE15 , CBR.CONTEXT , CBR.OBJECT_VERSION_NUMBER FROM CS_COV_BILL_RATES CBR, CS_LOOKUPS CSL, MTL_UNITS_OF_MEASURE UOM WHERE CBR.RATE_TYPE_CODE = CSL.LOOKUP_CODE AND CSL.LOOKUP_TYPE = 'BILLING_RATE' AND CBR.UNIT_OF_MEASURE_CODE = UOM.UOM_CODE(+)

View Text - HTML Formatted

SELECT CBR.ROWID ROW_ID
, CBR.COVERAGE_BILL_RATE_ID
, CBR.COVERAGE_BILLING_TYPE_ID
, CBR.RATE_TYPE_CODE
, CSL.MEANING
, CBR.UNIT_OF_MEASURE_CODE
, UOM.UNIT_OF_MEASURE
, CBR.FLAT_RATE
, CBR.PERCENT_RATE
, CBR.LAST_UPDATE_DATE
, CBR.LAST_UPDATED_BY
, CBR.CREATION_DATE
, CBR.CREATED_BY
, CBR.LAST_UPDATE_LOGIN
, CBR.ATTRIBUTE1
, CBR.ATTRIBUTE2
, CBR.ATTRIBUTE3
, CBR.ATTRIBUTE4
, CBR.ATTRIBUTE5
, CBR.ATTRIBUTE6
, CBR.ATTRIBUTE7
, CBR.ATTRIBUTE8
, CBR.ATTRIBUTE9
, CBR.ATTRIBUTE10
, CBR.ATTRIBUTE11
, CBR.ATTRIBUTE12
, CBR.ATTRIBUTE13
, CBR.ATTRIBUTE14
, CBR.ATTRIBUTE15
, CBR.CONTEXT
, CBR.OBJECT_VERSION_NUMBER
FROM CS_COV_BILL_RATES CBR
, CS_LOOKUPS CSL
, MTL_UNITS_OF_MEASURE UOM
WHERE CBR.RATE_TYPE_CODE = CSL.LOOKUP_CODE
AND CSL.LOOKUP_TYPE = 'BILLING_RATE'
AND CBR.UNIT_OF_MEASURE_CODE = UOM.UOM_CODE(+)