ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1DE3869E053B46B63588994 SELECT nvl(&ACCT_FLEX_BAL_SEG, 'None') comp_code, &CAT_FLEX_ALL_SEG CATEGORY, AD.ASSET_NUMBER ASSET_NUMBER, AD.DESCRIPTION DESCRIPTION, AD.SERIAL_NUMBER SERIAL_NUMBER, BOOKS.DATE_PLACED_IN_SERVICE START_DATE, round(sum(books.cost * nvl(dh.units_assigned,ad.current_units)/ ad.current_units), :PRECISION) cost, 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, 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_BOOKS BOOKS, FA_ADDITIONS AD, FA_CATEGORIES CAT, FA_SYSTEM_CONTROLS SC, fa_distribution_history dh, gl_code_combinations dhcc WHERE BOOKS.BOOK_TYPE_CODE = :P_BOOK AND BOOKS.TRANSACTION_HEADER_ID_OUT is NULL AND BOOKS.CAPITALIZE_FLAG = 'NO' and BOOKS.period_counter_fully_retired is null AND AD.ASSET_ID = BOOKS.ASSET_ID AND CAT.CATEGORY_ID = AD.ASSET_CATEGORY_ID and books.book_type_code = dh.book_type_code(+) and books.asset_id = dh.asset_id(+) and dh.date_ineffective is null and dhcc.code_combination_id(+) = dh.code_combination_id GROUP BY nvl(&ACCT_FLEX_BAL_SEG, 'None'), &CAT_FLEX_ALL_SEG, AD.ASSET_NUMBER, AD.DESCRIPTION, AD.SERIAL_NUMBER, BOOKS.DATE_PLACED_IN_SERVICE --added ,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') , fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') ORDER BY 1,2,3 OFA FASEXPRP_XML Y AR FA تقرير الملكية المصروفة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير الملكية المصروفة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASEXPRP_XML DB package: FA_FASEXPRP_XMLP_PKG D FA Nicht aktiviertes Vermögen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Nicht aktiviertes Vermögen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASEXPRP_XML DB package: FA_FASEXPRP_XMLP_PKG F FA Etat des immobilisations de type Charges- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des immobilisations de type Charges (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FASEXPRP_XML DB package: FA_FASEXPRP_XMLP_PKG US FA Expensed Property - draft Application: Assets Source: Expensed Property Report (XML) - Not Supported: Reserved For Future Use Short Name: FASEXPRP_XML DB package: FA_FASEXPRP_XMLP_PKG ZHS FA 低值易耗财产报表- 不支持：已保留供将来使用 Application: 资产 Source: 低值易耗财产报表 (XML) - 不支持：已保留供将来使用 Short Name: FASEXPRP_XML DB package: FA_FASEXPRP_XMLP_PKG BI Publisher &acct_flex_bal_seg &cat_flex_all_seg :acct_bal_aprompt :p_book :p_conc_request_id :p_min_precision :precision :rp_bal_lprompt :rp_company_name :rp_report_name 1 10 :p_book LOV Oracle FA_CORP_BOOK Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class='CORPORATE' order by book_type_code Y AR الدفتر D AfA-Buch F Livre US Book ZHS 帐簿