ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFE63869E053B46B63588994Y SELECT HDR.PAYVEND_ID, HDR.ORGN_CODE PO_ORGN, HDR.PO_DATE, RHDR.ORGN_CODE RC_ORGN, HDR.PO_NO, DTL.LINE_NO, RHDR.RECV_ID, RHDR.RECV_NO, MAP.RCV_RECEIPT_NUM, HDR.CREATION_DATE, RHDR.CREATION_DATE, RHDR.RECV_DATE, VEND.VENDOR_NO,VEND.VENDOR_NAME FROM PO_ORDR_HDR HDR, PO_ORDR_DTL DTL, PO_RECV_HDR RHDR, PO_RECV_DTL RDTL, GML_RECV_TRANS_MAP MAP, PO_VEND_MST VEND WHERE RDTL.PO_ID=HDR.PO_ID AND HDR.PO_ID=DTL.PO_ID AND HDR.PAYVEND_ID = RHDR.PAYVEND_ID AND VEND.VENDOR_ID=HDR.PAYVEND_ID AND VEND.VENDOR_ID= RHDR.PAYVEND_ID AND MAP.RECV_ID=RHDR.RECV_ID AND RDTL.LINE_ID=MAP.LINE_ID AND RDTL.RECV_ID=RHDR.RECV_ID AND RDTL.POLINE_ID=DTL.LINE_ID &PARAM_WHERE_CLAUSE ORDER BY RHDR.RECV_NO, RDTL.LINE_NO GML POAPPSRS_XML AR GML تقرير رقم الإيصال في تطبيقات OPM Application: الإجراءات التنظيمية للتصنيع التشغيلي Source: تقرير رقم الإيصال في تطبيقات OPM (XML) Short Name: POAPPSRS_XML DB package: GML_POAPPSRS_XMLP_PKG D GML Auswertung "Wareneingangsnummern" in OPM Application: Process Manufacturing Logistik Source: Auswertung "Wareneingangsnummern" in OPM (XML) Short Name: POAPPSRS_XML DB package: GML_POAPPSRS_XMLP_PKG F GML Applications OPM - Numéros de réception Application: Process Manufacturing Logistics Source: Applications OPM - Numéros de réception (XML) Short Name: POAPPSRS_XML DB package: GML_POAPPSRS_XMLP_PKG US GML OPM Apps Receipt Number Application: Process Manufacturing Logistics Source: OPM Apps Receipt Number Report (XML) Short Name: POAPPSRS_XML DB package: GML_POAPPSRS_XMLP_PKG ZHS GML OPM 应用产品接收编号报表 Application: OPM 采购管理系统 Source: OPM 应用产品接收编号报表 (XML) Short Name: POAPPSRS_XML DB package: GML_POAPPSRS_XMLP_PKG BI Publisher &param_where_clause :f_po_no_from :f_po_no_to :f_recv_no_from :f_recv_no_to :nonblocksqk :p_char :p_conc_request_id :p_orgn_code :p_po_no_from :p_po_no_to :p_recv_date_from :p_recv_date_to :p_recv_no_from :p_recv_no_to :p_user_id :p_vendor_no_from :p_vendor_no_to :p_whse_code_from :p_whse_code_to :param_where_clause :prn_rows 1 10 :p_orgn_code LOV Oracle ORGN_CODE_CHAR4 Y select orgn_code id, orgn_code value, null description from sy_orgn_mst order by orgn_code select fnd_profile.value('GEMMS_DEFAULT_ORGN') from dual Y AR التنظيم D Organisation F Organisation US Organization ZHS 组织 2 20 :p_recv_no_from LOV Oracle RECEIPTS_RECV_NO Y select recv_id id, recv_no value, null description from po_recv_hdr where orgn_code=:$flex$.orgn_code_char4 order by recv_id AR من رقم الاستلام D Von Wareneingangs-Nr. F Numéro réception - De US From Recv No ZHS 起始接收编号 3 30 :p_recv_no_to LOV Oracle RECEIPTS_RECV_NO Y select recv_id id, recv_no value, null description from po_recv_hdr where orgn_code=:$flex$.orgn_code_char4 order by recv_id AR إلى رقم الاستلام D Bis Wareneingangs-Nr. F Numéro réception - A US To Recv No ZHS 终止接收编号 4 40 :p_recv_date_from Date AR من تاريخ الاستلام D Von Wareneingangsdatum F Date réception - Du US From Recv Date ZHS 起始接收日期 5 50 :p_recv_date_to Date AR إلى تاريخ الاستلام D Bis Wareneingangsdatum F Date réception - Au US To Recv Date ZHS 终止接收日期 6 60 :p_po_no_from LOV Oracle PO_PO_NO Y select po_id id, po_no value, null description from po_ordr_hdr where orgn_code=:$flex$.orgn_code_char4 order by po_id AR من رقم أمر الشراء D Von Bestell-Nr. F Numéro OA - De US From PO No ZHS 起始 PO 编号 7 70 :p_po_no_to LOV Oracle PO_PO_NO Y select po_id id, po_no value, null description from po_ordr_hdr where orgn_code=:$flex$.orgn_code_char4 order by po_id AR إلى رقم أمر الشراء D Bis Bestell-Nr. F Numéro OA - A US To PO No ZHS 终止 PO 编号 8 80 :p_vendor_no_from LOV Oracle VENDORS_BPO Y select vendor_no id, vendor_no value, vendor_name description from po_vend_mst order by vendor_no,vendor_name,vendsort_no,co_code AR من رقم المورد D Von Lieferanten-Nr. F Numéro fournisseur - De US From Vend No ZHS 起始供应商编号 9 90 :p_vendor_no_to LOV Oracle VENDORS_BPO Y select vendor_no id, vendor_no value, vendor_name description from po_vend_mst order by vendor_no,vendor_name,vendsort_no,co_code AR إلى رقم المورد D Bis Lieferanten-Nr. F Numéro fournisseur - A US To Vend No ZHS 终止供应商编号