ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1C73869E053B46B63588994 SELECT bc.book_type_code Book, fama.feeder_system_name Feeder_System, fnduu.user_name Update_By, PO_VENDORS.vendor_name Vendor, fama.invoice_number INVNO, fama.invoice_date INVDATE, fama.mass_addition_id Asset, fama.description Description, fama.fixed_assets_cost Cost --Added during DT Fix ,FA_FAS828_XMLP_PKG.D_COSTFormula(fama.feeder_system_name) ,FA_FAS828_XMLP_PKG.currency_codeformula(bc.book_type_code) currency_code --End of DT Fix FROM FA_MASS_ADDITIONS fama, FA_BOOK_CONTROLS_SEC bc, fnd_user_view fnduu, po_vendors WHERE fama.POSTING_STATUS = 'DELETE' and fama.book_type_code = bc.book_type_code and bc.date_ineffective is null and fnduu.user_id(+) = fama.invoice_updated_by and po_vendors.vendor_id (+) = fama.po_vendor_id UNION SELECT bc.book_type_code Book, fama.feeder_system_name Feeder_System, fnduu.user_name Update_By, PO_VENDORS.vendor_name Vendor, fama.invoice_number INVNO, fama.invoice_date INVDATE, fama.mass_addition_id Asset, fama.description Description, fama.fixed_assets_cost Cost --Added during DT Fix ,FA_FAS828_XMLP_PKG.D_COSTFormula(fama.feeder_system_name) ,FA_FAS828_XMLP_PKG.currency_codeformula(bc.book_type_code) currency_code --End of DT Fix FROM FA_MASS_ADDITIONS famap, FA_MASS_ADDITIONS fama, FA_BOOK_CONTROLS_SEC bc, fnd_user_view fnduu, po_vendors WHERE famap.mass_addition_id = fama.parent_mass_addition_id and famap.POSTING_STATUS = 'DELETE' and fama.book_type_code = bc.book_type_code and famap.book_type_code = bc.book_type_code and fama.split_merged_code = 'MC' and bc.date_ineffective is null and fnduu.user_id(+) = fama.invoice_updated_by and po_vendors.vendor_id (+) = fama.po_vendor_id --ORDER BY 1,2,3,4,5,7 ORDER BY 1,2,4,3,5,6,7,8,9 OFA FAS828_XML AR FA تقرير العرض الأولي لحذف الإضافات المجمعة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير العرض الأولي لحذف الإضافات المجمعة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS828_XML DB package: FA_FAS828_XMLP_PKG D FA Globale Zugänge löschen - Vorschau- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Globale Zugänge löschen - Vorschau (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS828_XML DB package: FA_FAS828_XMLP_PKG F FA Etat de simulation de suppression d'acquisitions en haut volume- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat de simulation de suppression d'acquisitions en haut volume (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS828_XML DB package: FA_FAS828_XMLP_PKG US FA Delete Mass Additions Preview - draft Application: Assets Source: Delete Mass Additions Preview Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS828_XML DB package: FA_FAS828_XMLP_PKG ZHS FA 删除成批增加预览报表- 不支持：已保留供将来使用 Application: 资产 Source: 删除成批增加预览报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS828_XML DB package: FA_FAS828_XMLP_PKG BI Publisher :p_conc_request_id :p_min_precision :rp_company_name :rp_feeder_system :rp_report_name