[Home] [Help] [Dependency Information]
Object Name: | IBY_EXTRACTS_B |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_EXTRACTS_B |
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_B_EXTRACTID_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EXTRACT_ID |
IBY_EXTRACTS_B_EXTRACTCODE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXTRACT_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTRACT_ID | NUMBER | (15) | Yes | Primary key |
EXTRACT_CODE | VARCHAR2 | (30) | Yes | Extract code |
EXTRACT_VERSION | NUMBER | (15) | Yes | Version number of the extract; multiple extracts of the same type and name but differing version may exist within they system |
GEN_CODE_LANGUAGE | VARCHAR2 | (30) | Yes | Language in which the extract generation codepoint is implemented; possible values include: JAVA , PLSQL |
GEN_CODE_PACKAGE | VARCHAR2 | (255) | Yes | Package where the generator is defined; in PL/SQL this corresponds to a package name, in Java a class name |
GEN_CODE_ENTRY_POINT | VARCHAR2 | (255) | Yes | Entry point for the generator; typically a function or method name |
DATASOURCE_CODE | VARCHAR2 | (80) | Yes | Data source this extract is associated with |
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) | Yes | 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. |
Cut, paste (and edit) the following text to query this object:
SELECT EXTRACT_ID
, EXTRACT_CODE
, EXTRACT_VERSION
, GEN_CODE_LANGUAGE
, GEN_CODE_PACKAGE
, GEN_CODE_ENTRY_POINT
, DATASOURCE_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM IBY.IBY_EXTRACTS_B;
IBY.IBY_EXTRACTS_B does not reference any database object
IBY.IBY_EXTRACTS_B is referenced by following:
|
|
|