[Home] [Help] [Dependency Information]
Object Name: | EDW_OPI_LOT_M |
---|---|
Object Type: | TABLE |
Owner: | OPI |
FND Design Data: | OPI.EDW_OPI_LOT_M |
Subobject Name: | |
Status: | VALID |
Dimension Table for the LOT Dimension
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_OPI_LOT_M_P | NORMAL | UNIQUE | APPS_TS_SUMMARY | LOT_EDW_LOT_PK_KEY |
LOTD_EDW_MTL_LOTD_LOT_U | NORMAL | UNIQUE | APPS_TS_SUMMARY | LOT_EDW_LOT_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALL_ALL_PK | VARCHAR2 | (40) | Primary Key of the All Level | |
ALL_ALL_PK_KEY | NUMBER | EDW-Assigned Surrogate Primary Key for the All Level | ||
ALL_NAME | VARCHAR2 | (80) | EDW-Internal Key for Name Level | |
LOT_DESCRIPTION | VARCHAR2 | (120) | Description of Lot | |
LOT_EDW_LOT_DP | VARCHAR2 | (240) | EDW-Internal Key for Lot | |
LOT_EDW_LOT_PK | VARCHAR2 | (130) | Primary Key of Lot (Includes Instance) | |
LOT_EDW_LOT_PK_KEY | NUMBER | Yes | EDW-Assigned Surrogate Primary Key for Lot | |
LOT_EXPIRATION_DATE | DATE | Lot Expiration Date | ||
LOT_INVENTORY_ITEM_ID | NUMBER | Inventory Item ID of Lot | ||
LOT_ITEM_REVISION | VARCHAR2 | (40) | Item Revision of Lot Item | |
LOT_LOT | VARCHAR2 | (80) | Lot Number | |
LOT_LOT_NAME | VARCHAR2 | (80) | Lot Name | |
LOT_NAME | VARCHAR2 | (130) | Lot Name | |
LOT_NETTABLE_FLAG | VARCHAR2 | (15) | For Future Use - Nettable (for Planning) Indicator for Lot | |
LOT_ORGANIZATION_ID | NUMBER | Organization ID of Lot Item | ||
LOT_PARENT_LOT | VARCHAR2 | (80) | Parent Lot, Applicable if Lot is a Sublot | |
CREATION_DATE | DATE | Yes | Creation Date of Lot | |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date of Lot Record on Source System | |
LOT_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Attribute 1 | |
LOT_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Attribute 2 | |
LOT_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Attribute 3 | |
LOT_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Attribute 4 | |
LOT_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Attribute 5 |
Cut, paste (and edit) the following text to query this object:
SELECT ALL_ALL_PK
, ALL_ALL_PK_KEY
, ALL_NAME
, LOT_DESCRIPTION
, LOT_EDW_LOT_DP
, LOT_EDW_LOT_PK
, LOT_EDW_LOT_PK_KEY
, LOT_EXPIRATION_DATE
, LOT_INVENTORY_ITEM_ID
, LOT_ITEM_REVISION
, LOT_LOT
, LOT_LOT_NAME
, LOT_NAME
, LOT_NETTABLE_FLAG
, LOT_ORGANIZATION_ID
, LOT_PARENT_LOT
, CREATION_DATE
, LAST_UPDATE_DATE
, LOT_USER_ATTRIBUTE1
, LOT_USER_ATTRIBUTE2
, LOT_USER_ATTRIBUTE3
, LOT_USER_ATTRIBUTE4
, LOT_USER_ATTRIBUTE5
FROM OPI.EDW_OPI_LOT_M;
OPI.EDW_OPI_LOT_M does not reference any database object
OPI.EDW_OPI_LOT_M is referenced by following:
|
|
|