VIEW: APPS.CSF_M_TXN_BILLING_TYPES_V

Source

View Text - Preformatted

SELECT acc.access_id, tbt.txn_billing_type_id, tbt.transaction_type_id, tbt.billing_type, tt_tl.name, tt_tl.description, ttb.line_order_category_code, bpr.business_process_id, bpr.name as business_process_name, cbtc.billing_category, tbt.START_DATE_ACTIVE,tbt.END_DATE_ACTIVE FROM csm_txn_billing_types_acc acc, cs_txn_billing_types tbt, cs_transaction_types_b ttb, cs_transaction_types_tl tt_tl, cs_business_processes bpr, cs_bus_process_txns bpt, CS_BILLING_TYPE_CATEGORIES cbtc WHERE acc.txn_billing_type_id = tbt.txn_billing_type_id AND acc.business_process_id = bpt.business_process_id AND tbt.transaction_type_id = ttb.transaction_type_id AND tt_tl.transaction_type_id = tbt.transaction_type_id AND tt_tl.language = asg_base.get_language AND tbt.billing_type = cbtc.billing_type AND cbtc.billing_category IN ( 'L', 'E', 'M' ) AND bpt.transaction_type_id = tbt.transaction_type_id AND bpr.business_process_id = bpt.business_process_id AND bpr.field_service_flag = 'Y'

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, TBT.TXN_BILLING_TYPE_ID
, TBT.TRANSACTION_TYPE_ID
, TBT.BILLING_TYPE
, TT_TL.NAME
, TT_TL.DESCRIPTION
, TTB.LINE_ORDER_CATEGORY_CODE
, BPR.BUSINESS_PROCESS_ID
, BPR.NAME AS BUSINESS_PROCESS_NAME
, CBTC.BILLING_CATEGORY
, TBT.START_DATE_ACTIVE
, TBT.END_DATE_ACTIVE
FROM CSM_TXN_BILLING_TYPES_ACC ACC
, CS_TXN_BILLING_TYPES TBT
, CS_TRANSACTION_TYPES_B TTB
, CS_TRANSACTION_TYPES_TL TT_TL
, CS_BUSINESS_PROCESSES BPR
, CS_BUS_PROCESS_TXNS BPT
, CS_BILLING_TYPE_CATEGORIES CBTC
WHERE ACC.TXN_BILLING_TYPE_ID = TBT.TXN_BILLING_TYPE_ID
AND ACC.BUSINESS_PROCESS_ID = BPT.BUSINESS_PROCESS_ID
AND TBT.TRANSACTION_TYPE_ID = TTB.TRANSACTION_TYPE_ID
AND TT_TL.TRANSACTION_TYPE_ID = TBT.TRANSACTION_TYPE_ID
AND TT_TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND TBT.BILLING_TYPE = CBTC.BILLING_TYPE
AND CBTC.BILLING_CATEGORY IN ( 'L'
, 'E'
, 'M' )
AND BPT.TRANSACTION_TYPE_ID = TBT.TRANSACTION_TYPE_ID
AND BPR.BUSINESS_PROCESS_ID = BPT.BUSINESS_PROCESS_ID
AND BPR.FIELD_SERVICE_FLAG = 'Y'