[Home] [Help] [Dependency Information]
Object Name: | EDW_POA_LN_TYPE_M |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.EDW_POA_LN_TYPE_M |
Subobject Name: | |
Status: | VALID |
This is the denormalized star table for the PO Line Type dimension. It contains records for the lowest level of the PO Line Type 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_POA_LN_TYPE_M_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
EPLT_LINE_TYPE_PK
EPLT_LINE_TYPE_PK_KEY |
EDW_POA_LN_TYPE_M_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY | EPLT_LINE_TYPE_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALL_ALL_PK_KEY | NUMBER | Unique identifier | ||
EPLT_LINE_TYPE_PK_KEY | NUMBER | Yes | System generated unique identifier | |
ALL_NAME | VARCHAR2 | (80) | All name | |
ALL_ALL_PK | VARCHAR2 | (40) | Unique identifier | |
EPLT_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
EPLT_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
EPLT_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
EPLT_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
EPLT_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
EPLT_OUTSIDE_OP_FLAG | VARCHAR2 | (40) | Outside processing flag | |
EPLT_ORDER_TYPE | VARCHAR2 | (40) | Code indicating that the line is amount based or quantity based. Amount based line type is used to order services. The price field represents the units of the service rendered. The quantity is set to a value of one. | |
EPLT_NAME | VARCHAR2 | (120) | PO line type name | |
EPLT_LINE_TYPE_DP | VARCHAR2 | (240) | Unique PO line type name | |
EPLT_INSTANCE | VARCHAR2 | (40) | Source database instance for PO line type | |
EPLT_DESCRIPTION | VARCHAR2 | (240) | PO line type Description | |
EPLT_LINE_TYPE_PK | VARCHAR2 | (80) | Unique identifier | |
EPLT_INACTIVE_DATE | DATE | Inactive date for PO line type | ||
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 ALL_ALL_PK_KEY
, EPLT_LINE_TYPE_PK_KEY
, ALL_NAME
, ALL_ALL_PK
, EPLT_USER_ATTRIBUTE5
, EPLT_USER_ATTRIBUTE4
, EPLT_USER_ATTRIBUTE3
, EPLT_USER_ATTRIBUTE2
, EPLT_USER_ATTRIBUTE1
, EPLT_OUTSIDE_OP_FLAG
, EPLT_ORDER_TYPE
, EPLT_NAME
, EPLT_LINE_TYPE_DP
, EPLT_INSTANCE
, EPLT_DESCRIPTION
, EPLT_LINE_TYPE_PK
, EPLT_INACTIVE_DATE
, CREATION_DATE
, LAST_UPDATE_DATE
FROM POA.EDW_POA_LN_TYPE_M;
POA.EDW_POA_LN_TYPE_M does not reference any database object
POA.EDW_POA_LN_TYPE_M is referenced by following:
|
|
|