ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3F53869E053B46B63588994Y select poi.column_name column_name2,poi.error_message, rti.interface_transaction_id, rti.vendor_name, rti.vendor_num, rti.shipment_num, rti.transaction_type, to_char(rti.transaction_date,'DD-MON-YYYY HH24:MI:SS') transaction_date, to_char(rti.creation_date,'DD-MON-YYYY HH24:MI:SS') creation_date, rti.created_by, rti.to_organization_code, rti.ship_to_location_code, rti.document_num, rti.release_num, rti.document_line_num, rti.document_shipment_line_num, rti.vendor_item_num, rti.item_num, rti.job_id, rti.timecard_id, rti.timecard_ovn, rti.substitute_item_num, rti.item_description, to_char(rti.expected_receipt_date,'DD-MON-YYYY HH24:MI:SS') expected_receipt_date, rti.quantity, rti.amount, rti.unit_of_measure, rti.quantity_invoiced from po_interface_errors poi,rcv_transactions_interface rti where ((poi.interface_line_id = rti.interface_transaction_id and poi.interface_type='RCV-856') or (poi.interface_transaction_id = rti.interface_transaction_id and poi.interface_type in ('RECEIVE','DELIVER'))) and ((trunc(to_date(to_char(poi.creation_date,'DD-MON-YYYY'),'DD-MON-YYYY')) between nvl(:p_start_date,poi.creation_date) and nvl(:p_end_date,sysdate) and (:p_start_date is not null or :p_end_date is not null)) OR (:p_start_date is null and :p_end_date is null and rti.processing_status_code NOT IN ('PENDING'))) order by rti.interface_transaction_id,rti.vendor_name PO RCVIERR_XML AR PO تقرير أخطاء واجهة الاستلام (بتنسيق XML) Application: المشتريات Source: تقرير أخطاء واجهة الاستلام (بتنسيق XML) Short Name: RCVIERR_XML DB package: PO_RCVIERR_XMLP_PKG D PO Wareneingang - Übertragungsfehler Application: Einkauf Source: Wareneingang - Übertragungsfehler (XML) Short Name: RCVIERR_XML DB package: PO_RCVIERR_XMLP_PKG F PO Etat des erreurs de l'interface des réceptions Application: Purchasing Source: Etat des erreurs de l'interface des réceptions (XML) Short Name: RCVIERR_XML DB package: PO_RCVIERR_XMLP_PKG US PO Receiving Interface Errors Application: Purchasing Source: Receiving Interface Errors Report (XML) Short Name: RCVIERR_XML DB package: PO_RCVIERR_XMLP_PKG ZHS PO 接收接口错误报表 Application: 采购管理系统 Source: 接收接口错误报表 (XML) Short Name: RCVIERR_XML DB package: PO_RCVIERR_XMLP_PKG BI Publisher :p_conc_request_id :p_end_date :p_purge_data :p_start_date 1 10 :p_start_date DateTime AR تاريخ البداية D Startdatum F Date de début US Start Date ZHS 起始日期 2 20 :p_end_date DateTime AR تاريخ النهاية D Enddatum F Date de fin US End Date ZHS 终止日期 3 30 :p_purge_data LOV Oracle AP_SRS_YES_NO_OPT Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description US P_Purge_Data