VIEW: APPS.MTL_ITEM_LOCATIONS_KFV

Source

View Text - Preformatted

SELECT ROWID ROW_ID , INVENTORY_LOCATION_ID , ORGANIZATION_ID , 'X' CONCATENATED_SEGMENTS , 'X' , DESCRIPTION , DISABLE_DATE , SUBINVENTORY_CODE , Y_COORDINATE , ATTRIBUTE10 , ATTRIBUTE15 , START_DATE_ACTIVE , PROGRAM_APPLICATION_ID , CREATION_DATE , SUMMARY_FLAG , ENABLED_FLAG , END_DATE_ACTIVE , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , PROGRAM_ID , PROGRAM_UPDATE_DATE , REQUEST_ID , PHYSICAL_LOCATION_CODE , MAX_CUBIC_AREA , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATED_BY , LAST_UPDATE_LOGIN , DESCRIPTIVE_TEXT , INVENTORY_LOCATION_TYPE , PICKING_ORDER , LOCATION_MAXIMUM_UNITS , LOCATION_WEIGHT_UOM_CODE , MAX_WEIGHT , VOLUME_UOM_CODE , X_COORDINATE , Z_COORDINATE , INVENTORY_ACCOUNT_ID , PROJECT_ID , TASK_ID , PHYSICAL_LOCATION_ID , STATUS_ID , PICK_UOM_CODE , DIMENSION_UOM_CODE , LENGTH , WIDTH , HEIGHT , LOCATOR_STATUS , CURRENT_CUBIC_AREA , AVAILABLE_CUBIC_AREA , CURRENT_WEIGHT , AVAILABLE_WEIGHT , LOCATION_CURRENT_UNITS , LOCATION_AVAILABLE_UNITS , INVENTORY_ITEM_ID , SUGGESTED_CUBIC_AREA , SUGGESTED_WEIGHT , LOCATION_SUGGESTED_UNITS , EMPTY_FLAG , MIXED_ITEMS_FLAG , DROPPING_ORDER , ALIAS FROM MTL_ITEM_LOCATIONS

View Text - HTML Formatted

SELECT ROWID ROW_ID
, INVENTORY_LOCATION_ID
, ORGANIZATION_ID
, 'X' CONCATENATED_SEGMENTS
, 'X'
, DESCRIPTION
, DISABLE_DATE
, SUBINVENTORY_CODE
, Y_COORDINATE
, ATTRIBUTE10
, ATTRIBUTE15
, START_DATE_ACTIVE
, PROGRAM_APPLICATION_ID
, CREATION_DATE
, SUMMARY_FLAG
, ENABLED_FLAG
, END_DATE_ACTIVE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, PHYSICAL_LOCATION_CODE
, MAX_CUBIC_AREA
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, DESCRIPTIVE_TEXT
, INVENTORY_LOCATION_TYPE
, PICKING_ORDER
, LOCATION_MAXIMUM_UNITS
, LOCATION_WEIGHT_UOM_CODE
, MAX_WEIGHT
, VOLUME_UOM_CODE
, X_COORDINATE
, Z_COORDINATE
, INVENTORY_ACCOUNT_ID
, PROJECT_ID
, TASK_ID
, PHYSICAL_LOCATION_ID
, STATUS_ID
, PICK_UOM_CODE
, DIMENSION_UOM_CODE
, LENGTH
, WIDTH
, HEIGHT
, LOCATOR_STATUS
, CURRENT_CUBIC_AREA
, AVAILABLE_CUBIC_AREA
, CURRENT_WEIGHT
, AVAILABLE_WEIGHT
, LOCATION_CURRENT_UNITS
, LOCATION_AVAILABLE_UNITS
, INVENTORY_ITEM_ID
, SUGGESTED_CUBIC_AREA
, SUGGESTED_WEIGHT
, LOCATION_SUGGESTED_UNITS
, EMPTY_FLAG
, MIXED_ITEMS_FLAG
, DROPPING_ORDER
, ALIAS
FROM MTL_ITEM_LOCATIONS