VIEW: APPS.OKL_AR_RECEIPT_KHR_REF_V

Source

View Text - Preformatted

SELECT rxh.source_id okl_ar_receipt_id ,rxh.khr_id okl_khr_id ,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.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 ,rxh.contract_status_code teh_contract_status_code FROM OKL_EXT_AR_HEADER_SOURCES_B RXH WHERE rxh.source_table = 'AR_CASH_RECEIPTS' AND rxh.scs_code = 'LEASE'

View Text - HTML Formatted

SELECT RXH.SOURCE_ID OKL_AR_RECEIPT_ID
, RXH.KHR_ID OKL_KHR_ID
, 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.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
, RXH.CONTRACT_STATUS_CODE TEH_CONTRACT_STATUS_CODE
FROM OKL_EXT_AR_HEADER_SOURCES_B RXH
WHERE RXH.SOURCE_TABLE = 'AR_CASH_RECEIPTS'
AND RXH.SCS_CODE = 'LEASE'