View: MTL_ITEM_LOCATIONS_KFV

Product:	INV - Inventory
Description:	Item Locations Key Flexfield View
Implementation/DBA Data:	APPS.MTL_ITEM_LOCATIONS_KFV

View Text

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

Columns