[Home] [Help] [Dependency Information]
Object Name: | IBY_EXTRACTS_TL |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_EXTRACTS_TL |
Subobject Name: | |
Status: | VALID |
IBY_EXTRACTS stores every extract definition supported by the extract generation engine.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_EXTRACTS_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LANGUAGE
EXTRACT_ID ZD_EDITION_NAME |
IBY_EXTRACTS_TL_EXTRACTID_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXTRACT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTRACT_ID | NUMBER | (15) | Yes | Primary key |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Language code of the record's current language |
EXTRACT_DESC | VARCHAR2 | (200) | Readable description of the extract and its purposes. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. The situation occurs when the HTML application is an 'stateless' application. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT EXTRACT_ID
, LANGUAGE
, SOURCE_LANG
, EXTRACT_DESC
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ZD_EDITION_NAME
FROM IBY.IBY_EXTRACTS_TL;
IBY.IBY_EXTRACTS_TL does not reference any database object
IBY.IBY_EXTRACTS_TL is referenced by following:
|
|
|