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_INV_KHR_REF_V

Source

View Text - Preformatted


SELECT txd.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 okl_sty_id ,rxh.trans_number okl_trans_number ,rxh.contract_number okl_contract_number ,rxh.product_name okl_product_name ,rxh.book_classification_code okl_book_classification_code ,rxh.tax_owner_code okl_tax_owner_code ,rxh.rent_ia_contract_number okl_rent_ia_contract_number ,rxh.res_ia_contract_number okl_res_ia_contract_number ,rxh.converted_number okl_converted_number ,rxh.contract_effective_from okl_contract_effective_from ,rxh.contract_currency_code okl_contract_currency_code ,rxh.sales_rep_name okl_sales_rep_name ,rxh.rent_ia_product_name okl_rent_ia_product_name ,rxh.res_ia_product_name okl_res_ia_product_name ,rxh.po_order_number okl_po_order_number ,rxh.vendor_program_number okl_vendor_program_number ,rxh.rent_ia_accounting_code okl_rent_ia_accounting_code ,rxh.res_ia_accounting_code okl_res_ia_accounting_code ,rxh.assignable_flag okl_assignable_flag ,rxh.converted_account_flag okl_converted_account_flag ,rxh.accrual_override_flag okl_khr_accrual_override_flag ,rxh.term_quote_accept_date okl_term_quote_accept_date ,rxh.term_quote_num okl_term_quote_num ,rxh.term_quote_type_code okl_term_quote_type_code ,rxh.khr_attribute_category okl_khr_attribute_category ,rxh.khr_attribute1 okl_khr_attribute1 ,rxh.khr_attribute2 okl_khr_attribute2 ,rxh.khr_attribute3 okl_khr_attribute3 ,rxh.khr_attribute4 okl_khr_attribute4 ,rxh.khr_attribute5 okl_khr_attribute5 ,rxh.khr_attribute6 okl_khr_attribute6 ,rxh.khr_attribute7 okl_khr_attribute7 ,rxh.khr_attribute8 okl_khr_attribute8 ,rxh.khr_attribute9 okl_khr_attribute9 ,rxh.khr_attribute10 okl_khr_attribute10 ,rxh.khr_attribute11 okl_khr_attribute11 ,rxh.khr_attribute12 okl_khr_attribute12 ,rxh.khr_attribute13 okl_khr_attribute13 ,rxh.khr_attribute14 okl_khr_attribute14 ,rxh.khr_attribute15 okl_khr_attribute15 ,rxh.cust_attribute_category okl_cust_attribute_category ,rxh.cust_attribute1 okl_cust_attribute1 ,rxh.cust_attribute2 okl_cust_attribute2 ,rxh.cust_attribute3 okl_cust_attribute3 ,rxh.cust_attribute4 okl_cust_attribute4 ,rxh.cust_attribute5 okl_cust_attribute5 ,rxh.cust_attribute6 okl_cust_attribute6 ,rxh.cust_attribute7 okl_cust_attribute7 ,rxh.cust_attribute8 okl_cust_attribute8 ,rxh.cust_attribute9 okl_cust_attribute9 ,rxh.cust_attribute10 okl_cust_attribute10 ,rxh.cust_attribute11 okl_cust_attribute11 ,rxh.cust_attribute12 okl_cust_attribute12 ,rxh.cust_attribute13 okl_cust_attribute13 ,rxh.cust_attribute14 okl_cust_attribute14 ,rxh.cust_attribute15 okl_cust_attribute15 ,rxh.rev_rec_method_code okl_rev_rec_method_code ,rxh.int_calc_method_code okl_int_calc_method_code ,rxl.asset_number okl_asset_number ,rxl.contract_line_number okl_contract_line_number ,rxl.asset_vendor_name okl_asset_vendor_name ,rxl.installed_site_id okl_installed_site_id ,rxl.fixed_asset_location_name okl_fixed_asset_location_name ,rxl.memo_flag okl_memo_flag ,rxl.subsidy_name okl_subsidy_name ,rxl.subsidy_party_name okl_subsidy_party_name ,rxl.accounting_template_name okl_ae_template_name ,rxl.contingency_code okl_contingency_code ,rxl.fee_type_code okl_fee_type_code ,rxl.contract_line_type okl_contract_line_type ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute_category, NULL) okl_asset_attribute_category ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute1, NULL) okl_asset_attribute1 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute2, NULL) okl_asset_attribute2 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute3, NULL) okl_asset_attribute3 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute4, NULL) okl_asset_attribute4 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute5, NULL) okl_asset_attribute5 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute6, NULL) okl_asset_attribute6 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute7, NULL) okl_asset_attribute7 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute8, NULL) okl_asset_attribute8 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute9, NULL) okl_asset_attribute9 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute10, NULL) okl_asset_attribute10 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute11, NULL) okl_asset_attribute11 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute12, NULL) okl_asset_attribute12 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute13, NULL) okl_asset_attribute13 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute14, NULL) okl_asset_attribute14 ,DECODE( rxl.contract_line_type, 'FREE_FORM1', rxl.line_attribute15, NULL) okl_asset_attribute15 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute_category, NULL) okl_fee_attribute_category ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute1, NULL) okl_fee_attribute1 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute2, NULL) okl_fee_attribute2 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute3, NULL) okl_fee_attribute3 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute4, NULL) okl_fee_attribute4 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute5, NULL) okl_fee_attribute5 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute6, NULL) okl_fee_attribute6 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute7, NULL) okl_fee_attribute7 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute8, NULL) okl_fee_attribute8 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute9, NULL) okl_fee_attribute9 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute10, NULL) okl_fee_attribute10 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute11, NULL) okl_fee_attribute11 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute12, NULL) okl_fee_attribute12 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute13, NULL) okl_fee_attribute13 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute14, NULL) okl_fee_attribute14 ,DECODE( rxl.contract_line_type, 'FEE', rxl.line_attribute15, NULL) okl_fee_attribute15 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute_category, NULL) okl_service_attribute_category ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute1, NULL) okl_service_attribute1 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute2, NULL) okl_service_attribute2 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute3, NULL) okl_service_attribute3 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute4, NULL) okl_service_attribute4 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute5, NULL) okl_service_attribute5 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute6, NULL) okl_service_attribute6 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute7, NULL) okl_service_attribute7 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute8, NULL) okl_service_attribute8 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute9, NULL) okl_service_attribute9 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute10, NULL) okl_service_attribute10 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute11, NULL) okl_service_attribute11 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute12, NULL) okl_service_attribute12 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute13, NULL) okl_service_attribute13 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute14, NULL) okl_service_attribute14 ,DECODE( rxl.contract_line_type, 'SERVICE', rxl.line_attribute15, NULL) okl_service_attribute15 ,rxh.contract_status_code okl_contract_status_code ,rxh.trx_type_class_code okl_trx_type_class_code ,rxl.stream_type_code okl_stream_type_code ,rxl.stream_type_purpose_code okl_stream_type_purpose_code ,rxl.inventory_org_code okl_inventory_org_code FROM OKL_EXT_AR_HEADER_SOURCES_B RXH,OKL_EXT_AR_LINE_SOURCES_B RXL,OKL_TXD_AR_LN_DTLS_B TXD WHERE 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 AND rxl.source_id = txd.id

View Text - HTML Formatted

SELECT TXD.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 OKL_STY_ID
, RXH.TRANS_NUMBER OKL_TRANS_NUMBER
, RXH.CONTRACT_NUMBER OKL_CONTRACT_NUMBER
, RXH.PRODUCT_NAME OKL_PRODUCT_NAME
, RXH.BOOK_CLASSIFICATION_CODE OKL_BOOK_CLASSIFICATION_CODE
, RXH.TAX_OWNER_CODE OKL_TAX_OWNER_CODE
, RXH.RENT_IA_CONTRACT_NUMBER OKL_RENT_IA_CONTRACT_NUMBER
, RXH.RES_IA_CONTRACT_NUMBER OKL_RES_IA_CONTRACT_NUMBER
, RXH.CONVERTED_NUMBER OKL_CONVERTED_NUMBER
, RXH.CONTRACT_EFFECTIVE_FROM OKL_CONTRACT_EFFECTIVE_FROM
, RXH.CONTRACT_CURRENCY_CODE OKL_CONTRACT_CURRENCY_CODE
, RXH.SALES_REP_NAME OKL_SALES_REP_NAME
, RXH.RENT_IA_PRODUCT_NAME OKL_RENT_IA_PRODUCT_NAME
, RXH.RES_IA_PRODUCT_NAME OKL_RES_IA_PRODUCT_NAME
, RXH.PO_ORDER_NUMBER OKL_PO_ORDER_NUMBER
, RXH.VENDOR_PROGRAM_NUMBER OKL_VENDOR_PROGRAM_NUMBER
, RXH.RENT_IA_ACCOUNTING_CODE OKL_RENT_IA_ACCOUNTING_CODE
, RXH.RES_IA_ACCOUNTING_CODE OKL_RES_IA_ACCOUNTING_CODE
, RXH.ASSIGNABLE_FLAG OKL_ASSIGNABLE_FLAG
, RXH.CONVERTED_ACCOUNT_FLAG OKL_CONVERTED_ACCOUNT_FLAG
, RXH.ACCRUAL_OVERRIDE_FLAG OKL_KHR_ACCRUAL_OVERRIDE_FLAG
, RXH.TERM_QUOTE_ACCEPT_DATE OKL_TERM_QUOTE_ACCEPT_DATE
, RXH.TERM_QUOTE_NUM OKL_TERM_QUOTE_NUM
, RXH.TERM_QUOTE_TYPE_CODE OKL_TERM_QUOTE_TYPE_CODE
, RXH.KHR_ATTRIBUTE_CATEGORY OKL_KHR_ATTRIBUTE_CATEGORY
, RXH.KHR_ATTRIBUTE1 OKL_KHR_ATTRIBUTE1
, RXH.KHR_ATTRIBUTE2 OKL_KHR_ATTRIBUTE2
, RXH.KHR_ATTRIBUTE3 OKL_KHR_ATTRIBUTE3
, RXH.KHR_ATTRIBUTE4 OKL_KHR_ATTRIBUTE4
, RXH.KHR_ATTRIBUTE5 OKL_KHR_ATTRIBUTE5
, RXH.KHR_ATTRIBUTE6 OKL_KHR_ATTRIBUTE6
, RXH.KHR_ATTRIBUTE7 OKL_KHR_ATTRIBUTE7
, RXH.KHR_ATTRIBUTE8 OKL_KHR_ATTRIBUTE8
, RXH.KHR_ATTRIBUTE9 OKL_KHR_ATTRIBUTE9
, RXH.KHR_ATTRIBUTE10 OKL_KHR_ATTRIBUTE10
, RXH.KHR_ATTRIBUTE11 OKL_KHR_ATTRIBUTE11
, RXH.KHR_ATTRIBUTE12 OKL_KHR_ATTRIBUTE12
, RXH.KHR_ATTRIBUTE13 OKL_KHR_ATTRIBUTE13
, RXH.KHR_ATTRIBUTE14 OKL_KHR_ATTRIBUTE14
, RXH.KHR_ATTRIBUTE15 OKL_KHR_ATTRIBUTE15
, RXH.CUST_ATTRIBUTE_CATEGORY OKL_CUST_ATTRIBUTE_CATEGORY
, RXH.CUST_ATTRIBUTE1 OKL_CUST_ATTRIBUTE1
, RXH.CUST_ATTRIBUTE2 OKL_CUST_ATTRIBUTE2
, RXH.CUST_ATTRIBUTE3 OKL_CUST_ATTRIBUTE3
, RXH.CUST_ATTRIBUTE4 OKL_CUST_ATTRIBUTE4
, RXH.CUST_ATTRIBUTE5 OKL_CUST_ATTRIBUTE5
, RXH.CUST_ATTRIBUTE6 OKL_CUST_ATTRIBUTE6
, RXH.CUST_ATTRIBUTE7 OKL_CUST_ATTRIBUTE7
, RXH.CUST_ATTRIBUTE8 OKL_CUST_ATTRIBUTE8
, RXH.CUST_ATTRIBUTE9 OKL_CUST_ATTRIBUTE9
, RXH.CUST_ATTRIBUTE10 OKL_CUST_ATTRIBUTE10
, RXH.CUST_ATTRIBUTE11 OKL_CUST_ATTRIBUTE11
, RXH.CUST_ATTRIBUTE12 OKL_CUST_ATTRIBUTE12
, RXH.CUST_ATTRIBUTE13 OKL_CUST_ATTRIBUTE13
, RXH.CUST_ATTRIBUTE14 OKL_CUST_ATTRIBUTE14
, RXH.CUST_ATTRIBUTE15 OKL_CUST_ATTRIBUTE15
, RXH.REV_REC_METHOD_CODE OKL_REV_REC_METHOD_CODE
, RXH.INT_CALC_METHOD_CODE OKL_INT_CALC_METHOD_CODE
, RXL.ASSET_NUMBER OKL_ASSET_NUMBER
, RXL.CONTRACT_LINE_NUMBER OKL_CONTRACT_LINE_NUMBER
, RXL.ASSET_VENDOR_NAME OKL_ASSET_VENDOR_NAME
, RXL.INSTALLED_SITE_ID OKL_INSTALLED_SITE_ID
, RXL.FIXED_ASSET_LOCATION_NAME OKL_FIXED_ASSET_LOCATION_NAME
, RXL.MEMO_FLAG OKL_MEMO_FLAG
, RXL.SUBSIDY_NAME OKL_SUBSIDY_NAME
, RXL.SUBSIDY_PARTY_NAME OKL_SUBSIDY_PARTY_NAME
, RXL.ACCOUNTING_TEMPLATE_NAME OKL_AE_TEMPLATE_NAME
, RXL.CONTINGENCY_CODE OKL_CONTINGENCY_CODE
, RXL.FEE_TYPE_CODE OKL_FEE_TYPE_CODE
, RXL.CONTRACT_LINE_TYPE OKL_CONTRACT_LINE_TYPE
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE_CATEGORY
, NULL) OKL_ASSET_ATTRIBUTE_CATEGORY
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE1
, NULL) OKL_ASSET_ATTRIBUTE1
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE2
, NULL) OKL_ASSET_ATTRIBUTE2
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE3
, NULL) OKL_ASSET_ATTRIBUTE3
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE4
, NULL) OKL_ASSET_ATTRIBUTE4
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE5
, NULL) OKL_ASSET_ATTRIBUTE5
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE6
, NULL) OKL_ASSET_ATTRIBUTE6
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE7
, NULL) OKL_ASSET_ATTRIBUTE7
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE8
, NULL) OKL_ASSET_ATTRIBUTE8
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE9
, NULL) OKL_ASSET_ATTRIBUTE9
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE10
, NULL) OKL_ASSET_ATTRIBUTE10
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE11
, NULL) OKL_ASSET_ATTRIBUTE11
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE12
, NULL) OKL_ASSET_ATTRIBUTE12
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE13
, NULL) OKL_ASSET_ATTRIBUTE13
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE14
, NULL) OKL_ASSET_ATTRIBUTE14
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, RXL.LINE_ATTRIBUTE15
, NULL) OKL_ASSET_ATTRIBUTE15
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE_CATEGORY
, NULL) OKL_FEE_ATTRIBUTE_CATEGORY
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE1
, NULL) OKL_FEE_ATTRIBUTE1
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE2
, NULL) OKL_FEE_ATTRIBUTE2
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE3
, NULL) OKL_FEE_ATTRIBUTE3
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE4
, NULL) OKL_FEE_ATTRIBUTE4
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE5
, NULL) OKL_FEE_ATTRIBUTE5
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE6
, NULL) OKL_FEE_ATTRIBUTE6
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE7
, NULL) OKL_FEE_ATTRIBUTE7
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE8
, NULL) OKL_FEE_ATTRIBUTE8
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE9
, NULL) OKL_FEE_ATTRIBUTE9
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE10
, NULL) OKL_FEE_ATTRIBUTE10
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE11
, NULL) OKL_FEE_ATTRIBUTE11
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE12
, NULL) OKL_FEE_ATTRIBUTE12
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE13
, NULL) OKL_FEE_ATTRIBUTE13
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE14
, NULL) OKL_FEE_ATTRIBUTE14
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'FEE'
, RXL.LINE_ATTRIBUTE15
, NULL) OKL_FEE_ATTRIBUTE15
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE_CATEGORY
, NULL) OKL_SERVICE_ATTRIBUTE_CATEGORY
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE1
, NULL) OKL_SERVICE_ATTRIBUTE1
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE2
, NULL) OKL_SERVICE_ATTRIBUTE2
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE3
, NULL) OKL_SERVICE_ATTRIBUTE3
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE4
, NULL) OKL_SERVICE_ATTRIBUTE4
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE5
, NULL) OKL_SERVICE_ATTRIBUTE5
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE6
, NULL) OKL_SERVICE_ATTRIBUTE6
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE7
, NULL) OKL_SERVICE_ATTRIBUTE7
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE8
, NULL) OKL_SERVICE_ATTRIBUTE8
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE9
, NULL) OKL_SERVICE_ATTRIBUTE9
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE10
, NULL) OKL_SERVICE_ATTRIBUTE10
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE11
, NULL) OKL_SERVICE_ATTRIBUTE11
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE12
, NULL) OKL_SERVICE_ATTRIBUTE12
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE13
, NULL) OKL_SERVICE_ATTRIBUTE13
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE14
, NULL) OKL_SERVICE_ATTRIBUTE14
, DECODE( RXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, RXL.LINE_ATTRIBUTE15
, NULL) OKL_SERVICE_ATTRIBUTE15
, RXH.CONTRACT_STATUS_CODE OKL_CONTRACT_STATUS_CODE
, RXH.TRX_TYPE_CLASS_CODE OKL_TRX_TYPE_CLASS_CODE
, RXL.STREAM_TYPE_CODE OKL_STREAM_TYPE_CODE
, RXL.STREAM_TYPE_PURPOSE_CODE OKL_STREAM_TYPE_PURPOSE_CODE
, RXL.INVENTORY_ORG_CODE OKL_INVENTORY_ORG_CODE
FROM OKL_EXT_AR_HEADER_SOURCES_B RXH
, OKL_EXT_AR_LINE_SOURCES_B RXL
, OKL_TXD_AR_LN_DTLS_B TXD
WHERE 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
AND RXL.SOURCE_ID = TXD.ID