VIEW: APPS.OKL_FA_DEP_REF_V

Source

View Text - Preformatted

SELECT fxl.fa_transaction_id okl_deprn_run_id ,fxl.asset_book_type_code okl_asset_book_type_code ,fxl.period_counter okl_period_counter ,fxl.asset_id okl_asset_id /* Other Foreign Keys */ ,fxh.khr_id okl_khr_id ,fxl.kle_id okl_kle_id ,fxl.asset_number okl_asset_number /* Contract Related Sources */ ,fxh.contract_number okl_contract_number ,fxh.customer_name okl_customer_name ,fxh.customer_account_number okl_customer_account_number ,fxh.converted_number okl_converted_number ,fxh.contract_effective_from okl_contract_effective_from ,fxh.contract_currency_code okl_contract_currency_code ,fxh.sales_rep_name okl_sales_rep_name ,fxh.po_order_number okl_po_order_number ,fxh.vendor_program_number okl_vendor_program_number ,fxh.assignable_flag okl_assignable_flag ,fxh.converted_account_flag okl_converted_account_flag ,fxh.accrual_override_flag okl_khr_accrual_override_flag /* Contract DFF information */ ,fxh.khr_attribute_category okl_khr_attribute_category ,fxh.khr_attribute1 okl_khr_attribute1 ,fxh.khr_attribute2 okl_khr_attribute2 ,fxh.khr_attribute3 okl_khr_attribute3 ,fxh.khr_attribute4 okl_khr_attribute4 ,fxh.khr_attribute5 okl_khr_attribute5 ,fxh.khr_attribute6 okl_khr_attribute6 ,fxh.khr_attribute7 okl_khr_attribute7 ,fxh.khr_attribute8 okl_khr_attribute8 ,fxh.khr_attribute9 okl_khr_attribute9 ,fxh.khr_attribute10 okl_khr_attribute10 ,fxh.khr_attribute11 okl_khr_attribute11 ,fxh.khr_attribute12 okl_khr_attribute12 ,fxh.khr_attribute13 okl_khr_attribute13 ,fxh.khr_attribute14 okl_khr_attribute14 ,fxh.khr_attribute15 okl_khr_attribute15 /* Customer DFF information */ ,fxh.cust_attribute_category okl_cust_attribute_category ,fxh.cust_attribute1 okl_cust_attribute1 ,fxh.cust_attribute2 okl_cust_attribute2 ,fxh.cust_attribute3 okl_cust_attribute3 ,fxh.cust_attribute4 okl_cust_attribute4 ,fxh.cust_attribute5 okl_cust_attribute5 ,fxh.cust_attribute6 okl_cust_attribute6 ,fxh.cust_attribute7 okl_cust_attribute7 ,fxh.cust_attribute8 okl_cust_attribute8 ,fxh.cust_attribute9 okl_cust_attribute9 ,fxh.cust_attribute10 okl_cust_attribute10 ,fxh.cust_attribute11 okl_cust_attribute11 ,fxh.cust_attribute12 okl_cust_attribute12 ,fxh.cust_attribute13 okl_cust_attribute13 ,fxh.cust_attribute14 okl_cust_attribute14 ,fxh.cust_attribute15 okl_cust_attribute15 /*Products and Quality related Sources */ ,fxh.product_name okl_product_name ,fxh.book_classification_code okl_book_classification_code ,fxh.tax_owner_code okl_tax_owner_code ,fxh.int_calc_method_code okl_int_calc_method_code ,fxh.rev_rec_method_code okl_rev_rec_method_code /* Contract Line Related Information */ ,fxl.contract_line_number okl_contract_line_number ,fxl.asset_book_type_name okl_asset_book_type_name ,fxl.asset_vendor_name okl_asset_vendor_name ,fxl.installed_site_id okl_installed_site_id /* Asset DFF Information */ ,fxl.line_attribute_category okl_asset_attribute_category ,fxl.line_attribute1 okl_asset_attribute1 ,fxl.line_attribute2 okl_asset_attribute2 ,fxl.line_attribute3 okl_asset_attribute3 ,fxl.line_attribute4 okl_asset_attribute4 ,fxl.line_attribute5 okl_asset_attribute5 ,fxl.line_attribute6 okl_asset_attribute6 ,fxl.line_attribute7 okl_asset_attribute7 ,fxl.line_attribute8 okl_asset_attribute8 ,fxl.line_attribute9 okl_asset_attribute9 ,fxl.line_attribute10 okl_asset_attribute10 ,fxl.line_attribute11 okl_asset_attribute11 ,fxl.line_attribute12 okl_asset_attribute12 ,fxl.line_attribute13 okl_asset_attribute13 ,fxl.line_attribute14 okl_asset_attribute14 ,fxl.line_attribute15 okl_asset_attribute15 /* Rent Investor Agreement Related Sources */ ,fxh.rent_ia_contract_number okl_rent_ia_contract_number ,fxh.rent_ia_product_name okl_rent_ia_product_name ,fxh.rent_ia_accounting_code okl_rent_ia_accounting_code /* Residual Investor Agreement Related Sources */ ,fxh.res_ia_contract_number okl_res_ia_contract_number ,fxh.res_ia_product_name okl_res_ia_product_name ,fxh.res_ia_accounting_code okl_res_ia_accounting_code /* Equivalent Codes for the Translatable Sources */ ,fxh.contract_status_code okl_contract_status_code ,fxl.inventory_org_code okl_inventory_org_code FROM OKL_EXT_FA_HEADER_SOURCES_B FXH,OKL_EXT_FA_LINE_SOURCES_B FXL WHERE fxl.source_table = 'FA_DEPRN_SUMMARY' AND fxh.header_extension_id = fxl.header_extension_id

View Text - HTML Formatted

SELECT FXL.FA_TRANSACTION_ID OKL_DEPRN_RUN_ID
, FXL.ASSET_BOOK_TYPE_CODE OKL_ASSET_BOOK_TYPE_CODE
, FXL.PERIOD_COUNTER OKL_PERIOD_COUNTER
, FXL.ASSET_ID OKL_ASSET_ID /* OTHER FOREIGN KEYS */
, FXH.KHR_ID OKL_KHR_ID
, FXL.KLE_ID OKL_KLE_ID
, FXL.ASSET_NUMBER OKL_ASSET_NUMBER /* CONTRACT RELATED SOURCES */
, FXH.CONTRACT_NUMBER OKL_CONTRACT_NUMBER
, FXH.CUSTOMER_NAME OKL_CUSTOMER_NAME
, FXH.CUSTOMER_ACCOUNT_NUMBER OKL_CUSTOMER_ACCOUNT_NUMBER
, FXH.CONVERTED_NUMBER OKL_CONVERTED_NUMBER
, FXH.CONTRACT_EFFECTIVE_FROM OKL_CONTRACT_EFFECTIVE_FROM
, FXH.CONTRACT_CURRENCY_CODE OKL_CONTRACT_CURRENCY_CODE
, FXH.SALES_REP_NAME OKL_SALES_REP_NAME
, FXH.PO_ORDER_NUMBER OKL_PO_ORDER_NUMBER
, FXH.VENDOR_PROGRAM_NUMBER OKL_VENDOR_PROGRAM_NUMBER
, FXH.ASSIGNABLE_FLAG OKL_ASSIGNABLE_FLAG
, FXH.CONVERTED_ACCOUNT_FLAG OKL_CONVERTED_ACCOUNT_FLAG
, FXH.ACCRUAL_OVERRIDE_FLAG OKL_KHR_ACCRUAL_OVERRIDE_FLAG /* CONTRACT DFF INFORMATION */
, FXH.KHR_ATTRIBUTE_CATEGORY OKL_KHR_ATTRIBUTE_CATEGORY
, FXH.KHR_ATTRIBUTE1 OKL_KHR_ATTRIBUTE1
, FXH.KHR_ATTRIBUTE2 OKL_KHR_ATTRIBUTE2
, FXH.KHR_ATTRIBUTE3 OKL_KHR_ATTRIBUTE3
, FXH.KHR_ATTRIBUTE4 OKL_KHR_ATTRIBUTE4
, FXH.KHR_ATTRIBUTE5 OKL_KHR_ATTRIBUTE5
, FXH.KHR_ATTRIBUTE6 OKL_KHR_ATTRIBUTE6
, FXH.KHR_ATTRIBUTE7 OKL_KHR_ATTRIBUTE7
, FXH.KHR_ATTRIBUTE8 OKL_KHR_ATTRIBUTE8
, FXH.KHR_ATTRIBUTE9 OKL_KHR_ATTRIBUTE9
, FXH.KHR_ATTRIBUTE10 OKL_KHR_ATTRIBUTE10
, FXH.KHR_ATTRIBUTE11 OKL_KHR_ATTRIBUTE11
, FXH.KHR_ATTRIBUTE12 OKL_KHR_ATTRIBUTE12
, FXH.KHR_ATTRIBUTE13 OKL_KHR_ATTRIBUTE13
, FXH.KHR_ATTRIBUTE14 OKL_KHR_ATTRIBUTE14
, FXH.KHR_ATTRIBUTE15 OKL_KHR_ATTRIBUTE15 /* CUSTOMER DFF INFORMATION */
, FXH.CUST_ATTRIBUTE_CATEGORY OKL_CUST_ATTRIBUTE_CATEGORY
, FXH.CUST_ATTRIBUTE1 OKL_CUST_ATTRIBUTE1
, FXH.CUST_ATTRIBUTE2 OKL_CUST_ATTRIBUTE2
, FXH.CUST_ATTRIBUTE3 OKL_CUST_ATTRIBUTE3
, FXH.CUST_ATTRIBUTE4 OKL_CUST_ATTRIBUTE4
, FXH.CUST_ATTRIBUTE5 OKL_CUST_ATTRIBUTE5
, FXH.CUST_ATTRIBUTE6 OKL_CUST_ATTRIBUTE6
, FXH.CUST_ATTRIBUTE7 OKL_CUST_ATTRIBUTE7
, FXH.CUST_ATTRIBUTE8 OKL_CUST_ATTRIBUTE8
, FXH.CUST_ATTRIBUTE9 OKL_CUST_ATTRIBUTE9
, FXH.CUST_ATTRIBUTE10 OKL_CUST_ATTRIBUTE10
, FXH.CUST_ATTRIBUTE11 OKL_CUST_ATTRIBUTE11
, FXH.CUST_ATTRIBUTE12 OKL_CUST_ATTRIBUTE12
, FXH.CUST_ATTRIBUTE13 OKL_CUST_ATTRIBUTE13
, FXH.CUST_ATTRIBUTE14 OKL_CUST_ATTRIBUTE14
, FXH.CUST_ATTRIBUTE15 OKL_CUST_ATTRIBUTE15 /*PRODUCTS
AND QUALITY RELATED SOURCES */
, FXH.PRODUCT_NAME OKL_PRODUCT_NAME
, FXH.BOOK_CLASSIFICATION_CODE OKL_BOOK_CLASSIFICATION_CODE
, FXH.TAX_OWNER_CODE OKL_TAX_OWNER_CODE
, FXH.INT_CALC_METHOD_CODE OKL_INT_CALC_METHOD_CODE
, FXH.REV_REC_METHOD_CODE OKL_REV_REC_METHOD_CODE /* CONTRACT LINE RELATED INFORMATION */
, FXL.CONTRACT_LINE_NUMBER OKL_CONTRACT_LINE_NUMBER
, FXL.ASSET_BOOK_TYPE_NAME OKL_ASSET_BOOK_TYPE_NAME
, FXL.ASSET_VENDOR_NAME OKL_ASSET_VENDOR_NAME
, FXL.INSTALLED_SITE_ID OKL_INSTALLED_SITE_ID /* ASSET DFF INFORMATION */
, FXL.LINE_ATTRIBUTE_CATEGORY OKL_ASSET_ATTRIBUTE_CATEGORY
, FXL.LINE_ATTRIBUTE1 OKL_ASSET_ATTRIBUTE1
, FXL.LINE_ATTRIBUTE2 OKL_ASSET_ATTRIBUTE2
, FXL.LINE_ATTRIBUTE3 OKL_ASSET_ATTRIBUTE3
, FXL.LINE_ATTRIBUTE4 OKL_ASSET_ATTRIBUTE4
, FXL.LINE_ATTRIBUTE5 OKL_ASSET_ATTRIBUTE5
, FXL.LINE_ATTRIBUTE6 OKL_ASSET_ATTRIBUTE6
, FXL.LINE_ATTRIBUTE7 OKL_ASSET_ATTRIBUTE7
, FXL.LINE_ATTRIBUTE8 OKL_ASSET_ATTRIBUTE8
, FXL.LINE_ATTRIBUTE9 OKL_ASSET_ATTRIBUTE9
, FXL.LINE_ATTRIBUTE10 OKL_ASSET_ATTRIBUTE10
, FXL.LINE_ATTRIBUTE11 OKL_ASSET_ATTRIBUTE11
, FXL.LINE_ATTRIBUTE12 OKL_ASSET_ATTRIBUTE12
, FXL.LINE_ATTRIBUTE13 OKL_ASSET_ATTRIBUTE13
, FXL.LINE_ATTRIBUTE14 OKL_ASSET_ATTRIBUTE14
, FXL.LINE_ATTRIBUTE15 OKL_ASSET_ATTRIBUTE15 /* RENT INVESTOR AGREEMENT RELATED SOURCES */
, FXH.RENT_IA_CONTRACT_NUMBER OKL_RENT_IA_CONTRACT_NUMBER
, FXH.RENT_IA_PRODUCT_NAME OKL_RENT_IA_PRODUCT_NAME
, FXH.RENT_IA_ACCOUNTING_CODE OKL_RENT_IA_ACCOUNTING_CODE /* RESIDUAL INVESTOR AGREEMENT RELATED SOURCES */
, FXH.RES_IA_CONTRACT_NUMBER OKL_RES_IA_CONTRACT_NUMBER
, FXH.RES_IA_PRODUCT_NAME OKL_RES_IA_PRODUCT_NAME
, FXH.RES_IA_ACCOUNTING_CODE OKL_RES_IA_ACCOUNTING_CODE /* EQUIVALENT CODES FOR THE TRANSLATABLE SOURCES */
, FXH.CONTRACT_STATUS_CODE OKL_CONTRACT_STATUS_CODE
, FXL.INVENTORY_ORG_CODE OKL_INVENTORY_ORG_CODE
FROM OKL_EXT_FA_HEADER_SOURCES_B FXH
, OKL_EXT_FA_LINE_SOURCES_B FXL
WHERE FXL.SOURCE_TABLE = 'FA_DEPRN_SUMMARY'
AND FXH.HEADER_EXTENSION_ID = FXL.HEADER_EXTENSION_ID