[Home] [Help]
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,
1943: OKC_K_ITEMS item
1944: WHERE
1945: ITEM.cle_id = cle.id
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,
2006: okc_k_headers_all_b chr,
2007: okl_system_params_all sys_param,
2008: OKC_K_ITEMS item
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,
2056: okc_k_headers_all_b chr,
2057: okl_system_params_all sys_param,
2058: OKC_K_ITEMS item
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
4047: AND fbc.book_type_code(+) = okl_asset.CORPORATE_BOOK
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
4095: AND okl_asset_l.DNZ_KHR_ID = chr.id
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
4129: AND okl_asset_l.DNZ_KHR_ID = chr.id