ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1AD3869E053B46B63588994 SELECT nvl(&ACCT_FLEX_BAL_SEG, 'None') comp_code, 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, cb.asset_cost_acct account, ad.property_1245_1250_code class, ad.asset_number || ' - ' || ad.description asset_num, bk.date_placed_in_service dpis, ret.date_retired date_sold, ROUND(sum(decode(ret.units, NULL, nvl(ret.proceeds_of_sale,0.00)*(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, (ret.cost_retired - ret.nbv_retired) *(dh.units_assigned/ah.units), (ret.cost_retired - ret.nbv_retired) *(abs(dh.transaction_units)/ret.units))),:PRECISION) reserve, ROUND(sum(decode(ret.units, NULL, (ret.cost_retired + nvl(ret.cost_of_removal, 0)) *(dh.units_assigned/ah.units), (ret.cost_retired + nvl(ret.cost_of_removal, 0)) *(abs(dh.transaction_units)/ret.units))),:PRECISION) basis, Decode (Sign(ret.gain_loss_amount), -1, :LOSS_NLS, :GAIN_NLS) GAIN_loss, ROUND(sum(decode(ret.units, NULL, ret.gain_loss_amount*(dh.units_assigned/ah.units), ret.gain_loss_amount*(abs(dh.transaction_units)/ret.units))),:PRECISION) gain FROM fa_retirements ret, fa_additions ad, fa_asset_history ah, fa_system_controls sc, fa_category_books cb, fa_transaction_headers th, fa_books bk, fa_distribution_history dh, gl_code_combinations dhcc, fa_category_book_defaults cbd WHERE th.date_effective >= :PERIOD1_POD AND th.date_effective <= :PERIOD2_PCD AND th.book_type_code = :P_BOOK AND th.transaction_type_code || '' in ('FULL RETIREMENT', 'PARTIAL RETIREMENT') AND th.transaction_key = 'R' AND ah.asset_id = th.asset_id AND ah.date_effective <= th.date_effective AND nvl(ah.date_ineffective,sysdate+1) > th.date_effective AND ret.transaction_header_id_in = th.transaction_header_id AND ((UPPER(ret.retirement_type_code) like '%SALE%') OR ((ret.retirement_type_code is NULL) AND (ret.proceeds_of_sale > 0))) AND ret.asset_id = th.asset_id AND ret.status = 'PROCESSED' AND bk.transaction_header_id_out = th.transaction_header_id AND bk.book_type_code = :P_BOOK AND cbd.category_id = ah.category_id AND cbd.book_type_code = th.book_type_code AND (bk.date_placed_in_service between cbd.start_dpis and nvl(cbd.end_dpis,sysdate)) AND (months_between(ret.date_retired, bk.date_placed_in_service) > nvl(cbd.capital_gain_threshold,12)) AND ad.asset_id = th.asset_id AND ad.property_1245_1250_code in ('1245', '1250') AND cb.category_id = ad.asset_category_id AND cb.book_type_code = :P_BOOK and dh.asset_id = th.asset_id AND dh.book_type_code = :Distribution_Source_Book 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 sign(ret.gain_loss_amount), nvl(&ACCT_FLEX_BAL_SEG, 'None'), ad.property_1245_1250_code, cb.asset_cost_acct, ad.asset_number, ad.description, bk.date_placed_in_service, ret.date_retired,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') /*ORDER BY nvl(&ACCT_FLEX_BAL_SEG, 'None'), ad.property_1245_1250_code, cb.asset_cost_acct, lpad(ad.asset_number,15,0)*/ ORDER BY comp_code,GAIN_loss,class,account,ASSET_NUM,DPIS,DATE_SOLD,PROCEEDS, RESERVE,BASIS,GAIN OFA FAS446_XML AR FA نموذج 4797 - تقرير المبيعات أو تبادل الملكية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: نموذج 4797 - تقرير المبيعات أو تبادل الملكية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS446_XML DB package: FA_FAS446_XMLP_PKG D FA Formular 4797 - Veräußerung oder Umtausch von Vermögen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Formular 4797 - Veräußerung oder Umtausch von Vermögen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS446_XML DB package: FA_FAS446_XMLP_PKG F FA Form 4797 - Sales or Exchanges of Property (USA)- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Form 4797 - Sales or Exchanges of Property (USA) (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS446_XML DB package: FA_FAS446_XMLP_PKG US FA Form 4797 - Sales or Exchanges of Property - draft Application: Assets Source: Form 4797 - Sales or Exchanges of Property Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS446_XML DB package: FA_FAS446_XMLP_PKG ZHS FA 表单 4797 - 财产销售或交换报表- 不支持：已保留供将来使用 Application: 资产 Source: 表单 4797 - 财产销售或交换报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS446_XML DB package: FA_FAS446_XMLP_PKG BI Publisher &acct_flex_bal_seg :acct_bal_aprompt :acct_cc_aprompt :cat_maj_rprompt :distribution_source_book :gain_nls :loss_nls :p_book :p_conc_request_id :p_min_precision :p_period1 :p_period2 :period1_fy :period1_pcd :period1_pod :period2_fy :period2_pcd :period2_pod :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 帐簿 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