ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFE83869E053B46B63588994Y SELECT rd.to_whse, im.item_no, pd.item_desc, rh.recv_no, rh.orgn_code, rd.recv_date, vn.vendor_name, sum(tp.trans_qty) trans_qty, rd.recv_um1, ph.po_no, tp.lot_id, tp.trans_um, LTRIM(RTRIM(tp.lot_status)) LOT_STATUS1 , tp.doc_id, tp.doc_type, tp.line_id, rd.item_id, LTRIM(RTRIM(GML_PORIRUSR_XMLP_PKG.lot_noformula(rd.item_id, tp.lot_id))) LOT_NO1, LTRIM(RTRIM(GML_PORIRUSR_XMLP_PKG.sublot_noformula(rd.item_id, tp.lot_id))) SUBLOT_NO1 FROM ic_item_mst im, po_recv_hdr rh, po_recv_dtl rd, po_vend_mst vn, po_ordr_hdr ph, po_ordr_dtl pd, ic_tran_pnd tp WHERE im.item_id = rd.item_id and rh.recv_id = rd.recv_id and rh.delete_mark = 0 and vn.vendor_id = rd.shipvend_id and tp.doc_type = 'RECV' and tp.doc_id = rh.recv_id and tp.line_id = rd.line_id &PARAM_WHERE_CLAUSE and ph.po_id(+) = rd.po_id and pd.line_id(+) = rd.poline_id GROUP BY rd.to_whse, im.item_no, pd.item_desc, rh.recv_no, rh.orgn_code, rd.recv_date, vn.vendor_name, rd.recv_um1, ph.po_no, tp.lot_id, tp.trans_um, tp.lot_status, tp.doc_id, tp.doc_type, tp.line_id, rd.item_id, decode(:p_sort_by,'2',ph.po_no,'3',vn.vendor_name,'1',im.item_no), decode(:p_sort_by,'3',ph.po_no,'2',rd.line_no), decode(:p_sort_by,'3',rd.line_no) HAVING sum(tp.trans_qty) > 0 ORDER BY rd.to_whse, decode(:p_sort_by,'2',ph.po_no,'3',vn.vendor_name,'1',im.item_no), decode(:p_sort_by,'3',ph.po_no,'2',rd.line_no), decode(:p_sort_by,'3',rd.line_no) GML PORIRUSR_XML AR GML تقرير الأصناف المستلمة Application: الإجراءات التنظيمية للتصنيع التشغيلي Source: تقرير الأصناف المستلمة (XML) Short Name: PORIRUSR_XML DB package: GML_PORIRUSR_XMLP_PKG D GML Wareneingänge Application: Process Manufacturing Logistik Source: Wareneingänge (XML) Short Name: PORIRUSR_XML DB package: GML_PORIRUSR_XMLP_PKG F GML Articles reçus Application: Process Manufacturing Logistics Source: Articles reçus (XML) Short Name: PORIRUSR_XML DB package: GML_PORIRUSR_XMLP_PKG US GML Items Received Application: Process Manufacturing Logistics Source: Items Received Report (XML) Short Name: PORIRUSR_XML DB package: GML_PORIRUSR_XMLP_PKG ZHS GML 接收项目报表 Application: OPM 采购管理系统 Source: 接收项目报表 (XML) Short Name: PORIRUSR_XML DB package: GML_PORIRUSR_XMLP_PKG BI Publisher &param_where_clause :cp_recv_date_from :cp_recv_date_to :cp_rows :ftr_flag :nonblocksql :p_conc_request_id :p_item_no_from :p_item_no_to :p_recv_date_from :p_recv_date_to :p_sort_by :p_to_whse_from :p_to_whse_to :param_where_clause :prn_rows 1 10 :p_to_whse_from LOV Oracle WHSES_RECVD Y Y select whse_code id, whse_code value, whse_name description from ic_whse_mst order by whse_code AR من المستودع D Von Lager F Entrepôt de départ US From Warehouse ZHS 起始仓库 2 20 :p_to_whse_to LOV Oracle WHSES_RECVD Y Y select whse_code id, whse_code value, whse_name description from ic_whse_mst order by whse_code :$FLEX$.From Warehouse AR إلى مستودع D Bis Lager F Entrepôt d'arrivée US To Warehouse ZHS 终止仓库 3 30 :p_recv_date_from Date AR من تاريخ الاستلام D Von Wareneingangsdatum F Date réception - Du US From Recv date ZHS 起始接收日期 4 40 :p_recv_date_to Date :$FLEX$.From_Recv_date.VALUE AR إلى تاريخ الاستلام D Bis Wareneingangsdatum F Date réception - Au US To Recv date ZHS 终止接收日期 5 50 :p_item_no_from LOV Oracle ITEM_LIST Y select item_no id, item_no value, item_desc1 description from ic_item_mst order by item_no AR من صنف D Von Artikel F Article - De US From Item ZHS 起始物料 6 60 :p_item_no_to LOV Oracle ITEM_LIST Y select item_no id, item_no value, item_desc1 description from ic_item_mst order by item_no :$FLEX$.From Item AR إلى الصنف D Bis Artikel F Article - A US To Item ZHS 终止物料 7 70 :p_sort_by LOV Oracle SORT_OPTION1_GEMMSPO Y select lookup_code id, lookup_code value, meaning description from gem_lookups where lookup_type='SORT_OPTIONS1_GEMMSPO'order by lookup_code order by value,description Y AR فرز بواسطة D Sortieren nach F Tri par US Sort By ZHS 排序依据