eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 3671: CURSOR get_default_deprn_meth(cp_bk_type_code fa_category_book_defaults.book_type_code%TYPE

3667: AND organization_id = cp_inv_org_id
3668: AND cat.id1 = mtl.asset_category_id;
3669:
3670: -- Get the depreciation method defined on the category defaults for the category book
3671: CURSOR get_default_deprn_meth(cp_bk_type_code fa_category_book_defaults.book_type_code%TYPE
3672: , cp_category_id fa_category_book_defaults.category_id%type
3673: , cp_inservice_date DATE
3674: , cp_term NUMBER) IS
3675: SELECT def.deprn_method

Line 3672: , cp_category_id fa_category_book_defaults.category_id%type

3668: AND cat.id1 = mtl.asset_category_id;
3669:
3670: -- Get the depreciation method defined on the category defaults for the category book
3671: CURSOR get_default_deprn_meth(cp_bk_type_code fa_category_book_defaults.book_type_code%TYPE
3672: , cp_category_id fa_category_book_defaults.category_id%type
3673: , cp_inservice_date DATE
3674: , cp_term NUMBER) IS
3675: SELECT def.deprn_method
3676: , (def.adjusted_rate * 100) deprn_rate

Line 3678: FROM fa_category_book_defaults def

3674: , cp_term NUMBER) IS
3675: SELECT def.deprn_method
3676: , (def.adjusted_rate * 100) deprn_rate
3677: , NVL(mth.life_in_months,def.life_in_months) life_in_months
3678: FROM fa_category_book_defaults def
3679: , fa_methods mth
3680: WHERE def.book_type_code = cp_bk_type_code
3681: AND def.category_id = cp_category_id
3682: AND cp_inservice_date BETWEEN def.start_dpis AND Nvl(def.end_dpis, cp_inservice_date)