[Home] [Help] [Dependency Information]
Object Name: | CSL_MTL_ITEM_LOCATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Mobile view on MTL_ITEM_LOCATIONS
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_LOCATION_ID | NUMBER | Yes | Inventory Location Id | |
ORGANIZATION_ID | NUMBER | Yes | Organization Id | |
CONCATENATED_SEGMENTS | CHAR | (1) | Concatenated Segments | |
PADDED_CONCATENATED_SEGMENTS | CHAR | (1) | Padded Concatenated Segments | |
DESCRIPTION | VARCHAR2 | (50) | Description | |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory Code | |
DISABLE_DATE | DATE | Disable Date | ||
START_DATE_ACTIVE | DATE | Start Date Active | ||
END_DATE_ACTIVE | DATE | End Date Active | ||
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Enabled Flag |
SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Summary Flag |
DESCRIPTIVE_TEXT | VARCHAR2 | (240) | Descriptive Text | |
PROJECT_ID | NUMBER | (15) | Project Id | |
TASK_ID | NUMBER | (15) | Task Id | |
PHYSICAL_LOCATION_ID | NUMBER | (15) | Physical Location Id | |
STATUS_ID | NUMBER | Status Id | ||
LOCATOR_STATUS | NUMBER | Locator Status | ||
LOCATION_CURRENT_UNITS | NUMBER | Location Current Units | ||
LOCATION_AVAILABLE_UNITS | NUMBER | Location Available Units | ||
INVENTORY_ITEM_ID | NUMBER | Inventory Item Id | ||
LOCATION_SUGGESTED_UNITS | NUMBER | Location Suggested Units | ||
ACCESS_ID | NUMBER | Access Id |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_LOCATION_ID
, ORGANIZATION_ID
, CONCATENATED_SEGMENTS
, PADDED_CONCATENATED_SEGMENTS
, DESCRIPTION
, SUBINVENTORY_CODE
, DISABLE_DATE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ENABLED_FLAG
, SUMMARY_FLAG
, DESCRIPTIVE_TEXT
, PROJECT_ID
, TASK_ID
, PHYSICAL_LOCATION_ID
, STATUS_ID
, LOCATOR_STATUS
, LOCATION_CURRENT_UNITS
, LOCATION_AVAILABLE_UNITS
, INVENTORY_ITEM_ID
, LOCATION_SUGGESTED_UNITS
, ACCESS_ID
FROM APPS.CSL_MTL_ITEM_LOCATIONS_V;
APPS.CSL_MTL_ITEM_LOCATIONS_V is not referenced by any database object
|
|
|