GMI Inventory Edit Journal

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Inventory Edit Journal Report of OPM IC
Application: Process Manufacturing Inventory
Source: Inventory Edit Journal Report (XML)
Short Name: RIEDJL_XML
DB package: GMI_RIEDJL_XMLP_PKG
Run GMI Inventory Edit Journal and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT    b.journal_no,b.journal_comment, a.doc_line,  a.last_updated_by,  a.trans_type,
                   i.item_no,   a.whse_code, a.location,   a.qty,    a.item_um,
                  a.qc_grade,   a.lot_status,  a.reason_code,  decode(l.lot_no,'DEFAULT LOT',' ',l.lot_no)  lot_no,
                  l.sublot_no,  a.qty2,  a.item_um2, 
                  s.orgn_code,  s.orgn_name, 
	GMI_RIEDJL_XMLP_PKG.username_formulaformula(a.last_updated_by) Username_formula
FROM        ic_jrnl_mst b,   ic_adjs_jnl a, 
                  ic_item_mst i,   ic_lots_mst l,  sy_orgn_mst s
WHERE     b.journal_id = a.journal_id 
                  and  a.item_id = i.item_id 
                  and  a.item_id = l.item_id  
                  and  a.lot_id = l.lot_id  
                  and  b.delete_mark = 0
                  and  b.posted_ind = 0
                  and s.orgn_code = :P_orgn
                  and  b.journal_no between 
                  rtrim(nvl(:from_journal,'0'))
                  and  rtrim(nvl(:to_journal,'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz'))
order by      &sortCp
Parameter Name SQL text Validation
Organization 
 
 LOV Oracle
From Journal 
 
 LOV Oracle
To Journal 
 
 LOV Oracle
Sort Order 
 
 LOV Oracle
Download
Related Blitz Reports
GMI Inventory Transfer GML PO/Stock Return History GMI Lot Inventory GMI Inventory Transfer Report By Batch GML Bill Of Lading GMI Daily Item Usage GMI Warehouse Inventory GMI Inventory Location Detail GMI Lot Master
Blitz Report™

Blitz Report™ provides multiple benefits: