[Home] [Help] [Dependency Information]

TABLE: WMS.WMS_DEPARTMENT_SUBINVENTORIES

Object Details

Object Name:	WMS_DEPARTMENT_SUBINVENTORIES
Object Type:	TABLE
Owner:	WMS
FND Design Data:	WMS.WMS_DEPARTMENT_SUBINVENTORIES
Subobject Name:
Status:	VALID

This is a cross reference table for departments and subinventories. This is to enable the user to associate subs to departments - i.e a 'PICKING' department could contain all the subs from which an user can pick. A 'STAGING' department can contain all the staging subs. A subinventory can belong to multiple departments. This is not used Equipment and user will be tied to a department and this will be used to determine appropriate resources for pending tasks. This is not currently being utilized, but will be in the future.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WMS_DEPARTMENT_SUBINVENTORI_U1	NORMAL	UNIQUE	APPS_TS_SEED	ORGANIZATION_ID SUBINVENTORY_CODE DEPARTMENT_ID
WMS_DEPARTMENT_SUBINVENTORI_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	EFFECTIVE_FROM_DATE EFFECTIVE_TO_DATE

Columns

Query Text

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

SELECT ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      SUBINVENTORY_ID
,      DEPARTMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      EFFECTIVE_FROM_DATE
,      EFFECTIVE_TO_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM WMS.WMS_DEPARTMENT_SUBINVENTORIES;

Dependencies

[top of page]

WMS.WMS_DEPARTMENT_SUBINVENTORIES does not reference any database object

WMS.WMS_DEPARTMENT_SUBINVENTORIES is referenced by following:

WMS

WMS_DEPARTMENT_SUBINVENTORIES#