ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2003869E053B46B63588994 SELECT FR.COMP_CODE COMP_CODE, FR.DEPRN_METHOD FED_METHOD, FR.ASSET_ACCOUNT ASSET_ACCOUNT, fnd_flex_xml_publisher_apis.process_kff_combination_1('cat_flex_all_seg', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') CATEGORY, AD.ASSET_NUMBER ASSET_NUMBER, FR.FED_YTD_DEPRN FED_YTD_DEPRN, SUM(DD_CORP.DEPRN_AMOUNT) CORP_YTD_DEPRN, DECODE(SIGN(FR.FED_YTD_DEPRN - SUM(DD_CORP.DEPRN_AMOUNT)), -1, 0, FR.FED_YTD_DEPRN - SUM(DD_CORP.DEPRN_AMOUNT)) DIFFERENCE, --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 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_CODE1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_CATEGORY1 FROM FA_TAX_REPORT FR, FA_DEPRN_PERIODS DP, FA_DEPRN_DETAIL DD_CORP, FA_ASSET_HISTORY AH, FA_CATEGORY_BOOKS CB_CORP, FA_CATEGORIES CAT, FA_ADDITIONS AD, FA_DISTRIBUTION_HISTORY DH, GL_CODE_COMBINATIONS DHCC WHERE FR.REQUEST_ID = :P_CONC_REQUEST_ID AND FR.ASSET_ID = DD_CORP.ASSET_ID and fr.asset_id = ah.asset_id and AH.DATE_EFFECTIVE <= DP.PERIOD_CLOSE_DATE and NVL(AH.DATE_INEFFECTIVE, DP.PERIOD_CLOSE_DATE+1) > DP.PERIOD_CLOSE_DATE and CB_CORP.CATEGORY_ID = AH.CATEGORY_ID AND DD_CORP.BOOK_TYPE_CODE = :DISTRIBUTION_SOURCE_BOOK AND DD_CORP.PERIOD_COUNTER BETWEEN :min_corp_pc AND :corp_end_pc AND CB_CORP.BOOK_TYPE_CODE = DD_CORP.BOOK_TYPE_CODE AND CB_CORP.ASSET_COST_ACCT BETWEEN NVL(:P_FROM_ACCT, CB_CORP.ASSET_COST_ACCT) AND NVL(:P_TO_ACCT, CB_CORP.ASSET_COST_ACCT) AND CB_CORP.CATEGORY_ID = CAT.CATEGORY_ID AND DP.BOOK_TYPE_CODE = :P_BOOK AND DP.PERIOD_COUNTER = :max_fed_pc AND FR.ASSET_ID = AD.ASSET_ID and DH.ASSET_ID = DD_CORP.ASSET_ID AND DH.DISTRIBUTION_ID = DD_CORP.DISTRIBUTION_ID AND DH.CODE_COMBINATION_ID = DHCC.CODE_COMBINATION_ID(+) and fr.comp_code =fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') GROUP BY FR.COMP_CODE, FR.DEPRN_METHOD, FR.ASSET_ACCOUNT, fnd_flex_xml_publisher_apis.process_kff_combination_1('cat_flex_all_seg', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE'), AD.ASSET_NUMBER, FR.FED_YTD_DEPRN --Added during DT Fix ,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, 4, 5, 6, 7, 8 --End of DT Fix OFA FASTXPRF_XML AR FA تقرير أفضليات الضرائب (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير أفضليات الضرائب (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASTXPRF_XML DB package: FA_FASTXPRF_XMLP_PKG D FA Steuerpräferenz- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Steuerpräferenz (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASTXPRF_XML DB package: FA_FASTXPRF_XMLP_PKG F FA Etat de comparaison d'amortissement entre livre de gestion et livre comptable- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat de comparaison d'amortissement entre livre de gestion et livre comptable (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FASTXPRF_XML DB package: FA_FASTXPRF_XMLP_PKG US FA Tax Preference - draft Application: Assets Source: Tax Preference Report (XML) - Not Supported: Reserved For Future Use Short Name: FASTXPRF_XML DB package: FA_FASTXPRF_XMLP_PKG ZHS FA 税收优惠报表- 不支持：已保留供将来使用 Application: 资产 Source: 税收优惠报表 (XML) - 不支持：已保留供将来使用 Short Name: FASTXPRF_XML DB package: FA_FASTXPRF_XMLP_PKG BI Publisher :acct_bal_aprompt :cat_maj_rprompt :corp_end_pc :distribution_source_book :max_fed_pc :min_corp_pc :min_fed_pc :p_book :p_conc_request_id :p_from_acct :p_min_precision :p_period1 :p_to_acct :period1_fy :period1_pcd :period1_pod :rp_bal_lprompt :rp_company_name :rp_report_name 1 10 :p_book LOV Oracle FA_TAX_BOOKS Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class='TAX' order by book_type_code Y AR الدفتر D AfA-Buch F Livre US Book ZHS 帐簿 2 20 :p_period1 LOV Oracle FA_PERIOD_NAME_TAX Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_tax_books and period_counter> (select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_tax_books) order by period_counter Y AR فترة الضريبة D Periode im Steuerbuch F Période fiscale US Tax Period ZHS 纳税期间 3 30 :p_from_acct Char AR من حساب D Von Konto F Du compte US From Account ZHS 自帐户 4 40 :p_to_acct Char AR إلى حساب D Bis Konto F Au compte US To Account ZHS 至帐户 :$flex$.fa_tax_books Book Tax Period