[Home] [Help] [Dependency Information]
Object Name: | EDW_RESR_REV_SRC_LSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_RESR_REV_SRC_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for the revenue source 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_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REV_SRC_PK | VARCHAR2 | (40) | Revenue Source unique identifier | |
ROW_ID | VARCHAR2 | (20) | Row identifier | |
ALL_FK | VARCHAR2 | (40) | Foreign key to the top level of the revenue source dimension. | |
ALL_FK_KEY | NUMBER | System generated foreign key to the top level of the revenue source dimension | ||
REV_SRC_DP | VARCHAR2 | (80) | Unique revenue source name | |
NAME | VARCHAR2 | (80) | Revenue source name | |
REVENUE_SOURCE | VARCHAR2 | (40) | Revenue source | |
DESCRIPTION | VARCHAR2 | (80) | Revenue source description | |
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 whether 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 REV_SRC_PK
, ROW_ID
, ALL_FK
, ALL_FK_KEY
, REV_SRC_DP
, NAME
, REVENUE_SOURCE
, DESCRIPTION
, 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_RESR_REV_SRC_LSTG;
FII.EDW_RESR_REV_SRC_LSTG does not reference any database object
FII.EDW_RESR_REV_SRC_LSTG is referenced by following:
|
|
|