Single Record View for MTL_ITEM_LOCATIONS

Table Name: MTL_ITEM_LOCATIONS
select * from MTL_ITEM_LOCATIONS order by creation_date desc

Single Record View
As of: dd/mm/yyy hh:mm:ss

INVENTORY_LOCATION_ID:     2957
ORGANIZATION_ID:           5804
LAST_UPDATE_DATE:          05/01/2006 15:11:01
LAST_UPDATED_BY:           1007262
CREATION_DATE:            
CREATED_BY:               
LAST_UPDATE_LOGIN:        
DESCRIPTION:              
DESCRIPTIVE_TEXT:         
DISABLE_DATE:             
INVENTORY_LOCATION_TYPE:   3
PICKING_ORDER:            
PHYSICAL_LOCATION_CODE:   
LOCATION_MAXIMUM_UNITS:   
SUBINVENTORY_CODE:         STORES
LOCATION_WEIGHT_UOM_CODE: 
MAX_WEIGHT:               
VOLUME_UOM_CODE:          
MAX_CUBIC_AREA:           
X_COORDINATE:             
Y_COORDINATE:             
Z_COORDINATE:             
INVENTORY_ACCOUNT_ID:     
SEGMENT1:                  1
SEGMENT2:                  1
SEGMENT3:                  1
SEGMENT4:                 
SEGMENT5:                 
SEGMENT6:                 
SEGMENT7:                 
SEGMENT8:                 
SEGMENT9:                 
SEGMENT10:                
SEGMENT11:                
SEGMENT12:                
SEGMENT13:                
SEGMENT14:                
SEGMENT15:                
SEGMENT16:                
SEGMENT17:                
SEGMENT18:                
SEGMENT19:                 4353
SEGMENT20:                 56051
SUMMARY_FLAG:              N
ENABLED_FLAG:              Y
START_DATE_ACTIVE:        
END_DATE_ACTIVE:          
ATTRIBUTE_CATEGORY:       
ATTRIBUTE1:               
ATTRIBUTE2:               
ATTRIBUTE3:               
ATTRIBUTE4:               
ATTRIBUTE5:               
ATTRIBUTE6:               
ATTRIBUTE7:               
ATTRIBUTE8:               
ATTRIBUTE9:               
ATTRIBUTE10:              
ATTRIBUTE11:              
ATTRIBUTE12:              
ATTRIBUTE13:              
ATTRIBUTE14:              
ATTRIBUTE15:              
REQUEST_ID:               
PROGRAM_APPLICATION_ID:   
PROGRAM_ID:               
PROGRAM_UPDATE_DATE:      
PROJECT_ID:                4353
TASK_ID:                   56051
PHYSICAL_LOCATION_ID:      2526
PICK_UOM_CODE:            
DIMENSION_UOM_CODE:       
LENGTH:                   
WIDTH:                    
HEIGHT:                   
LOCATOR_STATUS:           
STATUS_ID:                 1
CURRENT_CUBIC_AREA:       
AVAILABLE_CUBIC_AREA:     
CURRENT_WEIGHT:           
AVAILABLE_WEIGHT:         
LOCATION_CURRENT_UNITS:    0
LOCATION_AVAILABLE_UNITS: 
INVENTORY_ITEM_ID:        
SUGGESTED_CUBIC_AREA:     
SUGGESTED_WEIGHT:         
LOCATION_SUGGESTED_UNITS: 
EMPTY_FLAG:                Y
MIXED_ITEMS_FLAG:          N
DROPPING_ORDER:           
AVAILABILITY_TYPE:        
INVENTORY_ATP_CODE:       
RESERVABLE_TYPE:          
ALIAS: