OKL Equipment Exchange Request

Description
Categories: BI Publisher
Columns: Old Asset Number, Old Description, Old Original Cost, Old Manufacturer Name, Old Year Manufactured, Old Model Number, Old Supplier Id, New Asset Number, New Description, New Original Cost ...
Application: Lease and Finance Management
Source:
Short Name: OKLEQXCHNG
DB package:
  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