ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1BD3869E053B46B63588994 select decode(in_out.asset_type, 'CIP', :MEANING_CIP, 'CAPITALIZED', :MEANING_CAP, 'EXPENSED', :MEANING_EXP, '') D_ASSET_TYPE, --&ACCT_FLEX_BAL_SEG COMPANY_CODE, fnd_flex_xml_publisher_apis.process_kff_combination_1('company_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMPANY_CODE_DSP1, decode (th.date_effective, in_out.date_effective, decode(in_out.asset_type, 'CIP',to_cb.cip_cost_acct, to_cb.asset_cost_acct), decode(in_out.asset_type, 'CIP', from_cb.cip_cost_acct, from_cb.asset_cost_acct)) ASSET_ACCT, --&ACCT_FLEX_COST_SEG COST_CTR, fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_ctr_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') COST_CTR_DSP1, decode(in_out.asset_type, 'CIP', '', decode (th.date_effective, in_out.date_effective, to_cb.deprn_reserve_acct, from_cb.deprn_reserve_acct)) reserve_acct, decode (th.date_effective, in_out.date_effective, 'IN', 'OUT') IN_OUT_CODE, ad.asset_number || ' - ' || ad.description ASSET_NUMBER, decode (th.date_effective, in_out.date_effective, 1, -1) * sum (cost_adj.adjustment_amount) COST_ADJ, decode (th.date_effective, in_out.date_effective, 1, -1) * sum(nvl(res_adj.adjustment_amount,0.00)) RES_ADJ, --&CAT_FLEX_ALL_SEG_FR FROM_CATEGORY, --&CAT_FLEX_ALL_SEG_TO TO_CATEGORY fnd_flex_xml_publisher_apis.process_kff_combination_1('d_from_category', 'OFA', 'CAT#', 101, NULL, fcat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_FROM_CATEGORY1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_to_category', 'OFA', 'CAT#', 101, NULL, tcat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_TO_CATEGORY1 from fa_additions ad, gl_code_combinations dhcc, fa_categories fcat, fa_categories tcat, fa_category_books from_cb, fa_category_books to_cb, fa_asset_history from_ah, fa_asset_history to_ah, fa_asset_history in_out, fa_distribution_history dh, fa_adjustments cost_adj, fa_adjustments res_adj, fa_transaction_headers th where th.book_type_code = :P_BOOK and th.transaction_type_code = 'RECLASS' and th.date_effective between :PERIOD1_POD and :PERIOD2_PCD and ad.asset_id = th.asset_id and dh.book_type_code = :DISTRIBUTION_SOURCE_BOOK and dh.asset_id = th.asset_id and dhcc.code_combination_id = dh.code_combination_id and cost_adj.transaction_header_id = th.transaction_header_id and cost_adj.book_type_code = :P_BOOK and cost_adj.source_type_code = 'RECLASS' and cost_adj.adjustment_type in ('COST', 'CIP COST') and cost_adj.debit_credit_flag = 'CR' and cost_adj.distribution_id = dh.distribution_id and res_adj.transaction_header_id (+) = cost_adj.transaction_header_id and res_adj.book_type_code(+) = :P_BOOK and res_adj.source_type_code(+) = 'RECLASS' and res_adj.adjustment_type(+) = 'RESERVE' and res_adj.debit_credit_flag(+) = 'DR' and res_adj.distribution_id(+) = cost_adj.distribution_id and to_ah.asset_id = th.asset_id and to_ah.date_effective = th.date_effective and in_out.asset_id = th.asset_id and th.date_effective in (in_out.date_effective, in_out.date_ineffective) and from_ah.asset_id = th.asset_id and from_ah.date_ineffective = th.date_effective and tcat.category_id = to_ah.category_id and fcat.category_id = from_ah.category_id and to_cb.category_id = to_ah.category_id and to_cb.book_type_code = :P_BOOK and from_cb.category_id = from_ah.category_id and from_cb.book_type_code = :P_BOOK group by decode(in_out.asset_type, 'CIP', :MEANING_CIP, 'CAPITALIZED', :MEANING_CAP, 'EXPENSED', :MEANING_EXP, ''), /* &ACCT_FLEX_BAL_SEG, &ACCT_FLEX_COST_SEG,*/ fnd_flex_xml_publisher_apis.process_kff_combination_1('company_code_dsp', '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('cost_ctr_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE'), decode (th.date_effective, in_out.date_effective, decode(in_out.asset_type, 'CIP',to_cb.cip_cost_acct, to_cb.asset_cost_acct), decode(in_out.asset_type, 'CIP', from_cb.cip_cost_acct, from_cb.asset_cost_acct)), decode(in_out.asset_type, 'CIP', '', decode (th.date_effective, in_out.date_effective, to_cb.deprn_reserve_acct, from_cb.deprn_reserve_acct)), th.date_effective, in_out.date_effective, in_out.date_ineffective, in_out.units, ad.asset_number, ad.description, /*&CAT_FLEX_ALL_SEG_FR, &CAT_FLEX_ALL_SEG_TO,*/ fnd_flex_xml_publisher_apis.process_kff_combination_1('d_from_category', 'OFA', 'CAT#', 101, NULL, fcat.CATEGORY_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('d_to_category', 'OFA', 'CAT#', 101, NULL, tcat.CATEGORY_ID, 'ALL', 'Y', 'VALUE'), th.transaction_header_id, ad.asset_id order by /* 2, 1, lpad ( decode (th.date_effective, in_out.date_effective, decode(in_out.asset_type, 'CIP',to_cb.cip_cost_acct, to_cb.asset_cost_acct), decode(in_out.asset_type, 'CIP', from_cb.cip_cost_acct, from_cb.asset_cost_acct)), 25,0), 4, decode (th.date_effective, in_out.date_effective, 1, 2), asset_number*/ 2, 1, 3, 4, 5, 6, 7, 8, 9, 10, 11 Y OFA FAS741_XML AR FA تقرير تسوية إعادة تصنيف الأصل (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير تسوية إعادة تصنيف الأصل (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS741_XML DB package: FA_FAS741_XMLP_PKG D FA Anlagenneuklassifizierung - Abstimmung- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Anlagenneuklassifizierung - Abstimmung (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS741_XML DB package: FA_FAS741_XMLP_PKG F FA Etat de rapprochement des reclassements d'immobilisations- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat de rapprochement des reclassements d'immobilisations (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS741_XML DB package: FA_FAS741_XMLP_PKG US FA Asset Reclassification Reconciliation - draft Application: Assets Source: Asset Reclassification Reconciliation Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS741_XML DB package: FA_FAS741_XMLP_PKG ZHS FA 资产重新分类调节报表- 不支持：已保留供将来使用 Application: 资产 Source: 资产重新分类调节报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS741_XML DB package: FA_FAS741_XMLP_PKG BI Publisher &acct_flex_bal_seg &acct_flex_cost_seg &cat_flex_all_seg_fr &cat_flex_all_seg_to :accounting_flex_structure :acct_cc_lprompt :currency_code :distribution_source_book :meaning_cap :meaning_cip :meaning_exp :p_book :p_conc_request_id :p_min_precision :p_period1 :p_period2 :period1_pod :period2_pcd 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 至期间