ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1E93869E053B46B63588994 select nvl(&ACCT_FLEX_BAL_SEG,'None') COMP_CODE, cb.asset_cost_acct ASSET_ACCT, adt.asset_number||' - '||adt.description ASSET_NUMBER, to_char(bks.adjusted_rate*100, '99D99') || '%' RATE, bks.date_placed_in_service PURCH_DATE, round(sum(decode(bks.period_counter_fully_retired, '', bks.cost, 0) * dh.units_assigned / ah.units), :PRECISION) COST, round(sum(decode(d1.deprn_reserve,'', 0, d1.deprn_reserve) * dh.units_assigned / ah.units), :PRECISION) PRV_DEPRN, round(sum(decode(d1.deprn_reserve,'', (bks.cost - dc.deprn_reserve), (bks.cost - d1.deprn_reserve)) * dh.units_assigned / ah.units), :PRECISION) O_NBV, round(sum(nvl(dn.ytd_deprn,0) * dh.units_assigned/ ah.units), :PRECISION) YTD_DEP, round(sum(decode(bks.period_counter_fully_retired, '', (bks.cost - dn.deprn_reserve), 0) * dh.units_assigned/ ah.units), :PRECISION) C_NBV, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMP_CODE from fa_distribution_history dh, fa_asset_history ah, fa_additions adt, gl_code_combinations dhcc, fa_category_books cb, fa_books bks, fa_methods mth, fa_deprn_summary dn, fa_deprn_summary d1, fa_deprn_summary dc where dc.book_type_code = :P_BOOK and dc.deprn_source_code = 'BOOKS' and d1.book_type_code(+) = :P_BOOK and d1.period_COUNTER(+) = :OPEN_PC and dn.book_type_code = :P_BOOK and dn.period_COUNTER = ( select dp.period_COUNTER from fa_deprn_periods dp where dp.book_type_code = :P_BOOK and dp.period_counter = ( select max(dpz.period_counter) from fa_deprn_summary dsz, fa_deprn_periods dpz where dpz.book_type_code = :P_BOOK and dpz.period_counter <= :PERIOD1_PC and dsz.book_type_code = :P_BOOK and dsz.period_counter = dpz.period_counter and dsz.asset_id = dn.asset_id )) and dc.asset_id = dn.asset_id and d1.asset_id(+) = dn.asset_id and bks.book_type_code = :P_BOOK and bks.asset_id = dn.asset_id and nvl(bks.date_ineffective,sysdate) > :PERIOD1_PCD and bks.date_effective <= :PERIOD1_PCD and nvl(bks.period_counter_fully_retired,:PERIOD1_PC) in ( select dpy.period_counter from fa_deprn_periods dpy where dpy.book_type_code = :P_BOOK and dpy.fiscal_year = :PERIOD1_FY ) and bks.deprn_method_code = mth.method_code and mth.deprn_basis_rule = 'NBV' and mth.life_in_months is null and adt.asset_type = 'CAPITALIZED' and adt.asset_id = dn.asset_id and adt.asset_category_id = cb.category_id and cb.book_type_code = :P_BOOK and adt.asset_id = dh.asset_id and dh.book_type_code = :DISTRIBUTION_SOURCE_BOOK and nvl(dh.date_ineffective,sysdate) > :PERIOD1_PCD and dh.date_effective <= :PERIOD1_PCD and dhcc.code_combination_id(+) = dh.code_combination_id and ah.asset_id = adt.asset_id and nvl(ah.date_ineffective,sysdate) > :PERIOD1_PCD and ah.date_effective <= :PERIOD1_PCD group by nvl(&ACCT_FLEX_BAL_SEG,'None'), cb.asset_cost_acct, adt.asset_number||' - '||adt.description, bks.adjusted_rate, bks.date_placed_in_service,fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') order by 1,2, adt.asset_number||' - '||adt.description Y OFA FASNBV_XML AR FA تقرير القيمة المتناقصة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير القيمة المتناقصة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASNBV_XML DB package: FA_FASNBV_XMLP_PKG D FA Degressive Abschreibung- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Degressive Abschreibung (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASNBV_XML DB package: FA_FASNBV_XMLP_PKG F FA Etat des amortissements dégressifs à taux constant- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des amortissements dégressifs à taux constant (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FASNBV_XML DB package: FA_FASNBV_XMLP_PKG US FA Diminishing Value - draft Application: Assets Source: Diminishing Value Report (XML) - Not Supported: Reserved For Future Use Short Name: FASNBV_XML DB package: FA_FASNBV_XMLP_PKG ZHS FA 递减值报表- 不支持：已保留供将来使用 Application: 资产 Source: 递减值报表 (XML) - 不支持：已保留供将来使用 Short Name: FASNBV_XML DB package: FA_FASNBV_XMLP_PKG BI Publisher &acct_flex_bal_seg :accounting_flex_structure :book_class :currency_code :distribution_source_book :open_pc :p_book :p_conc_request_id :p_period1 :period1_fy :period1_pc :period1_pcd :period1_pod :precision :rp_company_name :rp_report_name 1 10 :p_book LOV Oracle FA_NOBUD_BOOK Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class!='BUDGET' order by book_type_code Y AR الدفتر D AfA-Buch F Livre US Book ZHS 帐簿 2 20 :p_period1 LOV Oracle FA_PERIOD_NAME_NOBUD Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_nobud_book and period_counter> (select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_nobud_book) order by period_counter Y AR الفترة D Periode F Période US Period ZHS 期间