ECC Inventory Management, Inventory On Hand

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