SELECT MIL.INVENTORY_LOCATION_ID , MIL.ORGANIZATION_ID , MIL.DESCRIPTION , MIL.DISABLE_DATE , MIL.PICKING_ORDER , MIL.LOCATION_MAXIMUM_UNITS , MIL.SUBINVENTORY_CODE , MIL.LOCATION_WEIGHT_UOM_CODE , MIL.MAX_WEIGHT , MIL.VOLUME_UOM_CODE , MIL.MAX_CUBIC_AREA , MIL.CREATED_BY , MIL.CREATION_DATE , MIL.LAST_UPDATED_BY , MIL.LAST_UPDATE_DATE FROM MTL_ITEM_LOCATIONS MIL WHERE '_SEC:MIL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
SELECT MIL.INVENTORY_LOCATION_ID
, MIL.ORGANIZATION_ID
, MIL.DESCRIPTION
, MIL.DISABLE_DATE
, MIL.PICKING_ORDER
, MIL.LOCATION_MAXIMUM_UNITS
, MIL.SUBINVENTORY_CODE
, MIL.LOCATION_WEIGHT_UOM_CODE
, MIL.MAX_WEIGHT
, MIL.VOLUME_UOM_CODE
, MIL.MAX_CUBIC_AREA
, MIL.CREATED_BY
, MIL.CREATION_DATE
, MIL.LAST_UPDATED_BY
, MIL.LAST_UPDATE_DATE
FROM MTL_ITEM_LOCATIONS MIL
WHERE '_SEC:MIL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
|
|
|