[Home] [Help] [Dependency Information]
Object Name: | EDW_POA_LNTP_LN_TYPE_LSTG |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.EDW_POA_LNTP_LN_TYPE_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for PO Line Type level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_POA_LNTP_LN_TYPE_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | LINE_TYPE_PK |
EDW_POA_LNTP_LN_TYPE_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Identifier used by collection program | ||
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 | |
ROW_ID | ROWID | (10) | Row identifier | |
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. | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the loader program to determine whether to insert/update/delete this record | |
NAME | VARCHAR2 | (120) | PO line type name | |
LINE_TYPE_PK | VARCHAR2 | (240) | Unique identifier | |
LINE_TYPE_DP | VARCHAR2 | (240) | Unique PO line type name | |
INSTANCE | VARCHAR2 | (40) | Source database instance for PO Line Type | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
DESCRIPTION | VARCHAR2 | (240) | PO line type description | |
COLLECTION_STATUS | VARCHAR2 | (30) | Loading status code for the record (It refers to the status after the Load Engine attempts to move the record from the staging table to the level table. It does not refer to the movement of the data from the source to the staging table) | |
ALL_FK | VARCHAR2 | (40) | Foreign key to the top level of the PO Line Type dimension | |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
INACTIVE_DATE | DATE | Inactive date for PO Line Type | ||
CREATION_DATE | DATE | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, ALL_FK_KEY
, USER_ATTRIBUTE5
, USER_ATTRIBUTE4
, USER_ATTRIBUTE3
, USER_ATTRIBUTE2
, USER_ATTRIBUTE1
, ROW_ID
, OUTSIDE_OP_FLAG
, ORDER_TYPE
, OPERATION_CODE
, NAME
, LINE_TYPE_PK
, LINE_TYPE_DP
, INSTANCE
, ERROR_CODE
, DESCRIPTION
, COLLECTION_STATUS
, ALL_FK
, LAST_UPDATE_DATE
, INACTIVE_DATE
, CREATION_DATE
FROM POA.EDW_POA_LNTP_LN_TYPE_LSTG;
POA.EDW_POA_LNTP_LN_TYPE_LSTG does not reference any database object
POA.EDW_POA_LNTP_LN_TYPE_LSTG is referenced by following:
|
|
|