[Home] [Help] [Dependency Information]
Object Name: | IEC_G_CACHE_MKTG_ITEMS |
---|---|
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_MKTG_ITEMS_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | CACHE_MKTG_ITEM_ID |
IEC_G_CACHE_MKTG_ITEMS_U2 | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
LIST_HEADER_ID
SUBSET_ID CALLBACK_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CACHE_MKTG_ITEM_ID | NUMBER | (15) | Yes | Unique Identifier |
LIST_HEADER_ID | NUMBER | (15) | Yes | LIST_HEADER_ID is the Foreign Key to the marketing AMS_LIST_HEADER_ALL table |
SUBSET_ID | NUMBER | (15) | Yes | SUBSET_ID is the Foreign Key to the AO subset table |
CALLBACK_FLAG | VARCHAR2 | (1) | Yes | Flag indicating whether or not this entry represents an AO callback. |
RECORD_CACHE_SEQ | NUMBER | (15) | Yes | A pointer to value in the IEC_G_CACHE_ENTRIES table that acts as a sequence for this particular marketing item. |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments. |
Cut, paste (and edit) the following text to query this object:
SELECT CACHE_MKTG_ITEM_ID
, LIST_HEADER_ID
, SUBSET_ID
, CALLBACK_FLAG
, RECORD_CACHE_SEQ
, SECURITY_GROUP_ID
FROM IEC.IEC_G_CACHE_MKTG_ITEMS;
IEC.IEC_G_CACHE_MKTG_ITEMS does not reference any database object
IEC.IEC_G_CACHE_MKTG_ITEMS is referenced by following:
|
|
|