GMI Cycle Count Forms

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Imported Oracle standard Cycle Count Forms Report of Oracle OPM PI report
Source: Cycle Count Forms (XML)
Short Name: PIR05_XML
DB package: GMI_PIR05_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select distinct
ipc.whse_code warehouse,
iwm.whse_name warehouse_description,
ich.cycle_no,
ich.cycle_desc,
item_no item_number,
item_desc1 item_description,
ilm.lot_no lot,
ilm.lot_desc lot_description,
ilm.sublot_no sublot,
ipc.location,
ipc.grade_code,
iimv.item_um item_uom,
iimv.item_um2 item_uom2,
ipc.count_no,
mod(ipc.count_no,1000) line_no,
trunc(ipc.count_no/1000) page_no,
ich.print_format
from
ic_whse_mst iwm,
ic_phys_cnt ipc,
ic_cycl_hdr ich,
ic_item_mst_vl iimv,
ic_lots_mst ilm
where
1=1 and
iwm.whse_code=ipc.whse_code and
ipc.delete_mark=0 and
ipc.cycle_id=ich.cycle_id and
ipc.item_id=iimv.item_id and
ipc.item_id=ilm.item_id and
ipc.lot_id=ilm.lot_id
order by 
count_no
Parameter Name SQL text Validation
Warehouse Code 
ipc.whse_code=:p_warehouse
 LOV
Cycle 
ich.cycle_no=:p_cycle_no
 LOV
From Count 
ipc.count_no>=:p_from_count
 LOV
To Count 
ipc.count_no<=:p_to_count
 LOV
Sort By 
 
 LOV Oracle
Download
   
Related Blitz Reports
GML PO/Stock Return History GMI Inventory Transfer GMI Inventory Edit Journal GML Unallocated Orders Report (OPM - OM) GML Items Received GML Sales Order Audit Trail GML Unallocated Orders GMI Lot Inventory GMI Inventory Transfer Report By Batch
Blitz Report™

Blitz Report™ provides multiple benefits: