[Home] [Help]
1934: FB.ORIGINAL_COST FA_CORP_ORIG_COST,
1935: fb.cost FA_CORP_DEP_COST,
1936: fb.date_placed_in_service FA_CORP_DATE_IN_SERVICE
1937: FROM FA_CATEGORIES_B CAT,
1938: FA_BOOK_CONTROLS FBC,
1939: FA_BOOKS FB,
1940: FA_ADDITIONS_B FA,
1941: FA_METHODS FM,
1942: okc_k_lines_b cle,
1997: row_number() over ( partition by cle.cle_id
1998: order by fb.book_type_code nulls last ) book_type_code_row_num
1999: FROM
2000: FA_CATEGORIES_B CAT,
2001: FA_BOOK_CONTROLS FBC,
2002: FA_BOOKS FB,
2003: FA_ADDITIONS_B FA,
2004: FA_METHODS FM,
2005: okc_k_lines_b cle,
2047: fb.cost FA_MG_DEP_COST,
2048: fb.date_placed_in_service FA_MG_DATE_IN_SERVICE
2049: FROM
2050: FA_CATEGORIES_B CAT,
2051: FA_BOOK_CONTROLS FBC,
2052: FA_BOOKS FB,
2053: FA_ADDITIONS_B FA,
2054: FA_METHODS FM,
2055: okc_k_lines_b cle,
4038: okl_asset.DEPRECIATION_COST FA_CORP_DEP_COST,
4039: okl_asset.IN_SERVICE_DATE FA_CORP_DATE_IN_SERVICE
4040: FROM okc_k_lines_b cleb_fa,
4041: OKL_TXL_ASSETS_B okl_asset,
4042: fa_book_controls fbc,
4043: fa_methods fm,
4044: fa_categories cat
4045: where
4046: cleb_fa.id = okl_asset.kle_id
4086: OKL_TXd_assets_b okl_asset,
4087: okl_txl_assets_b okl_asset_l,
4088: okc_k_headers_all_b chr,
4089: okl_system_params_all sys_param,
4090: fa_book_controls fbc,
4091: fa_methods fm
4092: where
4093: cleb_fa.id = okl_asset_l.kle_id
4094: AND okl_asset.tal_id = okl_asset_l.ID
4120: OKL_TXd_assets_b okl_asset_d,
4121: okl_txl_assets_b okl_asset_l,
4122: okc_k_headers_all_b chr,
4123: okl_system_params_all sys_param,
4124: fa_book_controls fbc,
4125: fa_methods fm
4126: where
4127: cleb_fa.id = okl_asset_l.kle_id
4128: AND okl_asset_d.tal_id = okl_asset_l.ID