ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2183869E053B46B63588994Y SELECT OAS.ASSET_NUMBER OLD_ASSET_NUMBER, OAS.DESCRIPTION OLD_DESCRIPTION, OAS.ORIGINAL_COST OLD_ORIGINAL_COST, OAS.MANUFACTURER_NAME OLD_MANUFACTURER_NAME, OAS.YEAR_MANUFACTURED OLD_YEAR_MANUFACTURED, OAS.MODEL_NUMBER OLD_MODEL_NUMBER, OAS.SUPPLIER_ID OLD_SUPPLIER_ID, NAS.ASSET_NUMBER NEW_ASSET_NUMBER, NAS.DESCRIPTION NEW_DESCRIPTION, NAS.ORIGINAL_COST NEW_ORIGINAL_COST, NAS.MANUFACTURER_NAME NEW_MANUFACTURER_NAME, NAS.YEAR_MANUFACTURED NEW_YEAR_MANUFACTURED, NAS.MODEL_NUMBER NEW_MODEL_NUMBER, NAS.SUPPLIER_ID NEW_SUPPLIER_ID, CUR.DNZ_KHR_ID CONTRACT_ID, CUR.IN_SERVICE_DATE IN_SERVICE_DATE, CUR.DEPRECIATION_COST DEPRECIATION_COST, CLE.RESIDUAL_VALUE, CLE.RESIDUAL_PERCENTAGE, CLE.RESIDUAL_CODE, CLE.RESIDUAL_GRNTY_AMOUNT, CLE.CAPITAL_AMOUNT, OTA.ORG_ID, KHR.CUST_ACCT_ID, KHR.CONTRACT_NUMBER FROM OKL_TRX_ASSETS OTA, OKL_TXL_ASSETS_V OAS, OKL_TXL_ASSETS_V NAS, OKL_TXL_ASSETS_V CUR, OKC_K_LINES_B KLE, OKL_K_LINES_V CLE, OKC_K_HEADERS_B KHR WHERE OTA.ID = :P_REQUEST_ID AND OTA.ID = OAS.TAS_ID AND OTA.ID = NAS.TAS_ID AND OAS.DNZ_KHR_ID = CUR.DNZ_KHR_ID AND OAS.KLE_ID = KLE.CLE_ID AND OAS.TAL_TYPE = 'OAS' AND NAS.TAL_TYPE = 'NAS' AND CUR.TAL_TYPE = 'CFA' AND CUR.DNZ_KHR_ID = KHR.ID AND CUR.KLE_ID = KLE.ID AND KLE.CLE_ID = CLE.ID OKL OKLEQXCHNG AR OKL طلب السوق الإلكترونية للمعدات Application: إدارة الإيجار Source: Short Name: OKLEQXCHNG DB package: D OKL Geräteaustauschanforderung Application: Lease and Finance Management Source: Short Name: OKLEQXCHNG DB package: F OKL Demande d'échange d'équipements Application: Lease and Finance Management Source: Short Name: OKLEQXCHNG DB package: US OKL Equipment Exchange Request Application: Lease and Finance Management Source: Short Name: OKLEQXCHNG DB package: ZHS OKL 设备交换请求 Application: Oracle Lease and Finance Management Source: Short Name: OKLEQXCHNG DB package: BI Publisher :p_request_id