[Home] [Help] [Dependency Information]
Object Name: | EDW_POA_LNTP_LN_TYPE_LTC |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.EDW_POA_LNTP_LN_TYPE_LTC |
Subobject Name: | |
Status: | VALID |
This is the PO Line Type level table in the PO Line Type Dimension. This table stores the different purchase order line types that exist in the source databases.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_POA_LNTP_LN_TYPE_LTC_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | LINE_TYPE_PK_KEY |
EDW_POA_LNTP_LN_TYPE_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
LINE_TYPE_PK
LINE_TYPE_PK_KEY |
EDW_POA_LNTP_LN_TYPE_LTC_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | ALL_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_TYPE_PK_KEY | NUMBER | Unique identifier | ||
ALL_FK_KEY | NUMBER | System generated foreign key to the top level of the PO Line Type dimension | ||
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
OUTSIDE_OP_FLAG | VARCHAR2 | (40) | Outside processing indicator | |
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. | |
NAME | VARCHAR2 | (120) | PO line type name | |
LINE_TYPE_PK | VARCHAR2 | (80) | Unique identifier | |
LINE_TYPE_DP | VARCHAR2 | (240) | Unique PO line type name | |
INSTANCE | VARCHAR2 | (40) | Source database instance for PO Line Type | |
DESCRIPTION | VARCHAR2 | (240) | PO line type description | |
ALL_FK | VARCHAR2 | (40) | Foreign key to the top level of the PO Line Type dimension | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
INACTIVE_DATE | DATE | Inactive date for PO line type | ||
CREATION_DATE | DATE | Yes | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_TYPE_PK_KEY
, ALL_FK_KEY
, USER_ATTRIBUTE5
, USER_ATTRIBUTE4
, USER_ATTRIBUTE3
, USER_ATTRIBUTE2
, USER_ATTRIBUTE1
, OUTSIDE_OP_FLAG
, ORDER_TYPE
, NAME
, LINE_TYPE_PK
, LINE_TYPE_DP
, INSTANCE
, DESCRIPTION
, ALL_FK
, LAST_UPDATE_DATE
, INACTIVE_DATE
, CREATION_DATE
FROM POA.EDW_POA_LNTP_LN_TYPE_LTC;
POA.EDW_POA_LNTP_LN_TYPE_LTC does not reference any database object
POA.EDW_POA_LNTP_LN_TYPE_LTC is referenced by following:
|
|
|