[Home] [Help] [Dependency Information]
Object Name: | IEC_G_CACHE_RECORDS |
---|---|
Object Type: | TABLE |
Owner: | IEC |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEC_G_CACHE_RECORDS_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | CACHE_RECORD_ID |
IEC_G_CACHE_RECORDS_N4 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
LIST_HEADER_ID
LIST_ENTRY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CACHE_RECORD_ID | NUMBER | (15) | Yes | Unique identifier for this entry in the cache. |
RETURNS_ID | NUMBER | Yes | foreign key to return entries. | |
LIST_ENTRY_ID | NUMBER | Yes | List entry id of a record | |
SUBSET_ID | NUMBER | (15) | Yes | SUBSET_ID is the Foreign Key to the AO subset table |
LIST_HEADER_ID | NUMBER | Yes | List header id to which this record belongs | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Used for locking in HTML applications. |
CALLABLE_FLAG | VARCHAR2 | (1) | Flag indicating whether this entry is callable or not. | |
CALLBACK_FLAG | VARCHAR2 | (1) | Flag indicating whether or not this entry is a callback. | |
ITM_CC_TZ_ID | NUMBER | Yes | This is the country code and time zone information for this record. | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments. | |
REFRESH_ACTION_ID | NUMBER | Sequence generated by last refresh action. | ||
CREATION_DATE | DATE | Standard Who column. | ||
LAST_UPDATE_DATE | DATE | Standard Who column. |
Cut, paste (and edit) the following text to query this object:
SELECT CACHE_RECORD_ID
, RETURNS_ID
, LIST_ENTRY_ID
, SUBSET_ID
, LIST_HEADER_ID
, OBJECT_VERSION_NUMBER
, CALLABLE_FLAG
, CALLBACK_FLAG
, ITM_CC_TZ_ID
, SECURITY_GROUP_ID
, REFRESH_ACTION_ID
, CREATION_DATE
, LAST_UPDATE_DATE
FROM IEC.IEC_G_CACHE_RECORDS;
IEC.IEC_G_CACHE_RECORDS does not reference any database object
IEC.IEC_G_CACHE_RECORDS is referenced by following:
|
|
|