[Home] [Help] [Dependency Information]
Object Name: | EDW_OPI_PRDL_M |
---|---|
Object Type: | TABLE |
Owner: | OPI |
FND Design Data: | OPI.EDW_OPI_PRDL_M |
Subobject Name: | |
Status: | VALID |
Dimension table for Production Line that is used in Production Analysis. In Discrete Mfg., Assembly lines can be treated as production lines. As of now Process manufacturing does not have any concept of Production line.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_OPI_PRDL_M_P | NORMAL | UNIQUE | APPS_TS_SUMMARY |
PRDL_PRDL_PK
PRDL_PRDL_PK_KEY |
EDW_OPI_PRDL_M_U | NORMAL | UNIQUE | APPS_TS_SUMMARY | PRDL_PRDL_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALL_ALL_PK | VARCHAR2 | (40) | User key for all level | |
ALL_ALL_PK_KEY | NUMBER | Surrogate Key | ||
ALL_NAME | VARCHAR2 | (80) | Displayed name | |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
PRDL_DESCRIPTION | VARCHAR2 | (240) | Production line Description | |
PRDL_NAME | VARCHAR2 | (80) | Production line name | |
PRDL_ORGN_CODE | VARCHAR2 | (80) | Organization code | |
PRDL_PRDL_DP | VARCHAR2 | (240) | Discoverer displayed column | |
PRDL_PRDL_NAME | VARCHAR2 | (80) | Displayed name | |
PRDL_PRDL_PK | VARCHAR2 | (40) | Production line user key. This is a combination of Production line Id, Organization Id , Instance and Product-Tag | |
PRDL_PRDL_PK_KEY | NUMBER | Surrogate key, PK for the level. Override the ID column generated by OWB | ||
PRDL_PRODUCTION_LINE_CODE | VARCHAR2 | (30) | Production Line Code | |
PRDL_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute column | |
PRDL_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute column | |
PRDL_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute column | |
PRDL_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute column | |
PRDL_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute column |
Cut, paste (and edit) the following text to query this object:
SELECT ALL_ALL_PK
, ALL_ALL_PK_KEY
, ALL_NAME
, CREATION_DATE
, LAST_UPDATE_DATE
, PRDL_DESCRIPTION
, PRDL_NAME
, PRDL_ORGN_CODE
, PRDL_PRDL_DP
, PRDL_PRDL_NAME
, PRDL_PRDL_PK
, PRDL_PRDL_PK_KEY
, PRDL_PRODUCTION_LINE_CODE
, PRDL_USER_ATTRIBUTE1
, PRDL_USER_ATTRIBUTE2
, PRDL_USER_ATTRIBUTE3
, PRDL_USER_ATTRIBUTE4
, PRDL_USER_ATTRIBUTE5
FROM OPI.EDW_OPI_PRDL_M;
OPI.EDW_OPI_PRDL_M does not reference any database object
OPI.EDW_OPI_PRDL_M is referenced by following:
|
|
|