OKL Equipment Exchange Request
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLEQXCHNG
DB package:
Source:
Short Name: OKLEQXCHNG
DB package:
Run
OKL Equipment Exchange Request and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |