View: OKL_FA_DEP_REF_VL

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

View Text

SELECT FXL.FA_TRANSACTION_ID OKL_DEPRN_RUN_ID
, FXL.ASSET_ID OKL_ASSET_ID
, FXL.ASSET_BOOK_TYPE_CODE OKL_ASSET_BOOK_TYPE_CODE
, FXL.PERIOD_COUNTER OKL_PERIOD_COUNTER
, FXHL.LANGUAGE LANGUAGE /* TRANSLATABLE SOURCES FOLLOWS */
, FXHL.CONTRACT_STATUS OKL_CONTRACT_STATUS
, FXLL.INVENTORY_ORG_NAME OKL_INVENTORY_ORG_NAME
FROM OKL_EXT_FA_LINE_SOURCES_B FXL
, OKL_EXT_FA_LINE_SOURCES_TL FXLL
, OKL_EXT_FA_HEADER_SOURCES_TL FXHL
WHERE FXL.SOURCE_TABLE = 'FA_DEPRN_SUMMARY'
AND FXL.LINE_EXTENSION_ID = FXLL.LINE_EXTENSION_ID
AND FXL.HEADER_EXTENSION_ID = FXHL.HEADER_EXTENSION_ID
AND FXLL.LANGUAGE = FXHL.LANGUAGE

Columns