GMI Cycle Count Forms

Description
Categories: BI Publisher, Manufacturing
Application: Process Manufacturing Inventory
Source: Cycle Count Forms (XML)
Short Name: PIR05_XML
DB package: GMI_PIR05_XMLP_PKG
SELECT DISTINCT             item_no,item_desc1,lot_no,lot_desc,sublot_no,                            ic_phys_cnt.location,grade_code,item_um,item_um2,count_no,MOD(ic_phys_cnt.count_no,1000) line_no,trunc(count_no/1000) page_no, 
	GMI_PIR05_XMLP_PKG.f_itemum2formula(ic_item_mst.item_um2) f_itemum2,
	GMI_PIR05_XMLP_PKG.p_itemum2label_p p_itemum2label,
	GMI_PIR05_XMLP_PKG.p_itemum2dash_p p_itemum2dash,
	GMI_PIR05_XMLP_PKG.p_csitemum2_label_p p_csitemum2_label,
	GMI_PIR05_XMLP_PKG.p_csitemum2_dash_p p_csitemum2_dash
FROM ic_phys_cnt, ic_item_mst, ic_lots_mst ,ic_cycl_hdr
WHERE   ic_phys_cnt.whse_code =:whse  AND
        ic_phys_cnt.cycle_id = :cycle_id AND
        ic_phys_cnt.count_no >=:from_count AND
        ic_phys_cnt.count_no <= :to_count  AND
        ic_phys_cnt.item_id = ic_item_mst.item_id AND
        ic_phys_cnt.lot_id = ic_lots_mst.lot_id  AND
        ic_phys_cnt.delete_mark = 0 AND
        ic_lots_mst.item_id = ic_item_mst.item_id
ORDER BY &F_ORDER_BY
Parameter Name SQL text Validation
orgn
 
prn_for
 
LOV Oracle
PI_CY_CYCLE_SOURCE
 
Number
Non Block Sql
 
LOV Oracle
Sort By
 
LOV Oracle
To Count
 
LOV Oracle
From Count
 
LOV Oracle
Cycle
 
LOV Oracle
Warehouse Code
 
LOV Oracle