ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1EA3869E053B46B63588994 SELECT NVL(&ACCT_FLEX_BAL_SEG,'NONE') COMP_CODE, AD.ASSET_TYPE ASSET_TYPE, &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,AH.UNITS)/AH.UNITS), :PRECISION) COST, 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_BOOK_CONTROLS BC, FA_BOOKS BOOKS, FA_ADDITIONS AD, FA_ASSET_HISTORY AH, 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 = 'YES' AND BOOKS.DEPRECIATE_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 = BC.BOOK_TYPE_CODE AND BC.DISTRIBUTION_SOURCE_BOOK = 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 AND AH.ASSET_ID = BOOKS.ASSET_ID AND AH.DATE_INEFFECTIVE IS NULL GROUP BY NVL(&ACCT_FLEX_BAL_SEG,'NONE'), AD.ASSET_TYPE, &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('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 1,2,3,4 ORDER BY COMP_CODE_DSP,2,D_CATEGORY,4,5,6,7,8 OFA FASNDPRP_XML AR FA تقرير الملكية غير المهلكة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير الملكية غير المهلكة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASNDPRP_XML DB package: FA_FASNDPRP_XMLP_PKG D FA Nicht abgeschriebenes Vermögen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Nicht abgeschriebenes Vermögen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASNDPRP_XML DB package: FA_FASNDPRP_XMLP_PKG F FA Etat des immobilisations non amortissables- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des immobilisations non amortissables (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FASNDPRP_XML DB package: FA_FASNDPRP_XMLP_PKG US FA Non-Depreciating Property - draft Application: Assets Source: Non-Depreciating Property Report (XML) - Not Supported: Reserved For Future Use Short Name: FASNDPRP_XML DB package: FA_FASNDPRP_XMLP_PKG ZHS FA 非折旧财产报表- 不支持：已保留供将来使用 Application: 资产 Source: 非折旧财产报表 (XML) - 不支持：已保留供将来使用 Short Name: FASNDPRP_XML DB package: FA_FASNDPRP_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 :precision :rp_bal_lprompt :rp_company_name :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 帐簿