ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1B53869E053B46B63588994 SELECT &ACCT_FLEX_BAL_SEG 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_CODE, th.book_type_code book, th.transaction_type_code tt, th.asset_id asset, fy.fiscal_year fiscal_year, cb.asset_cost_acct account, ad.asset_number || ' - ' || ad.description no, books.date_placed_in_service dt, ret.date_retired dr, round(sum(decode(ret.units, NULL, ret.cost_retired * (dh.units_assigned /ah.units), ret.cost_retired * abs(dh.transaction_units) / ret.units)) , :PRECISION) cost, Round(sum(decode(ret.units, NULL, ret.nbv_retired * (dh.units_assigned /ah.units), ret.nbv_retired * abs(dh.transaction_units) / ret.units)) , :PRECISION) nbv, Round(sum(decode(ret.units, NULL, ret.proceeds_of_sale * (dh.units_assigned /ah.units), nvl(ret.proceeds_of_sale, 0.00) * abs(dh.transaction_units) / ret.units)), :PRECISION) proceeds, Round(sum(decode(ret.units, NULL, nvl(ret.itc_recaptured, 0.00) * (dh.units_assigned /ah.units), nvl(ret.itc_recaptured, 0.00) * abs(dh.transaction_units) / ret.units)), :PRECISION) itc, Round(sum(decode(ret.units, NULL, nvl(ret.gain_loss_amount,0.00)* (dh.units_assigned /ah.units), nvl(ret.gain_loss_amount, 0.00) * abs(dh.transaction_units) / ret.units)), :PRECISION) gl, decode(TH.TRANSACTION_TYPE_CODE, 'REINSTATEMENT', '*', NULL) code FROM fa_asset_history ah, fa_retirements ret, fa_additions ad, fa_books books, fa_category_books cb, fa_fiscal_year fy, fa_transaction_headers th, fa_distribution_history dh, gl_code_combinations dhcc WHERE th.date_effective >= :PERIOD1_POD AND th.date_effective <= :PERIOD2_PCD AND th.book_type_code = UPPER(:P_BOOK) AND th.transaction_type_code = 'FULL RETIREMENT' AND th.transaction_header_id = ret.transaction_header_id_in AND ad.asset_id = th.asset_id AND books.transaction_header_id_out = th.transaction_header_id AND books.book_type_code = UPPER(:P_BOOK)AND books.asset_id = th.asset_id AND cb.category_id = ah.category_id AND cb.book_type_code = UPPER(:P_BOOK) AND ah.asset_id = ad.asset_id AND ah.date_effective <= th.date_effective AND (ah.date_ineffective is null OR ah.date_ineffective > th.date_effective) AND books.date_placed_in_service between fy.start_date and fy.end_date AND fy.fiscal_year_name = :Fiscal_Year_Name AND dh.book_type_code = :Distribution_Source_Book AND dh.asset_id = th.asset_id AND ( dh.retirement_id = ret.retirement_id or (ret.date_effective >= dh.date_effective and ret.date_effective <= nvl(dh.date_ineffective,sysdate) and ret.units is null)) AND dhcc.code_combination_id = dh.code_combination_id GROUP BY &ACCT_FLEX_BAL_SEG, 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'), th.book_type_code, th.transaction_type_code, th.asset_id, fy.fiscal_year, cb.asset_cost_acct, ad.asset_number, ad.description, books.date_placed_in_service, ret.date_retired, decode(TH.TRANSACTION_TYPE_CODE, 'REINSTATEMENT', '*', NULL) union SELECT &ACCT_FLEX_BAL_SEG 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_CODE, th.book_type_code book, th.transaction_type_code tt, th.asset_id asset, fy.fiscal_year fiscal_year, cb.asset_cost_acct account, ad.asset_number || ' - ' || ad.description no, books.date_placed_in_service dt, ret.date_retired dr, ROUND(sum(decode(ret.units, NULL, (-1) * ret.cost_retired * (dh.units_assigned /ah.units), (-1) * ret.cost_retired * abs(dh.transaction_units) / ret.units)), :PRECISION) cost, ROUND(sum(decode(ret.units, NULL, (-1) * ret.nbv_retired * (dh.units_assigned /ah.units), (-1) * ret.nbv_retired * abs(dh.transaction_units) / ret.units)), :PRECISION) nbv, ROUND(sum(decode(ret.units, NULL, (-1) * ret.proceeds_of_sale * (dh.units_assigned /ah.units), (-1) * nvl(ret.proceeds_of_sale, 0.00) * abs(dh.transaction_units) / ret.units)), :PRECISION) proceeds, ROUND(sum(decode(ret.units, NULL, (-1) * nvl(ret.itc_recaptured, 0.00) * (dh.units_assigned /ah.units), (-1) * nvl(ret.itc_recaptured, 0.00) * abs(dh.transaction_units) / ret.units)), :PRECISION) itc, ROUND(sum(decode(ret.units, NULL, (-1) * nvl(ret.gain_loss_amount,0.00) * (dh.units_assigned /ah.units), (-1) * nvl(ret.gain_loss_amount, 0.00) * abs(dh.transaction_units) / ret.units)), :PRECISION) gl, decode(TH.TRANSACTION_TYPE_CODE, 'REINSTATEMENT', '*', NULL) code FROM fa_asset_history ah, fa_retirements ret, fa_additions ad, fa_books books, fa_category_books cb, fa_fiscal_year fy, fa_transaction_headers th, fa_distribution_history dh, gl_code_combinations dhcc WHERE th.date_effective >= :PERIOD1_POD AND th.date_effective <= :PERIOD2_PCD AND th.book_type_code = UPPER(:P_BOOK) AND th.transaction_type_code = 'REINSTATEMENT' AND th.transaction_header_id = ret.transaction_header_id_out AND ad.asset_id = th.asset_id AND books.transaction_header_id_out = th.transaction_header_id AND books.book_type_code = UPPER(:P_BOOK) AND books.asset_id = th.asset_id AND cb.category_id = ah.category_id AND cb.book_type_code = UPPER(:P_BOOK)AND ah.asset_id = ad.asset_id AND ah.date_effective <= th.date_effective AND (ah.date_ineffective is null OR ah.date_ineffective > th.date_effective) AND books.date_placed_in_service between fy.start_date and fy.end_date AND fy.fiscal_year_name =:Fiscal_Year_Name AND dh.book_type_code = :Distribution_Source_Book AND dh.asset_id = th.asset_id AND ( dh.retirement_id = ret.retirement_id or (ret.date_effective >= dh.date_effective and ret.date_effective <= nvl(dh.date_ineffective,sysdate) and ret.units is null)) AND dhcc.code_combination_id = dh.code_combination_id GROUP BY &ACCT_FLEX_BAL_SEG, 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'), th.book_type_code, th.transaction_type_code, th.asset_id, fy.fiscal_year, cb.asset_cost_acct, ad.asset_number, ad.description, books.date_placed_in_service, ret.date_retired, decode(TH.TRANSACTION_TYPE_CODE, 'REINSTATEMENT', '*', NULL) union SELECT &ACCT_FLEX_BAL_SEG 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_CODE, th.book_type_code book, th.transaction_type_code tt, th.asset_id asset, fy.fiscal_year fiscal_year, cb.asset_cost_acct account, ad.asset_number || ' - ' || ad.description no, books.date_placed_in_service dt, ret.date_retired dr, ROUND(sum(decode(ret.units, NULL, ret.cost_retired * (dh.units_assigned /ah.units), ret.cost_retired * abs(dh.transaction_units) / ret.units)), :PRECISION) cost, ROUND(sum(decode(ret.units, NULL, ret.nbv_retired * (dh.units_assigned /ah.units), ret.nbv_retired * abs(dh.transaction_units) / ret.units)) , :PRECISION) nbv, ROUND(sum(decode(ret.units, NULL, ret.proceeds_of_sale * (dh.units_assigned /ah.units), nvl(ret.proceeds_of_sale, 0.00) * abs(dh.transaction_units) / ret.units)), :PRECISION) proceeds, ROUND(sum(decode(ret.units, NULL, nvl(ret.itc_recaptured, 0.00) * (dh.units_assigned /ah.units), nvl(ret.itc_recaptured, 0.00) * abs(dh.transaction_units) / ret.units)), :PRECISION) itc, ROUND(sum(decode(ret.units, NULL, nvl(ret.gain_loss_amount,0.00)* (dh.units_assigned /ah.units), nvl(ret.gain_loss_amount, 0.00) * abs(dh.transaction_units) / ret.units)), :PRECISION) gl, decode(TH.TRANSACTION_TYPE_CODE, 'REINSTATEMENT', '*', NULL) code FROM fa_asset_history ah, fa_retirements ret, fa_additions ad, fa_books books, fa_category_books cb, fa_fiscal_year fy, fa_transaction_headers th, fa_distribution_history dh, gl_code_combinations dhcc WHERE th.date_effective >= :PERIOD1_POD AND th.date_effective <= :PERIOD2_PCD AND th.book_type_code= UPPER(:P_BOOK) AND th.transaction_type_code = 'PARTIAL RETIREMENT' AND th.transaction_header_id = ret.transaction_header_id_in AND ad.asset_id = th.asset_id AND books.transaction_header_id_out = th.transaction_header_id AND books.book_type_code =UPPER(:P_BOOK)AND books.asset_id = th.asset_id AND cb.category_id = ah.category_id AND cb.book_type_code = UPPER(:P_BOOK) AND ah.asset_id = ad.asset_id AND ah.date_effective <= th.date_effective AND (ah.date_ineffective is null OR ah.date_ineffective > th.date_effective) AND books.date_placed_in_service between fy.start_date and fy.end_date AND fy.fiscal_year_name =:Fiscal_Year_Name AND dh.book_type_code = :Distribution_Source_Book and dh.asset_id = th.asset_id AND ( dh.retirement_id = ret.retirement_id or (ret.date_effective >= dh.date_effective and ret.date_effective <= nvl(dh.date_ineffective,sysdate) and ret.units is null)) AND dhcc.code_combination_id = dh.code_combination_id GROUP BY &ACCT_FLEX_BAL_SEG, 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') , th.book_type_code, th.transaction_type_code, th.asset_id, fy.fiscal_year, cb.asset_cost_acct, ad.asset_number, ad.description, books.date_placed_in_service, ret.date_retired, decode(TH.TRANSACTION_TYPE_CODE, 'REINSTATEMENT','*', NULL) ORDER BY 1,2,6,7,8,9,10,11,12,13,14,15,16,3,4,5 --1,5,6,7 OFA FAS520_XML AR FA تقرير استبعادات الضرائب (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير استبعادات الضرائب (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS520_XML DB package: FA_FAS520_XMLP_PKG D FA Steuerliche Abgänge- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Steuerliche Abgänge (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS520_XML DB package: FA_FAS520_XMLP_PKG F FA Etat des cessions par livre de gestion- Non pris en charge : réservé pour une utilisation ultérieure Application: Assets Source: Etat des cessions par livre de gestion (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: FAS520_XML DB package: FA_FAS520_XMLP_PKG US FA Tax Retirements - draft Application: Assets Source: Tax Retirements Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS520_XML DB package: FA_FAS520_XMLP_PKG ZHS FA 报废纳税报表- 不支持：已保留供将来使用 Application: 资产 Source: 报废纳税报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS520_XML DB package: FA_FAS520_XMLP_PKG BI Publisher &acct_flex_bal_seg :acct_bal_aprompt :acct_cc_aprompt :cat_maj_rprompt :distribution_source_book :fiscal_year_name :p_book :p_conc_request_id :p_min_precision :p_period1 :p_period2 :perecision :period1_fy :period1_pcd :period1_pod :period2_fy :period2_pcd :period2_pod :precesion :precision :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 帐簿 2 20 :p_period1 LOV Oracle FA_PERIOD_NAME Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter>(select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_type) order by period_counter Y AR من الفترة D Von Periode F De la période US From Period ZHS 自期间 3 30 :p_period2 LOV Oracle FA_PERIOD_TO Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter>=(select period_counter from fa_deprn_periods where book_type_code= :$flex$.fa_book_type and period_name= :$flex$.fa_period_name) order by period_counter Y AR إلى الفترة D Bis Periode F A la période US To Period ZHS 至期间 :$flex$.fa_book_type Book From Period :$flex$.fa_book_type Book To Period :$flex$.fa_period_name From Period To Period