ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2023869E053B46B63588994 select &ACCT_FLEX_BAL_SEG comp_code, &ACCT_FLEX_ALL_SEG expense_account, &KEY_FLEX_ALL_SEG asset_key, fa.asset_number, fa.tag_number, fa.description, fd.period_name, decode(substr(ft.transaction_name, 1,5),'UNPL ',substr(upper(ft.transaction_name),6), 'UNPLA',substr(upper(ft.transaction_name),23), ft.transaction_subtype ) t_name, fj.adjustment_amount, fj.debit_credit_flag, fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('expense_account_dsp', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') EXPENSE_ACCOUNT_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('asset_key_dsp', 'OFA', 'KEY#', 101, NULL, fk.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') ASSET_KEY_DSP1, FA_FASUNPLD_XMLP_PKG.C_base_currency_code_p C_base_currency_code from fa_additions fa, fa_deprn_periods fd, fa_transaction_headers ft, fa_adjustments fj, gl_code_combinations cc, fa_asset_keywords fk where ft.asset_id = fa.asset_id and fj.asset_id = fa.asset_id and ft.transaction_header_id = fj.transaction_header_id and fd.period_counter = fj.period_counter_created and fj.source_type_code = 'DEPRECIATION' and fj.adjustment_type = 'EXPENSE' and fj.period_counter_adjusted between :start_period_COUNTER and :end_period_COUNTER and ((ft.transaction_subtype = &P_DEPRN_TYPE_1 or ft.transaction_name like 'UNPL'||'%'||&P_DEPRN_TYPE_1) or(ft.transaction_key like 'U%' and &P_DEPRN_TYPE_1 = '%' )) and fj.book_type_code = :P_ASSET_BOOK_TYPE and fd.book_type_code = fj.book_type_code and cc.code_combination_id = fj.code_combination_id and fk.code_combination_id = fa.asset_key_ccid UNION ALL select null comp_code, null expense_account, null asset_key, a.asset_number, null tag_number, null description, null period_name, null t_name, sum(nvl(d.deprn_adjustment_amount,0)) adjustment_amount, null debit_credit_flag, --added null COMP_CODE_DSP, null EXPENSE_ACCOUNT_DSP, null ASSET_KEY_DSP1, FA_FASUNPLD_XMLP_PKG.C_base_currency_code_p C_base_currency_code from fa_deprn_detail d, fa_additions a where d.book_type_code = :P_ASSET_BOOK_TYPE and d.deprn_source_code = 'B' and a.asset_id = d.asset_id group by null, null, null, a.asset_number, null, null, null, null, null ,null,null,null having sum(nvl(d.deprn_adjustment_amount,0)) != 0 order by asset_number, period_name OFA FASUNPLD_XML AR FA الإهلاك غير المخطط (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: الإهلاك غير المخطط (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASUNPLD_XML DB package: FA_FASUNPLD_XMLP_PKG D FA Außerplanmäßige Abschreibung- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Außerplanmäßige Abschreibung (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASUNPLD_XML DB package: FA_FASUNPLD_XMLP_PKG F FA Amortissement non planifié- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Amortissement non planifié (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FASUNPLD_XML DB package: FA_FASUNPLD_XMLP_PKG US FA Unplanned Depreciation - draft Application: Assets Source: Unplanned Depreciation (XML) - Not Supported: Reserved For Future Use Short Name: FASUNPLD_XML DB package: FA_FASUNPLD_XMLP_PKG ZHS FA 计划外折旧- 不支持：已保留供将来使用 Application: 资产 Source: 计划外折旧 (XML) - 不支持：已保留供将来使用 Short Name: FASUNPLD_XML DB package: FA_FASUNPLD_XMLP_PKG BI Publisher &acct_flex_all_seg &acct_flex_bal_seg &key_flex_all_seg &p_deprn_type_1 :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_last_open :c_nls_all :c_nls_end_of_report :c_nls_na :c_nls_no :c_nls_no_data_exists :c_nls_void :c_nls_yes :c_report_start_date :end_period_counter :p_asset_book_type :p_conc_request_id :p_debug_switch :p_deprn_type :p_deprn_type_1 :p_flexdata :p_min_precision :p_period_end_name :p_period_start_name :p_set_of_books_id :start_period_counter 1 10 :p_asset_book_type 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 Art AfA-Buch F Type de livre d'amortissement US Asset Book Type ZHS 资产帐簿类型 2 20 :p_deprn_type LOV Oracle JEDE_UNPLANNED_DEP_TYPES Y select lookup_code id, lookup_code value, meaning description from fa_lookups where lookup_type='UNPLANNED DEPRN' order by value,description AR نوع إهلاك غير مخطط D Art außerplanmäßige Abschreibung F Type amort. non planifié US Unplanned Deprn Type ZHS 计划外折旧类型 3 30 :p_period_start_name 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 Nom période de départ US Period Start Name ZHS 期初名称 4 40 :p_period_end_name 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 Nom période de fin US Period End Name ZHS 期末名称 :$flex$.fa_book_type Asset Book Type Period End Name :$flex$.fa_book_type Asset Book Type Period Start Name :$flex$.fa_period_name Period Start Name Period End Name