ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1CE3869E053B46B63588994 SELECT &Acct_Flex_Bal_Seg comp_code, &Cat_Flex_All_Seg category, le.lease_number, ad.asset_number || ' - ' || ad.description asset_number_desc, books.date_placed_in_service, sum(decode (dd.deprn_source_code, 'D', dd.cost, dd.addition_cost_to_clear)) cost, sum(dd.deprn_reserve) reserve, sum(dd.cost) - sum(dd.deprn_reserve) nbv, --added fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_Category FROM fa_additions ad, fa_leases le, fa_deprn_detail dd, fa_categories cat, fa_books books, GL_CODE_COMBINATIONS DHCC, FA_DISTRIBUTION_HISTORY DH WHERE (cat.owned_leased = 'LEASED' or cat.category_type = 'LEASE' ) AND ad.asset_category_id = cat.category_id AND le.lease_id = ad.lease_id AND books.book_type_code = :P_Book AND books.asset_id = ad.asset_id AND books.transaction_header_id_out is NULL AND dh.book_type_code = books.book_type_code and dh.asset_id = books.asset_id and dh.date_ineffective is null AND dhcc.code_combination_id = dh.code_combination_id AND dd.asset_id = books.asset_id AND dd.book_type_code = books.book_type_code AND dd.distribution_id = dh.distribution_id AND dd.period_counter = (select max (dd_sub.period_counter) from fa_deprn_detail dd_sub where dd_sub.asset_id = books.asset_id and dd_sub.book_type_code = books.book_type_code and dd_sub.distribution_id = dh.distribution_id) GROUP BY books.book_type_code, &Acct_Flex_Bal_Seg, &Cat_Flex_All_Seg, le.lease_number, ad.asset_number, ad.description, books.date_placed_in_service --added ,fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'),fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') ORDER BY &Acct_Flex_Bal_Seg, &Cat_Flex_All_Seg, le.lease_number, ad.asset_number --added ,DATE_PLACED_IN_SERVICE,COST,RESERVE,NBV Y OFA FAS930_XML AR FA تقرير الأصول المؤجرة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير الأصول المؤجرة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS930_XML DB package: FA_FAS930_XMLP_PKG D FA Geleaste Anlagen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Geleaste Anlagen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS930_XML DB package: FA_FAS930_XMLP_PKG F FA Etat des biens achetés en crédit-bail- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des biens achetés en crédit-bail (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS930_XML DB package: FA_FAS930_XMLP_PKG US FA Leased Assets - draft Application: Assets Source: Leased Assets Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS930_XML DB package: FA_FAS930_XMLP_PKG ZHS FA 租赁资产报表- 不支持：已保留供将来使用 Application: 资产 Source: 租赁资产报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS930_XML DB package: FA_FAS930_XMLP_PKG BI Publisher &acct_flex_bal_seg &cat_flex_all_seg :acct_bal_aprompt :acct_cc_aprompt :cat_maj_rprompt :p_book :p_conc_request_id :p_min_precision :rp_bal_lprompt :rp_cat_lprompt :rp_company_name :rp_currency_code :rp_report_name 1 10 :p_book LOV Oracle FA_BOOK_TYPE Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec order by book_type_code Y AR الدفتر D AfA-Buch F Livre US Book ZHS 帐簿