VIEW: APPS.CSM_CONTR_BUSS_TXN_TYPES_V

Source

View Text - Preformatted

SELECT acc.access_id , acc.contract_service_id , acc.business_process_id , acc.txn_billing_type_id , txn_tl.name , acc.up_to_amount , acc.percent_covered FROM csm_contr_buss_txn_types_acc acc ,cs_transaction_types_tl txn_tl, cs_txn_billing_types txn_bt WHERE acc.user_id = asg_base.get_user_id AND txn_tl.language=asg_base.get_language AND acc.txn_billing_type_id = txn_bt.txn_billing_type_id AND txn_bt.transaction_type_id = txn_tl.transaction_type_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, ACC.CONTRACT_SERVICE_ID
, ACC.BUSINESS_PROCESS_ID
, ACC.TXN_BILLING_TYPE_ID
, TXN_TL.NAME
, ACC.UP_TO_AMOUNT
, ACC.PERCENT_COVERED
FROM CSM_CONTR_BUSS_TXN_TYPES_ACC ACC
, CS_TRANSACTION_TYPES_TL TXN_TL
, CS_TXN_BILLING_TYPES TXN_BT
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND TXN_TL.LANGUAGE=ASG_BASE.GET_LANGUAGE
AND ACC.TXN_BILLING_TYPE_ID = TXN_BT.TXN_BILLING_TYPE_ID
AND TXN_BT.TRANSACTION_TYPE_ID = TXN_TL.TRANSACTION_TYPE_ID