ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1D73869E053B46B63588994 select fas.source, fas.company, fas.company_desc, fas.asset_type, fas.account, fas.account_desc, fas.cost_center, fas.cost_center_desc, fas.asset_number, fas.asset_description, fas.vendor_number, fas.invoice_number, fas.invoice_line, fas.invoice_description, fas.original_invoice_cost, fas.current_invoice_cost, fas.asset_cost, (select flv.meaning from fa_lookups_vl flv where flv.lookup_type = 'INVOICE TRANSACTION TYPE' and flv.lookup_code = fas.trx_flag) trx_flag, case when fas.asset_cost is not null and fas.asset_type_code = 'CIP' then case when sum(fas.current_invoice_cost) over (partition by fas.source,fas.company,fas.asset_type,fas.account,fas.cost_center,fas.asset_number) != sum(fas.asset_cost) over (partition by fas.source,fas.company,fas.asset_type,fas.account,fas.cost_center,fas.asset_number) then sum(fas.asset_cost) over (partition by fas.source,fas.company,fas.asset_type,fas.account,fas.cost_center,fas.asset_number) - sum(fas.current_invoice_cost) over (partition by fas.source,fas.company,fas.asset_type,fas.account,fas.cost_center,fas.asset_number) else to_number(null) end end unbalanced_amount, case when fas.asset_cost is not null and fas.asset_type_code = 'CIP' then case when sum(fas.current_invoice_cost) over (partition by fas.source,fas.company,fas.asset_type,fas.account,fas.cost_center,fas.asset_number) != sum(fas.asset_cost) over (partition by fas.source,fas.company,fas.asset_type,fas.account,fas.cost_center,fas.asset_number) then 'Y' else 'N' end end unbalanced_flag, fas.company || ' - ' || fas.company_desc company_label, fas.account || ' - ' || fas.account_desc account_label, fas.cost_center || ' - ' || fas.cost_center_desc cost_center_label, fas.asset_number || ' - ' || fas.asset_description asset_label from ( select decode(th.mass_reference_id,null,'Manual','Mass Additions') source, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, NULL, dhcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') company, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, NULL, dhcc.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION') company_desc, ah.asset_type asset_type_code, falu.meaning asset_type, decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct) account, gl_flexfields_pkg.get_description(dhcc.chart_of_accounts_id,'GL_ACCOUNT',decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct)) account_desc, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE') cost_center, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'DESCRIPTION') cost_center_desc, -- ad.asset_number, ad.description asset_description, null vendor_number, null invoice_number, to_number(null) invoice_line, null invoice_description, to_number(null) original_invoice_cost, to_number(null) current_invoice_cost, sum(nvl(dd.addition_cost_to_clear, 0)) asset_cost, null trx_flag, 1 ord_by from fa_distribution_history dh, fa_asset_history ah, fa_category_books cb, fa_lookups falu, fa_additions ad, gl_code_combinations dhcc, fa_transaction_headers th, fa_deprn_detail dd, fa_deprn_periods dp where dp.book_type_code =:p_book and dp.period_counter >=:period1_pc and dp.period_counter <= nvl(:period2_pc, dp.period_counter) and th.asset_id = dd.asset_id and th.date_effective >= dp.period_open_date and th.date_effective < nvl(dp.period_close_date, sysdate) and th.book_type_code = :p_book and th.transaction_type_code in ('TRANSFER IN','TRANSFER IN/VOID') and th.transaction_header_id = (select min(transaction_header_id) from fa_transaction_headers thvoid where thvoid.book_type_code = th.book_type_code and thvoid.transaction_type_code in ('TRANSFER IN/VOID', 'TRANSFER IN') and thvoid.asset_id = th.asset_id) and dh.book_type_code = :p_distrib_source_book and dh.asset_id = dd.asset_id and dhcc.code_combination_id = dh.code_combination_id and dd.book_type_code = :p_book and dd.deprn_source_code = 'B' and dd.distribution_id = dh.distribution_id and dd.period_counter = dp.period_counter - 1 and cb.category_id = ah.category_id and cb.book_type_code = :p_book and ad.asset_id = dd.asset_id and ah.asset_id = ad.asset_id and ah.date_effective <= nvl(dp.period_close_date, sysdate) and nvl(ah.date_ineffective,sysdate+1) > nvl(dp.period_close_date, sysdate) and ah.asset_type = falu.lookup_code and falu.lookup_type = 'ASSET TYPE' group by decode(th.mass_reference_id,null,'Manual','Mass Additions'), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', '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('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, NULL, dhcc.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION'), ah.asset_type, falu.meaning, decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct), gl_flexfields_pkg.get_description(dhcc.chart_of_accounts_id,'GL_ACCOUNT',decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct)), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'DESCRIPTION'), ad.asset_number, ad.description union all select decode(th.mass_reference_id,null,'Manual','Mass Additions') source, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, NULL, dhcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') company, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, NULL, dhcc.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION') company_desc, ah.asset_type asset_type_code, falu.meaning asset_type, decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct) account, gl_flexfields_pkg.get_description(dhcc.chart_of_accounts_id,'GL_ACCOUNT',decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct)) account_desc, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE') cost_center, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'DESCRIPTION') cost_center_desc, -- ad.asset_number, ad.description asset_descripton, null vendor_number, null invoice_number, to_number(null) invoice_line, null invoice_description, to_number(null) original_invoice_cost, to_number(null) current_invoice_cost, sum(decode(adj.debit_credit_flag, 'DR',1,-1) * adj.adjustment_amount) asset_cost, null trx_flag, 1 ord_by from fa_transaction_headers th, fa_transaction_headers thdis, fa_additions ad, fa_asset_history ah, fa_category_books cb, fa_distribution_history dh, gl_code_combinations dhcc, gl_code_combinations ajcc, fa_lookups falu, fa_adjustments adj, fa_deprn_periods dp where dp.book_type_code = :p_book and dp.period_counter >= :period1_pc and dp.period_counter <= nvl(:period2_pc,dp.period_counter) and th.date_effective >= dp.period_open_date and th.date_effective < nvl(dp.period_close_date, sysdate) and th.book_type_code = :p_book and th.transaction_type_code = 'ADDITION' and thdis.transaction_type_code = 'TRANSFER IN' and thdis.book_type_code = :p_book and thdis.asset_id = th.asset_id and thdis.date_effective < dp.period_open_date and adj.book_type_code = :p_book and adj.asset_id = th.asset_id and adj.source_type_code = 'ADDITION' and adj.adjustment_type = 'COST' and adj.period_counter_created = dp.period_counter and adj.code_combination_id = ajcc.code_combination_id and dh.book_type_code = :p_book and dh.asset_id = th.asset_id and dh.distribution_id = adj.distribution_id and dh.code_combination_id = dhcc.code_combination_id and cb.category_id = ah.category_id and cb.book_type_code = :p_book and ad.asset_id = th.asset_id 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 ah.asset_type = falu.lookup_code and falu.lookup_type = 'ASSET TYPE' group by decode(th.mass_reference_id,null,'Manual','Mass Additions'), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', '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('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, NULL, dhcc.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION'), ah.asset_type, falu.meaning, decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct), gl_flexfields_pkg.get_description(dhcc.chart_of_accounts_id,'GL_ACCOUNT',decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct)), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'DESCRIPTION'), ad.asset_number, ad.description union all select decode(th.mass_reference_id,null,'Manual','Mass Additions') source, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, NULL, dhcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') company, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, NULL, dhcc.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION') company_desc, ah.asset_type asset_type_code, falu.meaning asset_type, decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct) account, gl_flexfields_pkg.get_description(dhcc.chart_of_accounts_id,'GL_ACCOUNT',decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct)) account_desc, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE') cost_center, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'DESCRIPTION') cost_center_desc, -- ad.asset_number, ad.description asset_description, po_vend.segment1 vendor_number, ai_in.invoice_number invoice_number, ai_in.invoice_line_number||' - '||ai_in.ap_distribution_line_number invoice_line, ai_in.description invoice_description, ai_in.payables_cost original_invoice_cost, round(sum(dh.units_assigned/ah.units * ai_in.fixed_assets_cost), :precision) current_invoice_cost, to_number(null) asset_cost, case when it.transaction_type in ('INVOICE ADDITION', 'INVOICE ADJUSTMENT', 'INVOICE TRANSFER','INVOICE REINSTATE') then it.transaction_type else null end trx_flag, 2 ord_by from fa_asset_invoices ai_in, fa_invoice_transactions it, fa_transaction_headers th, fa_distribution_history dh, fa_asset_history ah, fa_category_books cb, fa_lookups falu, po_vendors po_vend, fa_additions ad, gl_code_combinations dhcc, fa_deprn_detail dd, fa_deprn_periods dp where dp.book_type_code = :p_book and dp.period_counter >= :period1_pc and dp.period_counter <= nvl(:period2_pc,dp.period_counter) and th.asset_id = dd.asset_id and th.date_effective >= dp.period_open_date and th.date_effective < nvl(dp.period_close_date, sysdate) and th.book_type_code = :p_book and th.transaction_type_code in ('TRANSFER IN','TRANSFER IN/VOID') and th.transaction_header_id = (select min(transaction_header_id) from fa_transaction_headers thvoid where thvoid.book_type_code = th.book_type_code and thvoid.transaction_type_code in ('TRANSFER IN/VOID', 'TRANSFER IN') and thvoid.asset_id = th.asset_id) and dh.book_type_code = :p_distrib_source_book and dh.asset_id = dd.asset_id and dhcc.code_combination_id = dh.code_combination_id and dd.book_type_code = :p_book and dd.deprn_source_code = 'B' and dd.distribution_id = dh.distribution_id and dd.period_counter = dp.period_counter - 1 and cb.category_id = ah.category_id and cb.book_type_code = :p_book and ad.asset_id = dd.asset_id and ah.asset_id = ad.asset_id and ah.date_effective <= nvl(dp.period_close_date, sysdate) and nvl(ah.date_ineffective,sysdate+1) > nvl(dp.period_close_date, sysdate) and ah.asset_type = falu.lookup_code and falu.lookup_type = 'ASSET TYPE' and it.invoice_transaction_id = ai_in.invoice_transaction_id_in and ai_in.asset_id = th.asset_id and ai_in.date_effective <= nvl(dp.period_close_date, sysdate) and nvl(ai_in.date_ineffective, sysdate+1) > nvl(dp.period_close_date, sysdate) and ai_in.deleted_flag = 'NO' and po_vend.vendor_id(+) = ai_in.po_vendor_id group by decode(th.mass_reference_id,null,'Manual','Mass Additions'), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', '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('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, NULL, dhcc.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION'), ah.asset_type, falu.meaning, decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct), gl_flexfields_pkg.get_description(dhcc.chart_of_accounts_id,'GL_ACCOUNT',decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct)), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'DESCRIPTION'), ad.asset_number, ad.description, po_vend.segment1, ai_in.invoice_number, ai_in.invoice_line_number||' - '||ai_in.ap_distribution_line_number, ai_in.description, ai_in.payables_cost, case when it.transaction_type in ('INVOICE ADDITION', 'INVOICE ADJUSTMENT', 'INVOICE TRANSFER','INVOICE REINSTATE') then it.transaction_type else null end union all select decode(th.mass_reference_id,null,'Manual','Mass Additions') source, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, NULL, dhcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') company, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, NULL, dhcc.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION') company_desc, ah.asset_type asset_type_code, falu.meaning asset_type, decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct) account, gl_flexfields_pkg.get_description(dhcc.chart_of_accounts_id,'GL_ACCOUNT',decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct)) account_desc, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE') cost_center, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'DESCRIPTION') cost_center_desc, -- ad.asset_number, ad.description asset_description, po_vend.segment1 vendor_number, ai_in.invoice_number invoice_number, ai_in.invoice_line_number||' - '||ai_in.ap_distribution_line_number invoice_line, ai_in.description invoice_description, ai_in.payables_cost original_invoice_cost, round(sum(dh.units_assigned/ah.units * ai_in.fixed_assets_cost),:precision) current_invoice_cost, to_number(null) asset_cost, case when it.transaction_type in ('INVOICE ADDITION', 'INVOICE ADJUSTMENT', 'INVOICE TRANSFER','INVOICE REINSTATE') then it.transaction_type else null end trx_flag, 2 ord_by from fa_asset_invoices ai_in, fa_invoice_transactions it, fa_transaction_headers thdis, fa_distribution_history dh, fa_asset_history ah, fa_category_books cb, fa_lookups falu, po_vendors po_vend, fa_additions ad, gl_code_combinations dhcc, fa_transaction_headers th, fa_deprn_periods dp where dp.book_type_code = :p_book and dp.period_counter >=:period1_pc and dp.period_counter <= nvl(:period2_pc,dp.period_counter) and th.date_effective >= dp.period_open_date and th.date_effective < nvl(dp.period_close_date, sysdate) and th.book_type_code = :p_book and th.transaction_type_code = 'ADDITION' and thdis.transaction_type_code = 'TRANSFER IN' and thdis.book_type_code = :p_book and thdis.asset_id = th.asset_id and thdis.date_effective < dp.period_open_date and dh.book_type_code = :p_book and dh.asset_id = th.asset_id and dh.code_combination_id = dhcc.code_combination_id and dh.date_effective <= th.date_effective and nvl(dh.date_ineffective, sysdate) > th.date_effective and cb.category_id = ah.category_id and cb.book_type_code = :p_book and ad.asset_id = th.asset_id 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 ah.asset_type = falu.lookup_code and falu.lookup_type = 'ASSET TYPE' and it.invoice_transaction_id = ai_in.invoice_transaction_id_in and ai_in.asset_id = th.asset_id and ai_in.date_effective <= nvl(dp.period_close_date, sysdate) and nvl(ai_in.date_ineffective, sysdate+1) > nvl(dp.period_close_date, sysdate) and ai_in.deleted_flag = 'NO' and po_vend.vendor_id(+) = ai_in.po_vendor_id group by decode(th.mass_reference_id,null,'Manual','Mass Additions'), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', '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('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, NULL, dhcc.code_combination_id, 'GL_BALANCING', 'Y', 'DESCRIPTION'), ah.asset_type, falu.meaning, decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct), gl_flexfields_pkg.get_description(dhcc.chart_of_accounts_id,'GL_ACCOUNT',decode(ah.asset_type, 'CIP', cb.cip_cost_acct, cb.asset_cost_acct)), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', dhcc.chart_of_accounts_id, null, dhcc.code_combination_id, 'FA_COST_CTR', 'Y', 'DESCRIPTION'), ad.asset_number, ad.description, po_vend.segment1, ai_in.invoice_number, ai_in.invoice_line_number||' - '||ai_in.ap_distribution_line_number, ai_in.description, ai_in.payables_cost, case when it.transaction_type in ('INVOICE ADDITION', 'INVOICE ADJUSTMENT', 'INVOICE TRANSFER','INVOICE REINSTATE') then it.transaction_type else null end ) fas order by fas.source, fas.company, fas.asset_type, fas.account, fas.cost_center, fas.asset_number, fas.asset_description, fas.ord_by, fas.vendor_number, fas.invoice_number, fas.invoice_line, fas.invoice_description Y OFA #,##0.00;[Red]-#,##0.00 AR FA تقرير الإضافات حسب المصدر (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير الإضافات حسب المصدر (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASASSBS_XML DB package: FA_FASASSBS_XMLP_PKG D FA Anlagenzugänge nach Herkunft- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Anlagenzugänge nach Herkunft (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASASSBS_XML DB package: FA_FASASSBS_XMLP_PKG F FA Etat des acquisitions par origine- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des acquisitions par origine (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FASASSBS_XML DB package: FA_FASASSBS_XMLP_PKG US FA Additions By Source Application: Assets Source: Additions By Source Report Short Name: FASASSBS ZHS FA 按来源列出的增加报表- 不支持：已保留供将来使用 Application: 资产 Source: 按来源列出的增加报表 (XML) - 不支持：已保留供将来使用 Short Name: FASASSBS_XML DB package: FA_FASASSBS_XMLP_PKG Enginatics R12 only :p_book :p_distrib_source_book :period1_pc :period2_pc :precision 1 -100 :p_distrib_source_book Char select fbc.distribution_source_book from fa_book_controls fbc where fbc.book_type_code = :$flex$.Book F Livre source de la distribution US Distribution Source Book 2 -90 :period1_pc Number select fdp.period_counter from fa_deprn_periods fdp where fdp.book_type_code = :$flex$.Book and fdp.period_name = :$flex$.From_Period F Période Compteur De US Period Counter From 3 -80 :period2_pc Number select fdp.period_counter from fa_deprn_periods fdp where fdp.book_type_code = :$flex$.Book and fdp.period_name = :$flex$.To_Period F Période Compteur à US Period Counter To 4 -70 :precision Number select fc.precision from fa_book_controls fbc, gl_sets_of_books gsob, fnd_currencies fc where fbc.book_type_code = :$flex$.Book and fbc.set_of_books_id = gsob.set_of_books_id and fc.currency_code = gsob.currency_code F Précision US Precision 5 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 select case when xrpv.parameter_type='LOV Oracle' and xrrpv.value not like '<multiple_values>%' then xxen_report.id_to_value(xrpv.parameter_id,xrrpv.value) else xrrpv.value end value from xxen_report_parameters_v xrpv, (select xrr.report_id,max(xrr.run_id) run_id from xxen_report_runs xrr where xrr.created_by = fnd_global.user_id and xrr.responsibility_id = fnd_global.resp_id group by xrr.report_id) xrr, xxen_report_run_param_values xrrpv where xrpv.report_name = 'FA Additions By Source' and xrpv.parameter_name = 'Book' and xrpv.report_id = xrr.report_id and xrr.run_id = xrrpv.run_id and xrpv.parameter_id = xrrpv.parameter_id Y AR الدفتر D AfA-Buch F Livre US Book ZHS 帐簿 6 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 select fdp.period_name from fa_deprn_periods fdp where fdp.book_type_code=:$flex$.fa_book_type and fdp.period_counter= (select max(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_type and dp2.period_close_date is not null) Y AR من الفترة D Von Periode F De la période US From Period ZHS 自期间 7 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 :$flex$.From_Period Y AR إلى الفترة D Bis Periode F À la période US To Period ZHS 至期间 :$flex$.Book Book Distribution Source Book :$flex$.Book Book Period Counter From :$flex$.Book Book Period Counter To :$flex$.Book Book Precision :$flex$.From_Period From Period Period Counter From :$flex$.From_Period From Period To Period :$flex$.To_Period To Period Period Counter To :$flex$.fa_book_type Book From Period :$flex$.fa_book_type Book To Period :$flex$.fa_period_name From Period To Period Pivot: Default Template Pivot by Source, Balancing Segment, Asset Type, Asset Account, Cost Center, Asset SYSADMIN 4 ACCOUNT 19 ACCOUNT_LABEL 14 ASSET_COST 7 ASSET_DESCRIPTION 21 ASSET_LABEL 6 ASSET_NUMBER 3 ASSET_TYPE 2 COMPANY 18 COMPANY_LABEL 5 COST_CENTER 20 COST_CENTER_LABEL 13 CURRENT_INVOICE_COST 11 INVOICE_DESCRIPTION 10 INVOICE_LINE 9 INVOICE_NUMBER 12 ORIGINAL_INVOICE_COST 1 SOURCE 17 TRX_FLAG 15 UNBALANCED_AMOUNT 16 UNBALANCED_FLAG 8 VENDOR_NUMBER ACCOUNT_LABEL ROW 4 ASSET_COST VALUE 3 SUM ASSET_LABEL ROW 6 ASSET_TYPE ROW 3 COMPANY_LABEL ROW 2 COST_CENTER_LABEL ROW 5 CURRENT_INVOICE_COST VALUE 2 SUM ORIGINAL_INVOICE_COST VALUE 1 SUM SOURCE ROW 1 UNBALANCED_AMOUNT VALUE 4 SUM S Site Pivot: Default Template