[Home] [Help] [Dependency Information]
Object Name: | EDW_ARTT_CODE_LSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_ARTT_CODE_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for the transaction code level table. Before transaction code information is loaded into the warehouse, data is temporarily held in the staging table for verification and cleansing.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRX_CODE_PK | VARCHAR2 | (40) | The unique identifier for transaction quickcode | |
ROW_ID | VARCHAR2 | (20) | Row identifier | |
ALL_FK | VARCHAR2 | (40) | Foreign key to the top level of the transaction quickcode dimension | |
ALL_FK_KEY | NUMBER | System generated foreign key to the top level of the transaction quickcode dimension | ||
TRX_CODE_DP | VARCHAR2 | (240) | Unique transaction quickcode | |
NAME | VARCHAR2 | (80) | Name of the transaction quickcode | |
DESCRIPTION | VARCHAR2 | (80) | Detailed description of the transaction quickcode | |
TRANSACTION_CODE | VARCHAR2 | (120) | Brief description of the transaction quickcode | |
ENABLED_FLAG | VARCHAR2 | (20) | This is used to enable or disable the quickcode | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
END_DATE_ACTIVE | DATE | Date to inactivate the quickcode | ||
STRT_DATE_ACTIVE | DATE | Date to activate the quickcode | ||
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE6 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE7 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE8 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE9 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE10 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE11 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE12 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE13 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE14 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE15 | VARCHAR2 | (240) | User defined attribute | |
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine wheather to insert/update/delete this record. | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record |
Cut, paste (and edit) the following text to query this object:
SELECT TRX_CODE_PK
, ROW_ID
, ALL_FK
, ALL_FK_KEY
, TRX_CODE_DP
, NAME
, DESCRIPTION
, TRANSACTION_CODE
, ENABLED_FLAG
, CREATION_DATE
, END_DATE_ACTIVE
, STRT_DATE_ACTIVE
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, REQUEST_ID
, OPERATION_CODE
, ERROR_CODE
, COLLECTION_STATUS
FROM FII.EDW_ARTT_CODE_LSTG;
FII.EDW_ARTT_CODE_LSTG does not reference any database object
FII.EDW_ARTT_CODE_LSTG is referenced by following:
|
|
|