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
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 |
|
LOV |