ECC Inventory Management, Inventory Space Utilization

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Sku Item Combination, Organization Code, Organization Id, Compile Name, Inventory Item Id, Item Name, Subinventory Code, Locator Code, Item Class ...
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
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