ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1E53869E053B46B63588994 SELECT ad.asset_number Asset_Number, decode(ai.merged_code,'MP',ad.description, 'MC',ai.description) Description, ve.segment1||' - '||ve.vendor_name Vendor, ai.invoice_number Invoice_Number, ai.invoice_line_number||' - '|| ai.ap_distribution_line_number Line, &ACCT_FLEX_ACCT_SEG Payables_Account, cb.asset_cost_acct Assets_Account, nvl(ai.payables_cost,0.00) Payables_Cost, decode(ai.merged_code,'MC',0,books.cost) Assets_Cost, --ADDED fnd_flex_xml_publisher_apis.process_kff_combination_1('d_payables_account', 'SQLGL', 'GL#', glcc.CHART_OF_ACCOUNTS_ID, NULL, glcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') D_PAYABLES_ACCOUNT FROM fa_transaction_headers th, fa_asset_invoices ai, fa_additions ad, fa_books books, fa_asset_history ah, fa_category_books cb, po_vendors ve, gl_code_combinations glcc WHERE th.date_effective >= :PERIOD1_POD AND th.date_effective <= NVL(:PERIOD1_PCD,sysdate) AND th.book_type_code = :P_BOOK AND th.transaction_type_code in ('ADDITION','CIP ADDITION') AND ai.asset_id = th.asset_id AND ai.merged_code in ('MP','MC') AND ai.split_code is null AND ad.asset_id = ai.asset_id AND books.transaction_header_id_in = th.transaction_header_id AND ve.vendor_id = ai.po_vendor_id AND ah.asset_id = ai.asset_id AND ah.date_effective <= nvl(:PERIOD1_PCD,sysdate) aND nvl(ah.date_ineffective, sysdate+1) > nvl(:PERIOD1_PCD,sysdate) AND cb.category_id = ah.category_id AND cb.book_type_code = th.book_type_code AND ai.payables_code_combination_id = glcc.code_combination_id ORDER BY ad.asset_number, decode(ai.merged_code,'MP',1,0) desc, ai.invoice_number, ai.invoice_line_number|| ' - '||ai.ap_distribution_line_number Y OFA FASMAIMR_XML AR FA تقرير دمج فاتورة الإضافات المجمعة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير دمج فاتورة الإضافات المجمعة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASMAIMR_XML DB package: FA_FASMAIMR_XMLP_PKG D FA Globale Zugänge - zusammengefasst- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Globale Zugänge - zusammengefasst (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASMAIMR_XML DB package: FA_FASMAIMR_XMLP_PKG F FA Etat des acquisitions en haut volume issues de la fusion de lignes de facture- Non pris en charge : réservé pour une utilisation ultérieure Application: Assets Source: Etat des acquisitions en haut volume issues de la fusion de lignes de facture (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: FASMAIMR_XML DB package: FA_FASMAIMR_XMLP_PKG US FA Mass Additions Invoice Merge - draft Application: Assets Source: Mass Additions Invoice Merge Report (XML) - Not Supported: Reserved For Future Use Short Name: FASMAIMR_XML DB package: FA_FASMAIMR_XMLP_PKG ZHS FA 成批增加发票合并报表- 不支持：已保留供将来使用 Application: 资产 Source: 成批增加发票合并报表 (XML) - 不支持：已保留供将来使用 Short Name: FASMAIMR_XML DB package: FA_FASMAIMR_XMLP_PKG BI Publisher &acct_flex_acct_seg :accounting_flex_structure :currency_code :p_book :p_conc_request_id :p_min_precision :p_period1 :period1_fy :period1_pc :period1_pcd :period1_pod :rp_company_name :rp_data_found :rp_report_name 1 10 :p_book LOV Oracle FA_CORP_BOOK Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class='CORPORATE' order by book_type_code Y AR الدفتر D AfA-Buch F Livre US Book ZHS 帐簿 2 20 :p_period1 LOV Oracle FA_PERIOD_NAME_CORP Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_corp_book and period_counter>(select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_corp_book) order by period_counter Y AR الفترة D Periode F Période US Period ZHS 期间