[Home] [Help] [Dependency Information]
Object Name: | EDW_HOLD_HOLD_LSTG |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.EDW_HOLD_HOLD_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for the AP hold dimension Hold level. 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: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_HOLD_HOLD_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | HOLD_PK |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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). | ||
HOLD_TYPE_FK_KEY | NUMBER | System generated foreign key for hold type dimension level | ||
USER_RELEASEABLE_FLAG | VARCHAR2 | (1) | Flag that indicates if the hold can be released by user (Y/N) | |
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 | |
POSTABLE_FLAG | VARCHAR2 | (1) | Flag that indicates whether this hold should prevent the invoice from being approved for posting | |
OPERATION_CODE | VARCHAR2 | (30) | Code used during warehouse collection | |
NAME | VARCHAR2 | (80) | Displayed name for the record | |
INSTANCE | VARCHAR2 | (40) | Instance identifier | |
HOLD_TYPE_FK | VARCHAR2 | (120) | Foreign key to hold type level | |
HOLD_PK | VARCHAR2 | (120) | Unique Identifier | |
HOLD_NAME | VARCHAR2 | (120) | Hold Name | |
HOLD_DP | VARCHAR2 | (240) | Field for discoverer so customers can have a display column that identifies all records uniquely | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
DESCRIPTION | VARCHAR2 | (80) | Staging table for hold hold level | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
INACTIVE_DATE | DATE | Standard Who column | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, HOLD_TYPE_FK_KEY
, USER_RELEASEABLE_FLAG
, USER_ATTRIBUTE5
, USER_ATTRIBUTE4
, USER_ATTRIBUTE3
, USER_ATTRIBUTE2
, USER_ATTRIBUTE1
, ROW_ID
, POSTABLE_FLAG
, OPERATION_CODE
, NAME
, INSTANCE
, HOLD_TYPE_FK
, HOLD_PK
, HOLD_NAME
, HOLD_DP
, ERROR_CODE
, DESCRIPTION
, COLLECTION_STATUS
, LAST_UPDATE_DATE
, INACTIVE_DATE
, CREATION_DATE
FROM FII.EDW_HOLD_HOLD_LSTG;
FII.EDW_HOLD_HOLD_LSTG does not reference any database object
FII.EDW_HOLD_HOLD_LSTG is referenced by following:
|
|
|