ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1EF3869E053B46B63588994 SELECT NVL(&ACCT_FLEX_BAL_SEG, 'NONE') COMP_CODE, AD.ASSET_NUMBER ASSET_NUMBER, ROUND(SUM(NVL(MC.COST,BK_CORP.COST) * NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS) ,:PRECISION) CORP_COST, ROUND(SUM(NVL(MC.SALVAGE_VALUE,BK_CORP.SALVAGE_VALUE) * NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS),:PRECISION) CORP_SALV_VALUE, ROUND(SUM(NVL(MC.ADJUSTED_RECOVERABLE_COST,NVL(BK_CORP.adjusted_recoverable_cost,0)) * NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS),:PRECISION) CORP_RECOV_COST, DECODE(SIGN(ROUND(SUM(NVL(MC.COST,BK_CORP.COST) * NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS) - SUM(BK_CORP.SALVAGE_VALUE * NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS),:PRECISION) - ROUND(SUM(NVL(MC.ADJUSTED_RECOVERABLE_COST,NVL(BK_CORP.adjusted_recoverable_cost,0)) * NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS),:PRECISION)), '0',NULL,'*') CORP_CHECK, ROUND(SUM(BK_TAX.COST * NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS),:PRECISION) TAX_COST, ROUND(SUM(BK_TAX.SALVAGE_VALUE * NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS) ,:PRECISION)TAX_SALV_VALUE, ROUND(SUM(NVL(BK_TAX.ITC_BASIS,0) * NVL(ITC.BASIS_REDUCTION_RATE,0) * NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS),:PRECISION) BASIS_RED_AMNT, ROUND(SUM(NVL(BK_TAX.adjusted_recoverable_cost,0) * NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS),:PRECISION) TAX_RECOV_COST, DECODE(SIGN(ROUND(SUM(BK_TAX.COST * NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS) - SUM(BK_TAX.SALVAGE_VALUE * NVL(DH.UNITS_ASSIGNED,AH.UNITS / AH.UNITS)) - (SUM(NVL(BK_TAX.ITC_BASIS,0) * NVL(ITC.BASIS_REDUCTION_RATE,0) * NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS)),:PRECISION) - ROUND(SUM(NVL(BK_TAX.adjusted_recoverable_cost,0) * NVL(DH.UNITS_ASSIGNED,AH.UNITS) / AH.UNITS),:PRECISION)), '0',NULL,'*') TAX_CHECK, --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_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMP_CODE1 FROM FA_ADDITIONS AD, FA_MC_BOOKS MC, FA_BOOKS_BAS BK_CORP, FA_ASSET_HISTORY AH, FA_BOOKS BK_TAX, FA_ITC_RATES ITC, FA_DISTRIBUTION_HISTORY DH, GL_CODE_COMBINATIONS DHCC WHERE AD.ASSET_ID = AH.ASSET_ID AND :CORP_PERIOD_PCD BETWEEN AH.DATE_EFFECTIVE AND NVL(AH.DATE_INEFFECTIVE, :CORP_PERIOD_PCD) AND AD.ASSET_ID = BK_TAX.ASSET_ID AND BK_CORP.ASSET_ID(+) = AD.ASSET_ID AND BK_CORP.BOOK_TYPE_CODE(+) = :DISTRIBUTION_SOURCE_BOOK AND MC.TRANSACTION_HEADER_ID_IN(+) = DECODE(:mrc_sob_type_code,'R',BK_CORP.TRANSACTION_HEADER_ID_IN,NULL) AND MC.SET_OF_BOOKS_ID(+) = :set_of_books_id AND BK_TAX.BOOK_TYPE_CODE = :P_BOOK AND BK_TAX.DEPRECIATE_FLAG = 'YES' AND ITC.ITC_AMOUNT_ID(+) = BK_TAX.ITC_AMOUNT_ID AND :PERIOD1_PCD BETWEEN BK_TAX.DATE_EFFECTIVE AND NVL(BK_TAX.DATE_INEFFECTIVE, :PERIOD1_PCD) AND :CORP_PERIOD_PCD BETWEEN BK_CORP.DATE_EFFECTIVE AND NVL(BK_CORP.DATE_INEFFECTIVE, :CORP_PERIOD_PCD) AND DH.ASSET_ID(+) = AD.ASSET_ID AND DH.BOOK_TYPE_CODE(+) = :DISTRIBUTION_SOURCE_BOOK AND :CORP_PERIOD_PCD BETWEEN DH.DATE_EFFECTIVE AND NVL(DH.DATE_INEFFECTIVE, :CORP_PERIOD_PCD) AND DH.CODE_COMBINATION_ID = DHCC.CODE_COMBINATION_ID(+) GROUP BY AD.ASSET_NUMBER, NVL(&ACCT_FLEX_BAL_SEG, 'NONE') --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') --End of DT Fix ORDER BY 1,2 Y OFA FASRCOST_XML AR FA تقرير التكلفة القابلة للاسترداد (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير التكلفة القابلة للاسترداد (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASRCOST_XML DB package: FA_FASRCOST_XMLP_PKG D FA Bemessungsgrundlagen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Bemessungsgrundlagen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASRCOST_XML DB package: FA_FASRCOST_XMLP_PKG F FA Etat du coût récupérable- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat du coût récupérable (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FASRCOST_XML DB package: FA_FASRCOST_XMLP_PKG US FA Recoverable Cost - draft Application: Assets Source: Recoverable Cost Report (XML) - Not Supported: Reserved For Future Use Short Name: FASRCOST_XML DB package: FA_FASRCOST_XMLP_PKG ZHS FA 可收回成本报表- 不支持：已保留供将来使用 Application: 资产 Source: 可收回成本报表 (XML) - 不支持：已保留供将来使用 Short Name: FASRCOST_XML DB package: FA_FASRCOST_XMLP_PKG BI Publisher &acct_flex_bal_seg :acct_bal_aprompt :corp_period_pcd :corp_period_pod :distribution_source_book :mrc_sob_type_code :p_book :p_conc_request_id :p_min_precision :p_period1 :period1_fy :period1_pcd :period1_pod :precision :rp_bal_lprompt :rp_company_name :rp_report_name :set_of_books_id 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 F Période US Period ZHS 期间