View: OKL_AM_OFF_LSE_TRX_UPD_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AM_OFF_LSE_TRX_UPD_UV

View Text

SELECT TALB.ROWID ROW_ID
, TALB.ID TAL_ID
, TASB.TAS_TYPE TAS_TYPE
, FL1.MEANING TAS_TYPE_MEANING
, TALB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TALT.SFWT_FLAG SFWT_FLAG
, TALB.TAS_ID TAS_ID
, TALB.ILO_ID ILO_ID
, TALB.ILO_ID_OLD ILO_ID_OLD
, TALB.IAY_ID IAY_ID
, FACAT.DESCRIPTION FA_CATEGORY_DESCRIPTION
, TALB.IAY_ID_NEW IAY_ID_NEW
, TALB.KLE_ID KLE_ID
, TALB.DNZ_KHR_ID DNZ_KHR_ID
, TALB.LINE_NUMBER LINE_NUMBER
, TALB.ORG_ID ORG_ID
, TALB.TAL_TYPE TAL_TYPE
, TALB.ASSET_NUMBER ASSET_NUMBER
, TALT.DESCRIPTION DESCRIPTION
, TALB.FA_LOCATION_ID FA_LOCATION_ID
, TALB.ORIGINAL_COST ORIGINAL_COST
, TALB.CURRENT_UNITS CURRENT_UNITS
, TALB.MANUFACTURER_NAME MANUFACTURER_NAME
, TALB.YEAR_MANUFACTURED YEAR_MANUFACTURED
, TALB.SUPPLIER_ID SUPPLIER_ID
, TALB.USED_ASSET_YN USED_ASSET_YN
, TALB.TAG_NUMBER TAG_NUMBER
, TALB.MODEL_NUMBER MODEL_NUMBER
, TALB.DATE_PURCHASED DATE_PURCHASED
, TALB.DATE_DELIVERY DATE_DELIVERY
, TALB.IN_SERVICE_DATE IN_SERVICE_DATE
, TALB.LIFE_IN_MONTHS LIFE_IN_MONTHS
, TALB.DEPRECIATION_ID DEPRECIATION_ID
, TALB.DEPRECIATION_COST DEPRECIATION_COST
, TALB.DEPRN_METHOD DEPRN_METHOD
, FAMET.NAME DEPRN_METHOD_NAME
, (TALB.DEPRN_RATE * 100) DEPRN_RATE
, TALB.SALVAGE_VALUE SALVAGE_VALUE
, TALB.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, TALB.DATE_DUE DATE_DUE
, TALB.CREATED_BY CREATED_BY
, TALB.CREATION_DATE CREATION_DATE
, TALB.LAST_UPDATED_BY LAST_UPDATED_BY
, TALB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TALB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TALB.DEPRECIATE_YN DEPRECIATE_YN
, TALB.HOLD_PERIOD_DAYS HOLD_PERIOD_DAYS
, TALB.OLD_SALVAGE_VALUE OLD_SALVAGE_VALUE
, TALB.NEW_RESIDUAL_VALUE NEW_RESIDUAL_VALUE
, TALB.OLD_RESIDUAL_VALUE OLD_RESIDUAL_VALUE
, TALB.UNITS_RETIRED UNITS_RETIRED
, TALB.COST_RETIRED COST_RETIRED
, TALB.SALE_PROCEEDS SALE_PROCEEDS
, TALB.REMOVAL_COST REMOVAL_COST
, TALB.DNZ_ASSET_ID DNZ_ASSET_ID
, TASB.TSU_CODE TSU_CODE
, FL2.MEANING TSU_CODE_MEANING
, TASB.TRY_ID TRY_ID
, TASB.DATE_TRANS_OCCURRED DATE_TRANS_OCCURRED
, CLE.NAME FIN_ASSET_NUMBER
, KHR.STS_CODE CONTRACT_STATUS
, KHR.CONTRACT_NUMBER CONTRACT_NUMBER
, PDT.NAME PRODUCT_NAME
, KHR.END_DATE CONTRACT_END_DATE
, DECODE(TXDB.TAX_BOOK
, NULL
, TALB.CORPORATE_BOOK
, TXDB.TAX_BOOK ) ASSET_BOOK
, FABKC.BOOK_TYPE_NAME ASSET_BOOK_NAME
, FABKC.BOOK_CLASS ASSET_BOOK_TYPE
FROM OKL_TRX_ASSETS TASB
, OKL_TXL_ASSETS_B TALB
, OKL_TXL_ASSETS_TL TALT
, FA_CATEGORIES_VL FACAT
, FND_LOOKUPS FL1
, FND_LOOKUPS FL2
, FA_BOOK_CONTROLS FABKC
, FA_METHODS FAMET
, OKC_K_LINES_V CLE
, OKL_K_HEADERS_FULL_V KHR
, OKL_PRODUCTS_V PDT
, OKL_TXD_ASSETS_B TXDB
WHERE TALB.ID = TALT.ID
AND TALT.LANGUAGE = USERENV('LANG')
AND TASB.ID = TALB.TAS_ID
AND TALB.ID = TXDB.TAL_ID(+)
AND DECODE(TXDB.TAX_BOOK
, NULL
, TALB.CORPORATE_BOOK
, TXDB.TAX_BOOK ) = FABKC.BOOK_TYPE_CODE
AND TASB.TAS_TYPE IN ('AMT'
, 'AUD'
, 'AUS')
AND TALB.IAY_ID = FACAT.CATEGORY_ID (+)
AND FL1.LOOKUP_CODE = TASB.TAS_TYPE
AND FL1.LOOKUP_TYPE = 'OKL_TRANS_HEADER_TYPE'
AND FL2.LOOKUP_CODE = TASB.TSU_CODE
AND FL2.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS'
AND TALB.DEPRN_METHOD = FAMET.METHOD_CODE(+)
AND ((TALB.LIFE_IN_MONTHS IS NULL) OR (TALB.LIFE_IN_MONTHS = FAMET.LIFE_IN_MONTHS))
AND TALB.KLE_ID = CLE.ID
AND TALB.DNZ_KHR_ID = KHR.ID
AND KHR.PDT_ID = PDT.ID (+)

Columns