[Home] [Help] [Dependency Information]
Object Name: | EDW_LOOKUP_M |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | BIS.EDW_LOOKUP_M
POA.EDW_LOOKUP_M |
Subobject Name: | |
Status: | VALID |
This is the denormalized star table for the Lookup dimension. It contains records for the lowest level of the Lookup dimension and their parentage up to the top level, across all hierarchies.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_LOOKUP_M_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
LUCD_LOOKUP_CODE_PK
LUCD_LOOKUP_CODE_PK_KEY |
EDW_LOOKUP_M_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY | LUCD_LOOKUP_CODE_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LUCD_LOOKUP_CODE_PK | VARCHAR2 | (240) | Unique identifier | |
LUCD_LOOKUP_CODE_PK_KEY | NUMBER | Yes | System generated unique identifier | |
LUCD_LOOKUP_CODE_DP | VARCHAR2 | (240) | Unique Lookup Code name | |
LUCD_NAME | VARCHAR2 | (240) | Lookup code name | |
LUCD_LOOKUP_CODE | VARCHAR2 | (80) | Lookup code | |
LUCD_LOOKUP_TYPE | VARCHAR2 | (80) | Lookup code type | |
LUCD_DESCRIPTION | VARCHAR2 | (240) | Lookup code description | |
LUCD_START_DATE_ACTIVE | DATE | Lookup code start date | ||
LUCD_END_DATE_ACTIVE | DATE | Lookup code end date | ||
LUCD_TABLE_CODE | VARCHAR2 | (20) | Which source application table/entry the lookup comes from | |
LUCD_INSTANCE | VARCHAR2 | (40) | Instance identifier | |
LUCD_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
LUCD_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
LUCD_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
LUCD_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
LUCD_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
ALL_ALL_PK | VARCHAR2 | (40) | Unique identifier | |
ALL_ALL_PK_KEY | NUMBER | System generated unique identifier | ||
ALL_NAME | VARCHAR2 | (80) | Top level for Lookup dimension | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT LUCD_LOOKUP_CODE_PK
, LUCD_LOOKUP_CODE_PK_KEY
, LUCD_LOOKUP_CODE_DP
, LUCD_NAME
, LUCD_LOOKUP_CODE
, LUCD_LOOKUP_TYPE
, LUCD_DESCRIPTION
, LUCD_START_DATE_ACTIVE
, LUCD_END_DATE_ACTIVE
, LUCD_TABLE_CODE
, LUCD_INSTANCE
, LUCD_USER_ATTRIBUTE1
, LUCD_USER_ATTRIBUTE2
, LUCD_USER_ATTRIBUTE3
, LUCD_USER_ATTRIBUTE4
, LUCD_USER_ATTRIBUTE5
, ALL_ALL_PK
, ALL_ALL_PK_KEY
, ALL_NAME
, CREATION_DATE
, LAST_UPDATE_DATE
FROM POA.EDW_LOOKUP_M;
POA.EDW_LOOKUP_M does not reference any database object
POA.EDW_LOOKUP_M is referenced by following:
|
|
|