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
Run ECC Inventory Management, Inventory Space Utilization and other Oracle EBS reports with Blitz Report™ on our demo environment
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,mil_dfv.* ,mln_dfv.* FROM INV_ECC_SLOTTING_V slot ,(select ROW_ID "'INV_MIL_ROW_ID'",CONTEXT "'INV_MIL_CONTEXT'",FND_ECC_DFF_UTIL.get_vset_values('MTL_ITEM_LOCATIONS','LOCATOR_TYPE',LOCATOR_TYPE, NULL ,NULL,401) "'INV_MIL_LOCATOR_TYPE'",FND_ECC_DFF_UTIL.get_vset_values('MTL_ITEM_LOCATIONS','LOCATOR_ABC_CLASS',LOCATOR_ABC_CLASS, NULL ,NULL,401) "'INV_MIL_LOCATOR_ABC_CLASS'",CONCATENATED_SEGMENTS "'INV_MIL_CONCATENATED_SEGMENTS'",LOCATOR_TYPE "'INV_MIL_LOCATOR_TYPE_EDOC'",LOCATOR_ABC_CLASS "'INV_MIL_LOCATOR_ABC_CLASS_EDOC'" from MTL_ITEM_LOCATIONS_DFV) mil_dfv ,(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 MTL_LOT_NUMBERS_DFV) mln_dfv WHERE LANGUAGE IN ( 'US') and loc_rowid =mil_dfv."'INV_MIL_ROW_ID'"(+) 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
x.organization_code=:organization_code
LOV