VIEW: APPS.CS_COV_BILLING_TYPES_V

Source

View Text - Preformatted

SELECT CBT.ROWID ROW_ID , CBT.COVERAGE_BILLING_TYPE_ID , CBT.COVERAGE_TXN_GROUP_ID , CBT.TXN_BILLING_TYPE_ID , CTBT.BILLING_TYPE , CTT.NAME||'-'||CSL.MEANING NAME , CBT.MAX_PERCENT_PER_USE , CBT.MAX_AMOUNT_PER_USE , CBT.LAST_UPDATE_DATE , CBT.LAST_UPDATED_BY , CBT.CREATION_DATE , CBT.CREATED_BY , CBT.LAST_UPDATE_LOGIN , CBT.ATTRIBUTE1 , CBT.ATTRIBUTE2 , CBT.ATTRIBUTE3 , CBT.ATTRIBUTE4 , CBT.ATTRIBUTE5 , CBT.ATTRIBUTE6 , CBT.ATTRIBUTE7 , CBT.ATTRIBUTE8 , CBT.ATTRIBUTE9 , CBT.ATTRIBUTE10 , CBT.ATTRIBUTE11 , CBT.ATTRIBUTE12 , CBT.ATTRIBUTE13 , CBT.ATTRIBUTE14 , CBT.ATTRIBUTE15 , CBT.CONTEXT , CBT.OBJECT_VERSION_NUMBER FROM CS_COV_BILLING_TYPES CBT, CS_TRANSACTION_TYPES CTT, CS_TXN_BILLING_TYPES CTBT, CS_LOOKUPS CSL WHERE CBT.TXN_BILLING_TYPE_ID = CTBT.TXN_BILLING_TYPE_ID AND CTBT.TRANSACTION_TYPE_ID = CTT.TRANSACTION_TYPE_ID AND CTBT.BILLING_TYPE = CSL.LOOKUP_CODE AND CSL.LOOKUP_TYPE = 'MTL_SERVICE_BILLABLE_FLAG'

View Text - HTML Formatted

SELECT CBT.ROWID ROW_ID
, CBT.COVERAGE_BILLING_TYPE_ID
, CBT.COVERAGE_TXN_GROUP_ID
, CBT.TXN_BILLING_TYPE_ID
, CTBT.BILLING_TYPE
, CTT.NAME||'-'||CSL.MEANING NAME
, CBT.MAX_PERCENT_PER_USE
, CBT.MAX_AMOUNT_PER_USE
, CBT.LAST_UPDATE_DATE
, CBT.LAST_UPDATED_BY
, CBT.CREATION_DATE
, CBT.CREATED_BY
, CBT.LAST_UPDATE_LOGIN
, CBT.ATTRIBUTE1
, CBT.ATTRIBUTE2
, CBT.ATTRIBUTE3
, CBT.ATTRIBUTE4
, CBT.ATTRIBUTE5
, CBT.ATTRIBUTE6
, CBT.ATTRIBUTE7
, CBT.ATTRIBUTE8
, CBT.ATTRIBUTE9
, CBT.ATTRIBUTE10
, CBT.ATTRIBUTE11
, CBT.ATTRIBUTE12
, CBT.ATTRIBUTE13
, CBT.ATTRIBUTE14
, CBT.ATTRIBUTE15
, CBT.CONTEXT
, CBT.OBJECT_VERSION_NUMBER
FROM CS_COV_BILLING_TYPES CBT
, CS_TRANSACTION_TYPES CTT
, CS_TXN_BILLING_TYPES CTBT
, CS_LOOKUPS CSL
WHERE CBT.TXN_BILLING_TYPE_ID = CTBT.TXN_BILLING_TYPE_ID
AND CTBT.TRANSACTION_TYPE_ID = CTT.TRANSACTION_TYPE_ID
AND CTBT.BILLING_TYPE = CSL.LOOKUP_CODE
AND CSL.LOOKUP_TYPE = 'MTL_SERVICE_BILLABLE_FLAG'