[Home] [Help] [Dependency Information]
Object Name: | CSM_MTL_ITEM_LOCATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCESS_ID | NUMBER | |||
INVENTORY_LOCATION_ID | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | Yes | ||
LOCATOR_NAME | CHAR | (1) | ||
LOCATOR_DESCRIPTION | VARCHAR2 | (50) | ||
SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
DISABLE_DATE | DATE | |||
START_DATE_ACTIVE | DATE | |||
END_DATE_ACTIVE | DATE | |||
ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
SUMMARY_FLAG | VARCHAR2 | (1) | Yes | |
STATUS_ID | NUMBER | |||
LOCATOR_STATUS | NUMBER | |||
PADDED_CONCATENATED_SEGMENTS | CHAR | (1) | ||
DESCRIPTIVE_TEXT | VARCHAR2 | (240) | ||
PROJECT_ID | NUMBER | (15) | ||
TASK_ID | NUMBER | (15) | ||
PHYSICAL_LOCATION_ID | NUMBER | (15) | ||
LOCATION_CURRENT_UNITS | NUMBER | |||
LOCATION_AVAILABLE_UNITS | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
LOCATION_SUGGESTED_UNITS | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_ID
, INVENTORY_LOCATION_ID
, ORGANIZATION_ID
, LOCATOR_NAME
, LOCATOR_DESCRIPTION
, SUBINVENTORY_CODE
, DISABLE_DATE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ENABLED_FLAG
, SUMMARY_FLAG
, STATUS_ID
, LOCATOR_STATUS
, PADDED_CONCATENATED_SEGMENTS
, DESCRIPTIVE_TEXT
, PROJECT_ID
, TASK_ID
, PHYSICAL_LOCATION_ID
, LOCATION_CURRENT_UNITS
, LOCATION_AVAILABLE_UNITS
, INVENTORY_ITEM_ID
, LOCATION_SUGGESTED_UNITS
FROM APPS.CSM_MTL_ITEM_LOCATIONS_V;
APPS.CSM_MTL_ITEM_LOCATIONS_V is not referenced by any database object
|
|
|