VIEW: APPS.CS_ESTCOV_BILLING_TYPES_V

Source

View Text - Preformatted

SELECT tt.name || '-' || lu.meaning name, cbt.max_percent_per_use, cbt.max_amount_per_use, cbt.coverage_txn_group_id, cbt.coverage_billing_type_id FROM cs_cov_billing_types cbt, cs_txn_billing_types tbt, cs_transaction_types tt, cs_lookups lu WHERE cbt.txn_billing_type_id = tbt.txn_billing_type_id AND tbt. transaction_type_id = tt.transaction_type_id AND lu.lookup_type = 'MTL_SERVICE_BILLABLE_FLAG' AND tbt.billing_type = lu.lookup_code

View Text - HTML Formatted

SELECT TT.NAME || '-' || LU.MEANING NAME
, CBT.MAX_PERCENT_PER_USE
, CBT.MAX_AMOUNT_PER_USE
, CBT.COVERAGE_TXN_GROUP_ID
, CBT.COVERAGE_BILLING_TYPE_ID
FROM CS_COV_BILLING_TYPES CBT
, CS_TXN_BILLING_TYPES TBT
, CS_TRANSACTION_TYPES TT
, CS_LOOKUPS LU
WHERE CBT.TXN_BILLING_TYPE_ID = TBT.TXN_BILLING_TYPE_ID
AND TBT. TRANSACTION_TYPE_ID = TT.TRANSACTION_TYPE_ID
AND LU.LOOKUP_TYPE = 'MTL_SERVICE_BILLABLE_FLAG'
AND TBT.BILLING_TYPE = LU.LOOKUP_CODE