ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EFD43869E053B46B63588994Y select xf.transfer_status Stat, xf.transfer_batch batch, ge.meaning Status, xf.from_warehouse||decode(xf.from_location,null,' ' , '/'||xf.from_location) from_ware_loc, ic.item_no||decode(lt.lot_no,null,' ','/'||lt.lot_no)||decode( lt.sublot_no,null,' ','/'||lt.sublot_no) item_lot_sub, xf.to_warehouse||decode(xf.to_location,null,' ','/'||xf.to_location) To_ware_loc, xf.release_quantity1||' '||xf.release_uom1 Release_qty, decode(xf.transfer_status,1,to_char(xf.scheduled_release_date,'MM/DD/RR HH24:MI'),2,to_char(xf.actual_release_date,'MM/DD/RR HH24:MI'), 3,to_char(xf.actual_release_Date,'MM/DD/RR HH24:MI'),4,to_char(xf.scheduled_release_Date,'MM/DD/RR HH24:MI'), 5,to_char(xf.actual_release_date,'MM/DD/RR HH24:MI'),null) actual_rel_date, decode(xf.transfer_status,1,to_char(xf.scheduled_receive_date,'MM/DD/RR HH24:MI'),2,to_char(xf.scheduled_receive_Date,'MM/DD/RR HH24:MI'), 3,to_char(xf.actual_receive_date,'MM/DD/RR HH24:MI'),4,to_char(xf.scheduled_receive_Date,'MM/DD/RR HH24:MI'),5,to_char(xf.cancel_Date,'MM/DD/RR HH24:MI'),null) receive_cancel_date, xf.orgn_code||' '||xf.transfer_no Transfer_No, GMI_CMXFER02_XMLP_PKG.release_cfformula(xf.transfer_status) RELEASE_CF, GMI_CMXFER02_XMLP_PKG.receive_cfformula(xf.transfer_status) RECEIVE_CF from ic_xfer_mst xf, ic_whse_mst wh, ic_whse_mst wh1, ic_item_mst ic, ic_lots_mst lt, gem_lookups ge where xf.item_id=ic.item_id and xf.from_warehouse=wh.whse_code and xf.to_warehouse=wh1.whse_code and xf.lot_id=lt.lot_id and xf.item_id=lt.item_id and xf.transfer_status=ge.lookup_code and ge.lookup_type='TRANSFER_STATUS' and (xf.from_warehouse IN (SELECT w.whse_code FROM ic_whse_mst w, sy_orgn_usr u WHERE w.orgn_code = u.orgn_code AND u.user_id = :v_user_id AND w.delete_mark = 0) OR xf.to_warehouse IN (SELECT w.whse_code FROM ic_whse_mst w, sy_orgn_usr u WHERE w.orgn_code = u.orgn_code AND u.user_id =:v_user_id AND w.delete_mark = 0) OR xf.orgn_code IN (SELECT orgn_code FROM sy_orgn_usr WHERE user_id = :v_user_id)) &ReleaseDateCP &SourceWareHouseCP &DestinationWarehouseCP &TransferStatusCP &ScheduledShipDateCP &CancelDateCP &ActualReceiveDateCP &BatchNoCP order by xf.transfer_batch,3, xf.transfer_status, wh1.orgn_code, xf.transfer_no, xf.from_warehouse, xf.from_location, ic.item_no, lt.lot_no, lt.sublot_no, xf.to_warehouse GMI CMXFER02_XML AR GMI تقرير تحويل المخزون حسب المجموعة (بتنسيق XML) Application: مخازن التصنيع التشغيلي Source: تقرير تحويل المخزون حسب المجموعة (بتنسيق XML) Short Name: CMXFER02_XML DB package: GMI_CMXFER02_XMLP_PKG D GMI Lagertransfers - nach Stapeln Application: Process Manufacturing Materialwirtschaft Source: Lagertransfers - nach Stapeln (XML) Short Name: CMXFER02_XML DB package: GMI_CMXFER02_XMLP_PKG F GMI Transfert entre les entrepôts par batch Application: Process Manufacturing Inventory Source: Transfert entre les entrepôts par batch (XML) Short Name: CMXFER02_XML DB package: GMI_CMXFER02_XMLP_PKG US GMI Inventory Transfer Report By Batch Application: Process Manufacturing Inventory Source: Inventory Transfer Report By Batch (XML) Short Name: CMXFER02_XML DB package: GMI_CMXFER02_XMLP_PKG ZHS GMI 按批列出的库存转移报表 Application: OPM 库存管理系统 Source: 按批列出的库存转移报表 (XML) Short Name: CMXFER02_XML DB package: GMI_CMXFER02_XMLP_PKG BI Publisher &actualreceivedatecp &batchnocp &canceldatecp &destinationwarehousecp &releasedatecp &scheduledshipdatecp &sourcewarehousecp &transferstatuscp :actualreceivedatecp :batchnocp :canceldatecp :cp_from_destination_warehouse :cp_from_source_warehouse :cp_from_transfer_status :cp_to_destination_warehouse :cp_to_source_warehouse :cp_to_transfer_status :destinationwarehousecp :lv_report_title :p_conc_request_id :p_from_actual_receive_date :p_from_batch_num :p_from_cancel_date :p_from_destination_warehouse :p_from_release_date :p_from_scheduled_release_date :p_from_source_warehouse :p_from_transfer_status :p_to_actual_receive_date :p_to_batch_num :p_to_cancel_date :p_to_destination_warehouse :p_to_release_date :p_to_scheduled_release_date :p_to_source_warehouse :p_to_transfer_status :releasedatecp :scheduledshipdatecp :sourcewarehousecp :transferstatuscp :v_report_number :v_report_title :v_set_of_books_name :v_subtitle :v_user_id 1 10 :p_from_batch_num LOV Oracle GMI_TRANSFER_BATCH Y select x.transfer_batch id, x.transfer_batch value, rpad(x.orgn_code,6) || x.from_warehouse description from ic_xfer_mst x where x.transfer_id=(select max(y.transfer_id) from ic_xfer_mst y where y.transfer_batch=x.transfer_batch and y.orgn_code=x.orgn_code and y.from_warehouse=y.from_warehouse) and (from_warehouse in (select w.whse_code from ic_whse_mst w,sy_orgn_usr u where w.orgn_code=u.orgn_code and u.user_id=fnd_global.user_id and w.delete_mark=0) or to_warehouse in (select w.whse_code from ic_whse_mst w,sy_orgn_usr u where w.orgn_code=u.orgn_code and u.user_id=fnd_global.user_id and w.delete_mark=0) or orgn_code in (select orgn_code from sy_orgn_usr where user_id=fnd_global.user_id) ) order by x.transfer_batch AR من مجموعة التحويل D Von Transferstapel F Batch de transfert - De US From Transfer Batch ZHS 起始转移批 2 20 :p_to_batch_num LOV Oracle GMI_TRANSFER_BATCH Y select x.transfer_batch id, x.transfer_batch value, rpad(x.orgn_code,6) || x.from_warehouse description from ic_xfer_mst x where x.transfer_id=(select max(y.transfer_id) from ic_xfer_mst y where y.transfer_batch=x.transfer_batch and y.orgn_code=x.orgn_code and y.from_warehouse=y.from_warehouse) and (from_warehouse in (select w.whse_code from ic_whse_mst w,sy_orgn_usr u where w.orgn_code=u.orgn_code and u.user_id=fnd_global.user_id and w.delete_mark=0) or to_warehouse in (select w.whse_code from ic_whse_mst w,sy_orgn_usr u where w.orgn_code=u.orgn_code and u.user_id=fnd_global.user_id and w.delete_mark=0) or orgn_code in (select orgn_code from sy_orgn_usr where user_id=fnd_global.user_id) ) order by x.transfer_batch AR إلى مجموعة التحويل D Bis Transferstapel F Batch de transfert - A US To Transfer Batch ZHS 终止转移批 3 30 :p_from_release_date Date AR من تاريخ الإصدار الفعلي D Von Tatsächliches Abrufdatum F Date réelle de l'appel - Du US From Actual Release Date ZHS 实际的发放起始日期 4 40 :p_to_release_date Date AR إلى تاريخ الإصدار الفعلي D Bis Tatsächliches Abrufdatum F Date réelle de l'appel - Au US To Actual Release Date ZHS 实际的发放终止日期 5 50 :p_from_scheduled_release_date Date AR من تاريخ الإصدار المجدول D Von Geplantes Abrufdatum F Date programmée de l'appel - Du US From Scheduled Release Date ZHS 计划的发放起始日期 6 60 :p_to_scheduled_release_date Date AR إلى تاريخ الإصدار المجدول D Bis Geplantes Abrufdatum F Date programmée de l'appel - Au US To Scheduled Release Date ZHS 计划的发放终止日期 7 70 :p_from_cancel_date Date AR من تاريخ الإلغاء D Von Stornodatum F Date d'annulation - Du US From Cancel Date ZHS 起始取消日期 8 80 :p_to_cancel_date Date AR إلى تاريخ الإلغاء D Bis Stornodatum F Date d'annulation - Au US To Cancel Date ZHS 终止取消日期 9 90 :p_from_actual_receive_date Date AR من تاريخ الاستلام الفعلي D Von Tatsächliches WE-Datum F Date réelle de réception - Du US From Actual Receive Date ZHS 实际的接收起始日期 10 100 :p_to_actual_receive_date Date AR إلى تاريخ الاستلام الفعلي D Bis Tatsächliches WE-Datum F Date réelle de réception - Au US To Actual Receive Date ZHS 实际的接收终止日期 11 110 :p_from_source_warehouse LOV Oracle opm_user_whses Y select a.whse_code id, a.whse_code value, a.whse_name description from ic_whse_mst a,sy_orgn_usr b where a.orgn_code=b.orgn_code and b.user_id=fnd_global.user_id and a.delete_mark=0 order by value,description AR من مستودع المصدر D Von Bezugslager F Entrepôt d'origine - De US From Source Warehouse ZHS 起始来源仓库 12 120 :p_to_source_warehouse LOV Oracle opm_user_whses Y select a.whse_code id, a.whse_code value, a.whse_name description from ic_whse_mst a,sy_orgn_usr b where a.orgn_code=b.orgn_code and b.user_id=fnd_global.user_id and a.delete_mark=0 order by value,description AR إلى مستودع المصدر D Bis Bezugslager F Entrepôt d'origine - A US To Source Warehouse ZHS 终止来源仓库 13 130 :p_from_destination_warehouse LOV Oracle opm_user_whses Y select a.whse_code id, a.whse_code value, a.whse_name description from ic_whse_mst a,sy_orgn_usr b where a.orgn_code=b.orgn_code and b.user_id=fnd_global.user_id and a.delete_mark=0 order by value,description AR من مستودع الوجهة D Von Bestimmungslager F Entrepôt de destination - De US From Destination Warehouse ZHS 起始目标仓库 14 140 :p_to_destination_warehouse LOV Oracle opm_user_whses Y select a.whse_code id, a.whse_code value, a.whse_name description from ic_whse_mst a,sy_orgn_usr b where a.orgn_code=b.orgn_code and b.user_id=fnd_global.user_id and a.delete_mark=0 order by value,description AR إلى مستودع الوجهة D Bis Bestimmungslager F Entrepôt de destination - A US To Destination Warehouse ZHS 终止目标仓库 15 150 :p_from_transfer_status LOV Oracle GMI_INV_TRANSFER_STATUS Y select lookup_code id, lookup_code value, meaning description from gem_lookup_values where lookup_type='TRANSFER_STATUS' order by value,description AR من موقف التحويل D Von Transferstatus F Statut du transfert - De US From Transfer Status ZHS 起始转移状态 16 160 :p_to_transfer_status LOV Oracle GMI_INV_TRANSFER_STATUS Y select lookup_code id, lookup_code value, meaning description from gem_lookup_values where lookup_type='TRANSFER_STATUS' order by value,description AR إلى موقف التحويل D Bis Transferstatus F Statut du transfert - A US To Transfer Status ZHS 终止转移状态