ECC Inventory Management, Inventory Space Utilization
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: inv-space
Query Procedure: INV_ECC_SLOTTING_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Dataset Key: inv-space
Query Procedure: INV_ECC_SLOTTING_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
select x.* from ( SELECT * FROM (SELECT SLOT.ECC_SPEC_ID, SLOT.SKU_ITEM_COMBINATION, SLOT.ORGANIZATION_CODE, SLOT.ORGANIZATION_ID, SLOT.COMPILE_NAME, SLOT.INVENTORY_ITEM_ID, SLOT.ITEM_NAME, SLOT.ITEM_DESCRIPTION, SLOT.SUBINVENTORY_CODE, SLOT.LOCATOR_CODE, SLOT.ITEM_CLASS, SLOT.CLASS_SEQ_NUMBER, SLOT.ITEM_SEQ_NUMBER, SLOT.ITEM_VELOCITY, SLOT.COMPILE_VALUE, SLOT.TOTAL_VELOCITY, SLOT.CLASS_CUMULATIVE_QTY, SLOT.LOCATION_AVAILABLE_UNITS, SLOT.LOCATION_MAXIMUM_UNITS, SLOT.LOCATOR_CLASS, SLOT.AVAILABLE_CAPACITY, SLOT.RESLOT, INV_ECC_SLOTTING_UTIL_PVT.get_slot_value(SLOT.RESLOT,SLOT.LANGUAGE ) RESLOT_DESC, SLOT.ONHAND_QTY, SLOT.ONHAND_QTY_PRIMARY, SLOT.PRODUCT_CATEGORY, SLOT.ZONE_NAME, SLOT.EMPTY_FLAG, INV_ECC_SLOTTING_UTIL_PVT.get_slot_value(SLOT.EMPTY_FLAG,SLOT.LANGUAGE ) EMPTY_FLAG_DESC, SLOT.LAST_UPDATE_DATE, SLOT.LANGUAGE, SLOT.LPN_NUMBER, SLOT.COST_GROUP, SLOT.OLDEST_RECEIPT_DATE, SLOT.LOT_NUMBER, SLOT.REVISION, SLOT.LOCATOR_ID, SLOT.ONHAND_STATUS, SLOT.SUBINVENTORY_STATUS, SLOT.LOCATOR_STATUS, SLOT.LOT_STATUS, SLOT.EXPIRATION_DATE, SLOT.LOC_ROWID, SLOT.LOT_ROWID, DECODE (SLOT.INVENTORY_ITEM_ID, NULL ,'N','Y' ) RELEASE_LEVEL ,mln_dfv.* FROM INV_ECC_SLOTTING_V slot ,(select "ROW_ID" "'INV_MLN_ROW_ID'","CONTEXT_VALUE" "'INV_MLN_CONTEXT_VALUE'","SOURCE" "'INV_MLN_SOURCE'","PACKAGING" "'INV_MLN_PACKAGING'","SHIPPING_MODE" "'INV_MLN_SHIPPING_MODE'","CONCATENATED_SEGMENTS" "'INV_MLN_CONCATENATED_SEGMENTS'" from ( select ROWID "ROW_ID",ATTRIBUTE_CATEGORY "CONTEXT_VALUE",ATTRIBUTE1 "SOURCE",(DECODE(ATTRIBUTE_CATEGORY,'Shipping Data',ATTRIBUTE11,NULL)) "PACKAGING",(DECODE(ATTRIBUTE_CATEGORY,'Shipping Data',ATTRIBUTE12,NULL)) "SHIPPING_MODE",ATTRIBUTE1||'.'||(DECODE(ATTRIBUTE_CATEGORY,'Shipping Data',ATTRIBUTE_CATEGORY||'.'||ATTRIBUTE11||'.'||ATTRIBUTE12,NULL)) "CONCATENATED_SEGMENTS" from MTL_LOT_NUMBERS )) mln_dfv WHERE LANGUAGE IN ( 'US') and lot_rowid =mln_dfv."'INV_MLN_ROW_ID'"(+) )PIVOT (MAX(ITEM_DESCRIPTION) AS ITEM_DESCRIPTION for LANGUAGE in ( 'US' "US")) ) x where 2=2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Organization Code |
|
LOV |