eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_AR_REC_APP_KHR_REF_V

Source

View Text - Preformatted


SELECT arapp.receivable_application_id okl_rec_app_id ,rxl.source_id okl_txd_id ,rxh.khr_id okl_khr_id ,rxl.kle_id okl_kle_id ,rxh.try_id okl_try_id ,rxl.sty_id tcl_sty_id ,rxh.trans_number tcn_trx_number ,rxh.contract_number teh_contract_number ,rxh.product_name tcn_contract_product_name ,rxh.book_classification_code tcn_book_classification_code ,rxh.tax_owner_code tcn_tax_owner_code ,rxh.rent_ia_contract_number teh_rent_ia_contract_number ,rxh.res_ia_contract_number teh_res_ia_contract_number ,rxh.converted_number teh_converted_number ,rxh.contract_effective_from teh_contract_effective_from ,rxh.contract_currency_code teh_contract_currency_code ,rxh.sales_rep_name teh_sales_rep_name ,rxh.rent_ia_product_name teh_rent_ia_product_name ,rxh.res_ia_product_name teh_res_ia_product_name ,rxh.po_order_number teh_po_order_number ,rxh.vendor_program_number teh_vendor_program_number ,rxh.rent_ia_accounting_code teh_rent_ia_accounting_code ,rxh.res_ia_accounting_code teh_res_ia_accounting_code ,rxh.assignable_flag teh_assignable_flag ,rxh.converted_account_flag teh_converted_account_flag ,rxh.accrual_override_flag teh_accrual_override_flag ,rxh.term_quote_accept_date teh_term_quote_accept_date ,rxh.term_quote_num teh_term_quote_num ,rxh.term_quote_type_code teh_term_quote_type_code ,rxh.khr_attribute_category tcn_attribute_category ,rxh.khr_attribute1 tcn_attribute1 ,rxh.khr_attribute2 tcn_attribute2 ,rxh.khr_attribute3 tcn_attribute3 ,rxh.khr_attribute4 tcn_attribute4 ,rxh.khr_attribute5 tcn_attribute5 ,rxh.khr_attribute6 tcn_attribute6 ,rxh.khr_attribute7 tcn_attribute7 ,rxh.khr_attribute8 tcn_attribute8 ,rxh.khr_attribute9 tcn_attribute9 ,rxh.khr_attribute10 tcn_attribute10 ,rxh.khr_attribute11 tcn_attribute11 ,rxh.khr_attribute12 tcn_attribute12 ,rxh.khr_attribute13 tcn_attribute13 ,rxh.khr_attribute14 tcn_attribute14 ,rxh.khr_attribute15 tcn_attribute15 ,rxh.cust_attribute_category teh_cust_attribute_category ,rxh.cust_attribute1 teh_cust_attribute1 ,rxh.cust_attribute2 teh_cust_attribute2 ,rxh.cust_attribute3 teh_cust_attribute3 ,rxh.cust_attribute4 teh_cust_attribute4 ,rxh.cust_attribute5 teh_cust_attribute5 ,rxh.cust_attribute6 teh_cust_attribute6 ,rxh.cust_attribute7 teh_cust_attribute7 ,rxh.cust_attribute8 teh_cust_attribute8 ,rxh.cust_attribute9 teh_cust_attribute9 ,rxh.cust_attribute10 teh_cust_attribute10 ,rxh.cust_attribute11 teh_cust_attribute11 ,rxh.cust_attribute12 teh_cust_attribute12 ,rxh.cust_attribute13 teh_cust_attribute13 ,rxh.cust_attribute14 teh_cust_attribute14 ,rxh.cust_attribute15 teh_cust_attribute15 ,rxh.rev_rec_method_code teh_rev_rec_method_code ,rxh.int_calc_method_code teh_int_calc_method_code ,rxl.asset_number tel_asset_number ,rxl.contract_line_number tel_contract_line_number ,rxl.asset_vendor_name tel_asset_vendor_name ,rxl.installed_site_id tel_installed_site_id ,rxl.fixed_asset_location_name tel_fixed_asset_location_name ,rxl.memo_flag tel_memo_flag ,rxl.subsidy_name okl_subsidy_name ,rxl.subsidy_party_name okl_subsidy_party_name ,rxl.accounting_template_name dist_accounting_template_name ,rxl.contingency_code okl_contingency_code ,rxl.fee_type_code tel_fee_type_code ,rxl.contract_line_type okl_khr_line_type ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute_category, NULL) tcl_asset_attribute_category ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute1, NULL) tcl_asset_attribute1 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute2, NULL) tcl_asset_attribute2 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute3, NULL) tcl_asset_attribute3 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute4, NULL) tcl_asset_attribute4 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute5, NULL) tcl_asset_attribute5 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute6, NULL) tcl_asset_attribute6 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute7, NULL) tcl_asset_attribute7 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute8, NULL) tcl_asset_attribute8 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute9, NULL) tcl_asset_attribute9 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute10, NULL) tcl_asset_attribute10 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute11, NULL) tcl_asset_attribute11 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute12, NULL) tcl_asset_attribute12 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute13, NULL) tcl_asset_attribute13 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute14, NULL) tcl_asset_attribute14 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute15, NULL) tcl_asset_attribute15 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute_category, NULL) tcl_fee_attribute_category ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute1, NULL) tcl_fee_attribute1 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute2, NULL) tcl_fee_attribute2 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute3, NULL) tcl_fee_attribute3 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute4, NULL) tcl_fee_attribute4 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute5, NULL) tcl_fee_attribute5 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute6, NULL) tcl_fee_attribute6 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute7, NULL) tcl_fee_attribute7 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute8, NULL) tcl_fee_attribute8 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute9, NULL) tcl_fee_attribute9 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute10, NULL) tcl_fee_attribute10 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute11, NULL) tcl_fee_attribute11 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute12, NULL) tcl_fee_attribute12 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute13, NULL) tcl_fee_attribute13 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute14, NULL) tcl_fee_attribute14 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute15, NULL) tcl_fee_attribute15 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute_category, NULL) tcl_service_attribute_category ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute1, NULL) tcl_service_attribute1 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute2, NULL) tcl_service_attribute2 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute3, NULL) tcl_service_attribute3 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute4, NULL) tcl_service_attribute4 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute5, NULL) tcl_service_attribute5 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute6, NULL) tcl_service_attribute6 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute7, NULL) tcl_service_attribute7 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute8, NULL) tcl_service_attribute8 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute9, NULL) tcl_service_attribute9 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute10, NULL) tcl_service_attribute10 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute11, NULL) tcl_service_attribute11 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute12, NULL) tcl_service_attribute12 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute13, NULL) tcl_service_attribute13 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute14, NULL) tcl_service_attribute14 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute15, NULL) tcl_service_attribute15 ,rxh.contract_status_code teh_contract_status_code ,rxh.trx_type_class_code teh_trx_type_class_code ,rxl.stream_type_code tcl_stream_type_code ,rxl.stream_type_purpose_code tcl_stream_type_purpose ,rxl.inventory_org_code tel_inventory_org_code FROM ar_receivable_applications_all arapp ,ar_activity_details arl ,ra_customer_trx_lines_all ractrl ,okl_ext_ar_header_sources_b rxh ,okl_ext_ar_line_sources_b rxl WHERE arapp.receivable_application_id = arl.source_id AND arl.source_table = 'RA' AND arl.customer_trx_line_id = ractrl.customer_trx_line_id AND ractrl.line_type = 'LINE' AND ractrl.interface_line_context = 'OKL_CONTRACTS' AND ractrl.interface_line_attribute14 = rxl.source_id AND rxl.source_table = 'OKL_TXD_AR_LN_DTLS_B' AND rxh.scs_code = 'LEASE' /* As this Ref. View is only for Contract Billing*/ AND rxh.header_extension_id = rxl.header_extension_id

View Text - HTML Formatted

SELECT ARAPP.RECEIVABLE_APPLICATION_ID OKL_REC_APP_ID
, RXL.SOURCE_ID OKL_TXD_ID
, RXH.KHR_ID OKL_KHR_ID
, RXL.KLE_ID OKL_KLE_ID
, RXH.TRY_ID OKL_TRY_ID
, RXL.STY_ID TCL_STY_ID
, RXH.TRANS_NUMBER TCN_TRX_NUMBER
, RXH.CONTRACT_NUMBER TEH_CONTRACT_NUMBER
, RXH.PRODUCT_NAME TCN_CONTRACT_PRODUCT_NAME
, RXH.BOOK_CLASSIFICATION_CODE TCN_BOOK_CLASSIFICATION_CODE
, RXH.TAX_OWNER_CODE TCN_TAX_OWNER_CODE
, RXH.RENT_IA_CONTRACT_NUMBER TEH_RENT_IA_CONTRACT_NUMBER
, RXH.RES_IA_CONTRACT_NUMBER TEH_RES_IA_CONTRACT_NUMBER
, RXH.CONVERTED_NUMBER TEH_CONVERTED_NUMBER
, RXH.CONTRACT_EFFECTIVE_FROM TEH_CONTRACT_EFFECTIVE_FROM
, RXH.CONTRACT_CURRENCY_CODE TEH_CONTRACT_CURRENCY_CODE
, RXH.SALES_REP_NAME TEH_SALES_REP_NAME
, RXH.RENT_IA_PRODUCT_NAME TEH_RENT_IA_PRODUCT_NAME
, RXH.RES_IA_PRODUCT_NAME TEH_RES_IA_PRODUCT_NAME
, RXH.PO_ORDER_NUMBER TEH_PO_ORDER_NUMBER
, RXH.VENDOR_PROGRAM_NUMBER TEH_VENDOR_PROGRAM_NUMBER
, RXH.RENT_IA_ACCOUNTING_CODE TEH_RENT_IA_ACCOUNTING_CODE
, RXH.RES_IA_ACCOUNTING_CODE TEH_RES_IA_ACCOUNTING_CODE
, RXH.ASSIGNABLE_FLAG TEH_ASSIGNABLE_FLAG
, RXH.CONVERTED_ACCOUNT_FLAG TEH_CONVERTED_ACCOUNT_FLAG
, RXH.ACCRUAL_OVERRIDE_FLAG TEH_ACCRUAL_OVERRIDE_FLAG
, RXH.TERM_QUOTE_ACCEPT_DATE TEH_TERM_QUOTE_ACCEPT_DATE
, RXH.TERM_QUOTE_NUM TEH_TERM_QUOTE_NUM
, RXH.TERM_QUOTE_TYPE_CODE TEH_TERM_QUOTE_TYPE_CODE
, RXH.KHR_ATTRIBUTE_CATEGORY TCN_ATTRIBUTE_CATEGORY
, RXH.KHR_ATTRIBUTE1 TCN_ATTRIBUTE1
, RXH.KHR_ATTRIBUTE2 TCN_ATTRIBUTE2
, RXH.KHR_ATTRIBUTE3 TCN_ATTRIBUTE3
, RXH.KHR_ATTRIBUTE4 TCN_ATTRIBUTE4
, RXH.KHR_ATTRIBUTE5 TCN_ATTRIBUTE5
, RXH.KHR_ATTRIBUTE6 TCN_ATTRIBUTE6
, RXH.KHR_ATTRIBUTE7 TCN_ATTRIBUTE7
, RXH.KHR_ATTRIBUTE8 TCN_ATTRIBUTE8
, RXH.KHR_ATTRIBUTE9 TCN_ATTRIBUTE9
, RXH.KHR_ATTRIBUTE10 TCN_ATTRIBUTE10
, RXH.KHR_ATTRIBUTE11 TCN_ATTRIBUTE11
, RXH.KHR_ATTRIBUTE12 TCN_ATTRIBUTE12
, RXH.KHR_ATTRIBUTE13 TCN_ATTRIBUTE13
, RXH.KHR_ATTRIBUTE14 TCN_ATTRIBUTE14
, RXH.KHR_ATTRIBUTE15 TCN_ATTRIBUTE15
, RXH.CUST_ATTRIBUTE_CATEGORY TEH_CUST_ATTRIBUTE_CATEGORY
, RXH.CUST_ATTRIBUTE1 TEH_CUST_ATTRIBUTE1
, RXH.CUST_ATTRIBUTE2 TEH_CUST_ATTRIBUTE2
, RXH.CUST_ATTRIBUTE3 TEH_CUST_ATTRIBUTE3
, RXH.CUST_ATTRIBUTE4 TEH_CUST_ATTRIBUTE4
, RXH.CUST_ATTRIBUTE5 TEH_CUST_ATTRIBUTE5
, RXH.CUST_ATTRIBUTE6 TEH_CUST_ATTRIBUTE6
, RXH.CUST_ATTRIBUTE7 TEH_CUST_ATTRIBUTE7
, RXH.CUST_ATTRIBUTE8 TEH_CUST_ATTRIBUTE8
, RXH.CUST_ATTRIBUTE9 TEH_CUST_ATTRIBUTE9
, RXH.CUST_ATTRIBUTE10 TEH_CUST_ATTRIBUTE10
, RXH.CUST_ATTRIBUTE11 TEH_CUST_ATTRIBUTE11
, RXH.CUST_ATTRIBUTE12 TEH_CUST_ATTRIBUTE12
, RXH.CUST_ATTRIBUTE13 TEH_CUST_ATTRIBUTE13
, RXH.CUST_ATTRIBUTE14 TEH_CUST_ATTRIBUTE14
, RXH.CUST_ATTRIBUTE15 TEH_CUST_ATTRIBUTE15
, RXH.REV_REC_METHOD_CODE TEH_REV_REC_METHOD_CODE
, RXH.INT_CALC_METHOD_CODE TEH_INT_CALC_METHOD_CODE
, RXL.ASSET_NUMBER TEL_ASSET_NUMBER
, RXL.CONTRACT_LINE_NUMBER TEL_CONTRACT_LINE_NUMBER
, RXL.ASSET_VENDOR_NAME TEL_ASSET_VENDOR_NAME
, RXL.INSTALLED_SITE_ID TEL_INSTALLED_SITE_ID
, RXL.FIXED_ASSET_LOCATION_NAME TEL_FIXED_ASSET_LOCATION_NAME
, RXL.MEMO_FLAG TEL_MEMO_FLAG
, RXL.SUBSIDY_NAME OKL_SUBSIDY_NAME
, RXL.SUBSIDY_PARTY_NAME OKL_SUBSIDY_PARTY_NAME
, RXL.ACCOUNTING_TEMPLATE_NAME DIST_ACCOUNTING_TEMPLATE_NAME
, RXL.CONTINGENCY_CODE OKL_CONTINGENCY_CODE
, RXL.FEE_TYPE_CODE TEL_FEE_TYPE_CODE
, RXL.CONTRACT_LINE_TYPE OKL_KHR_LINE_TYPE
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE_CATEGORY
, NULL) TCL_ASSET_ATTRIBUTE_CATEGORY
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE1
, NULL) TCL_ASSET_ATTRIBUTE1
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE2
, NULL) TCL_ASSET_ATTRIBUTE2
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE3
, NULL) TCL_ASSET_ATTRIBUTE3
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE4
, NULL) TCL_ASSET_ATTRIBUTE4
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE5
, NULL) TCL_ASSET_ATTRIBUTE5
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE6
, NULL) TCL_ASSET_ATTRIBUTE6
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE7
, NULL) TCL_ASSET_ATTRIBUTE7
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE8
, NULL) TCL_ASSET_ATTRIBUTE8
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE9
, NULL) TCL_ASSET_ATTRIBUTE9
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE10
, NULL) TCL_ASSET_ATTRIBUTE10
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE11
, NULL) TCL_ASSET_ATTRIBUTE11
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE12
, NULL) TCL_ASSET_ATTRIBUTE12
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE13
, NULL) TCL_ASSET_ATTRIBUTE13
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE14
, NULL) TCL_ASSET_ATTRIBUTE14
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE15
, NULL) TCL_ASSET_ATTRIBUTE15
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE_CATEGORY
, NULL) TCL_FEE_ATTRIBUTE_CATEGORY
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE1
, NULL) TCL_FEE_ATTRIBUTE1
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE2
, NULL) TCL_FEE_ATTRIBUTE2
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE3
, NULL) TCL_FEE_ATTRIBUTE3
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE4
, NULL) TCL_FEE_ATTRIBUTE4
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE5
, NULL) TCL_FEE_ATTRIBUTE5
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE6
, NULL) TCL_FEE_ATTRIBUTE6
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE7
, NULL) TCL_FEE_ATTRIBUTE7
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE8
, NULL) TCL_FEE_ATTRIBUTE8
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE9
, NULL) TCL_FEE_ATTRIBUTE9
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE10
, NULL) TCL_FEE_ATTRIBUTE10
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE11
, NULL) TCL_FEE_ATTRIBUTE11
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE12
, NULL) TCL_FEE_ATTRIBUTE12
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE13
, NULL) TCL_FEE_ATTRIBUTE13
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE14
, NULL) TCL_FEE_ATTRIBUTE14
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE15
, NULL) TCL_FEE_ATTRIBUTE15
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE_CATEGORY
, NULL) TCL_SERVICE_ATTRIBUTE_CATEGORY
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE1
, NULL) TCL_SERVICE_ATTRIBUTE1
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE2
, NULL) TCL_SERVICE_ATTRIBUTE2
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE3
, NULL) TCL_SERVICE_ATTRIBUTE3
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE4
, NULL) TCL_SERVICE_ATTRIBUTE4
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE5
, NULL) TCL_SERVICE_ATTRIBUTE5
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE6
, NULL) TCL_SERVICE_ATTRIBUTE6
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE7
, NULL) TCL_SERVICE_ATTRIBUTE7
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE8
, NULL) TCL_SERVICE_ATTRIBUTE8
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE9
, NULL) TCL_SERVICE_ATTRIBUTE9
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE10
, NULL) TCL_SERVICE_ATTRIBUTE10
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE11
, NULL) TCL_SERVICE_ATTRIBUTE11
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE12
, NULL) TCL_SERVICE_ATTRIBUTE12
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE13
, NULL) TCL_SERVICE_ATTRIBUTE13
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE14
, NULL) TCL_SERVICE_ATTRIBUTE14
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE15
, NULL) TCL_SERVICE_ATTRIBUTE15
, RXH.CONTRACT_STATUS_CODE TEH_CONTRACT_STATUS_CODE
, RXH.TRX_TYPE_CLASS_CODE TEH_TRX_TYPE_CLASS_CODE
, RXL.STREAM_TYPE_CODE TCL_STREAM_TYPE_CODE
, RXL.STREAM_TYPE_PURPOSE_CODE TCL_STREAM_TYPE_PURPOSE
, RXL.INVENTORY_ORG_CODE TEL_INVENTORY_ORG_CODE
FROM AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
, AR_ACTIVITY_DETAILS ARL
, RA_CUSTOMER_TRX_LINES_ALL RACTRL
, OKL_EXT_AR_HEADER_SOURCES_B RXH
, OKL_EXT_AR_LINE_SOURCES_B RXL
WHERE ARAPP.RECEIVABLE_APPLICATION_ID = ARL.SOURCE_ID
AND ARL.SOURCE_TABLE = 'RA'
AND ARL.CUSTOMER_TRX_LINE_ID = RACTRL.CUSTOMER_TRX_LINE_ID
AND RACTRL.LINE_TYPE = 'LINE'
AND RACTRL.INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS'
AND RACTRL.INTERFACE_LINE_ATTRIBUTE14 = RXL.SOURCE_ID
AND RXL.SOURCE_TABLE = 'OKL_TXD_AR_LN_DTLS_B'
AND RXH.SCS_CODE = 'LEASE' /* AS THIS REF. VIEW IS ONLY FOR CONTRACT BILLING*/
AND RXH.HEADER_EXTENSION_ID = RXL.HEADER_EXTENSION_ID