GMI Inventory Transfer

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Inventory Transfer Report
Application: Process Manufacturing Inventory
Source: Inventory Transfer Report (XML)
Short Name: CMXFER01_XML
DB package: GMI_CMXFER01_XMLP_PKG 
select xf.transfer_status ST,
        ge.meaning Status,
       xf.from_warehouse x,
       wh.whse_name From_Whse,
       xf.from_location From_Location,
       ic.item_no Item,
       lt.lot_no Lot,
       lt.sublot_no Sublot,
       xf.to_warehouse x1,
       wh1.whse_name To_Whse,
       xf.release_quantity1 Release_Quantity,
       xf.release_uom1 UOM,
       to_char(decode(xf.transfer_status,1,xf.last_update_date,xf.actual_release_date),'mm/dd/yyyy HH:MI AM') date1,
      to_char(decode(xf.transfer_status,1,xf.scheduled_release_date,
                                                   2,xf.scheduled_receive_date,
                                                   5, xf.cancel_date,
                                                   3, xf.actual_receive_date,
                                                       xf.scheduled_release_date),'mm/dd/yyyy HH:MI AM') date2,                                                 
       xf.orgn_code Orgn_Code,
       xf.transfer_no Transfer_No
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 whse_code from ic_whse_mst a, sy_orgn_usr b
                                          where a.orgn_code=b.orgn_code and
                                          b.user_id=:user_id and
                                          a.delete_mark=0)
and xf.to_warehouse in (select whse_code from ic_whse_mst a, sy_orgn_usr b
                                      where a.orgn_code=b.orgn_code and
                                       b.user_id=:user_id and
                                       a.delete_mark=0)                    
&ReleaseDateCF
&SourceWareHouseCF
&DestinationWarehouseCF
&TreansferStatusCF
&ScheduledShipDateCF
&CancelDateCF
&ActualReceiveDateCF
order by     xf.transfer_status ,
	 xf.from_warehouse,
	 xf.from_location,
	 ic.item_no,
	 lt.lot_no,
	 lt.sublot_no,
	 xf.to_warehouse
Parameter Name SQL text Validation
From Actual Release Date 
 
 Date
To Actual Release Date 
 
 Date
From Scheduled Release Date 
 
 Date
To Scheduled Release Date 
 
 Date
From Actual Receive Date 
 
 Date
To Actual Receive Date 
 
 Date
From Cancel Date 
 
 Date
To Cancel Date 
 
 Date
From Source Warehouse 
 
 LOV Oracle
To Source Warehouse 
 
 LOV Oracle
From Destination Warehouse 
 
 LOV Oracle
To Destination Warehouse 
 
 LOV Oracle
From Transfer Status 
 
 LOV Oracle
To Transfer Status 
 
 LOV Oracle
Download
Related Blitz Reports
GMI Inventory Transfer Report By Batch GMI Lot Inventory GMI Inventory Edit Journal GML PO/Stock Return History GMI Inventory Location Detail GMI Warehouse Inventory GMI Daily Item Usage GML Bill Of Lading GMI Cycle Count Forms
Blitz Report™

Blitz Report™ provides multiple benefits: