VIEW: APPS.OKL_FA_DEP_REF_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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