ECC Inventory Management, Inventory On Hand

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Description: Inventory On Hand Data Set
Dataset Key: inv-onhand
Query Procedure: INV_ECC_ONHAND_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Inventory Management, Inventory On Hand and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT * FROM (SELECT onhand.*,NVL(onhand.subinventory_code,'NONE') subinventory_code_eam ,
(onhand.INVENTORY_ITEM_ID
  ||'-'
  || onhand.ORGANIZATION_ID
  ||'-'
  ||  NVL(onhand.SUBINVENTORY_CODE,'NONE')) INV_ORG_SUBINV_EAM
                                            FROM INV_ECC_ONHAND_V onhand
                                            where language in ('US'))
  PIVOT (max(ITEM_DESC) as ITEM_DESC, max(OWNING_PARTY) as OWNING_PARTY for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Organization Code 
x.organization_code=:organization_code
 LOV
Download
 
Related Blitz Reports
ECC Inventory Management, Inventory Space Utilization ECC Discrete Manufacturing, Components ECC Inventory Management, Inventory Trace Inbound and On-Hand ECC Inventory Management, Inventory Trace Suppliers ECC Enterprise Asset Management, Stores Materials (Maintenance), SQL1 ECC Inventory Management, Inventory Trace Sales Orders ECC Project Manufacturing, On-Hand Values ECC Project Manufacturing, On-Hand Balance ECC Project Manufacturing Genealogy & Trace, Project Locators
Blitz Report™

Blitz Report™ provides multiple benefits: