DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.WMS_ITEM_LOCATIONS_KFV

Object Details
Object Name: WMS_ITEM_LOCATIONS_KFV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWMS.WMS_ITEM_LOCATIONS_KFV
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW ID
INVENTORY_LOCATION_ID NUMBER
Yes INVENTORY LOCATION ID
ORGANIZATION_ID NUMBER
Yes ORGANIZATION ID
CONCATENATED_SEGMENTS CHAR (1)
CONCATENATED SEGMENTS
LOCATOR_SEGMENTS CHAR (1)
LOCATOR SEGMENTS
DESCRIPTION VARCHAR2 (50)
DESCRIPTION
DISABLE_DATE DATE

DISABLE DATE
SUBINVENTORY_CODE VARCHAR2 (10)
SUBINVENTORY CODE
Y_COORDINATE NUMBER

Y COORDINATE
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE 10
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE 15
START_DATE_ACTIVE DATE

START DATE ACTIVE
PROGRAM_APPLICATION_ID NUMBER

PROGRAM APPLICATION ID
CREATION_DATE DATE

CREATION DATE
SUMMARY_FLAG VARCHAR2 (1) Yes SUMMARY FLAG
ENABLED_FLAG VARCHAR2 (1) Yes ENABLED FLAG
END_DATE_ACTIVE DATE

END DATE ACTIVE
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE CATEGORY
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE1
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE2
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE3
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE4
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE5
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE6
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE7
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE8
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE9
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE11
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE12
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE13
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE14
PROGRAM_ID NUMBER

PROGRAM ID
PROGRAM_UPDATE_DATE DATE

PROGRAM UPDATE DATE
REQUEST_ID NUMBER

REQUEST ID
PHYSICAL_LOCATION_CODE VARCHAR2 (10)
PHYSICAL LOCATION CODE
MAX_CUBIC_AREA NUMBER

MAX CUBE AREA
LAST_UPDATE_DATE DATE
Yes LAST UPDATE DATE
LAST_UPDATED_BY NUMBER
Yes LAST UPDATED BY
CREATED_BY NUMBER

CREATED BY
LAST_UPDATE_LOGIN NUMBER

LAST UPDATE LOGIN
DESCRIPTIVE_TEXT VARCHAR2 (240)
DESCRITIVE TEXT
INVENTORY_LOCATION_TYPE NUMBER

INVENTORY LOCATION TYPE
PICKING_ORDER NUMBER

PICKING ORDER
LOCATION_MAXIMUM_UNITS NUMBER

LOCATION MAXIMUM UNITS
LOCATION_WEIGHT_UOM_CODE VARCHAR2 (3)
LOCATION WEIGHT UOM CODE
MAX_WEIGHT NUMBER

MAX WEIGHT
VOLUME_UOM_CODE VARCHAR2 (3)
VOL UOM CODE
X_COORDINATE NUMBER

X COORDINATE
Z_COORDINATE NUMBER

Z COORDINATE
INVENTORY_ACCOUNT_ID NUMBER

INVENTORY ACCOUNT ID
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
PICK_UOM_CODE VARCHAR2 (3)
PICK UOM CODE
DIMENSION_UOM_CODE VARCHAR2 (3)
DIMENSION UOM CODE
LENGTH NUMBER

LENGTH
WIDTH NUMBER

WIDTH
HEIGHT NUMBER

HEIGHT
LOCATOR_STATUS NUMBER

LOCATOR STATUS
CURRENT_CUBIC_AREA NUMBER

CURRENT CUBIC AREA
AVAILABLE_CUBIC_AREA NUMBER

AVAILABLE CUBIC AREA
CURRENT_WEIGHT NUMBER

CURRENT WEIGTH
AVAILABLE_WEIGHT NUMBER

AVAILABLE WEIGHT
LOCATION_CURRENT_UNITS NUMBER

LOCATION CURRENT UNITS
LOCATION_AVAILABLE_UNITS NUMBER

LOCATION AVAILABLE UNITS
INVENTORY_ITEM_ID NUMBER

INVENTORY ITEM ID
SUGGESTED_CUBIC_AREA NUMBER

SUGGESTED CUBIC AREA
SUGGESTED_WEIGHT NUMBER

SUGGESTED WEIGHT
LOCATION_SUGGESTED_UNITS NUMBER

LOCATION SUGGESTED UNITS
EMPTY_FLAG VARCHAR2 (1)
EMPTY FLAG
MIXED_ITEMS_FLAG VARCHAR2 (1)
MIXED ITEMS FLAG
DROPPING_ORDER NUMBER

DROPPING ORDER
ALIAS VARCHAR2 (30)
ALIAS
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      INVENTORY_LOCATION_ID
,      ORGANIZATION_ID
,      CONCATENATED_SEGMENTS
,      LOCATOR_SEGMENTS
,      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 APPS.WMS_ITEM_LOCATIONS_KFV;

Dependencies

[top of page]

APPS.WMS_ITEM_LOCATIONS_KFV references the following:

SchemaAPPS
SynonymMTL_ITEM_LOCATIONS
APPS.WMS_ITEM_LOCATIONS_KFV is referenced by following:

SchemaAPPS
Package BodyGME_MOBILE_LOVS - show dependent code
Package BodyGME_MOBILE_RSRV - show dependent code
Package BodyGME_MOBILE_TXN - show dependent code
Package BodyGME_RESERVATIONS_PVT - show dependent code
Package BodyGME_TRANSACTIONS_PVT - show dependent code
Package BodyINV_LABEL_PVT1 - show dependent code
Package BodyINV_LABEL_PVT2 - show dependent code
Package BodyINV_UI_ITEM_SUB_LOC_LOVS - show dependent code
Package BodyWMS_PICK_LOAD_UI - show dependent code