ECC Inventory Management, Inventory On Hand

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Organization Code, Organization Id, Revision, Subinventory Code, Locator Code, Inventory Item Id, Item Code, UOM Code, Inventory Item Status Code ...
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:
select
x.*
from
(
SELECT * FROM (SELECT * FROM INV_ECC_ONHAND_V 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.org_code=:organization_code
LOV