[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AMS_PORTAL_CACHE |
|---|---|
| Object Type: | TABLE |
| Owner: | AMS |
| FND Design Data: |  AMS.AMS_PORTAL_CACHE
|
| Subobject Name: | |
| Status: | VALID |
AMS_PORTAL_CACHE stores cached information for Marketing Portal categories, this table is populated by Java concurrent program at a user specified interval. Currently, this program is oracle.apps.ams.portal.CategoryCacheDaemon
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AMS_PORTAL_CACHE_N1 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
 DELETE_FLAG
|
| AMS_PORTAL_CACHE_N2 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
LANGUAGE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CACHE_ID | NUMBER | Yes | Unique identifier | |
| PARENT_ID | VARCHAR2 | (150) | parent category id - the value of this is dependent on the seeded queries that drive connections between category levels | |
| CATEGORY_TYPE | VARCHAR2 | (150) | Yes | This column uniquely identifies every level of the portal hierarchy. |
| CATEGORY_ID | VARCHAR2 | (150) | ID value from the set of ids for the category type. this is also dependent on the seeded queries that drive relationships between category levels. | |
| DISPLAY_ORDER | NUMBER | Yes | Order that members of a category type should be displayed in. | |
| MEANING_CODE | VARCHAR2 | (30) | Should be used for display purposes in lieu of a category_name value. Typically only used for top-level category types. | |
| MAX_CHILDREN | NUMBER | Yes | Maximum number of category type members to be displayed for the category type. if this is -1, then all members should be displayed. | |
| CHILD_COUNT | NUMBER | Yes | Number of children for this category type and this category id. | |
| PERZ_QUERY_ID | NUMBER | Refers to a seeded query to retrieve members of this category type. If this is null, then this category type is either a top-level, or has no subcategories. | ||
| SUBCAT_TYPE | VARCHAR2 | (150) | Unique identifier of the child level of this category type. Used to fetch all child category members. | |
| VO_CLASSNAME | VARCHAR2 | (1024) | If this category_type can have items, this must be defined to specify how to query the items. | |
| TD_CLASSNAME | VARCHAR2 | (1024) | If this category_type can have items, this must be defined to specify how to render the items. | |
| QUERY_TYPE | VARCHAR2 | (150) | If this category_type can have items, this must be defined to specify the seeded display options for the item table. | |
| PERZ_QUERY_BIND_VARS | VARCHAR2 | (1024) | Used to name and indicate how many bind variables there are for the perz query of this category type. | |
| ITEM_BIND_VARS | VARCHAR2 | (1024) | Bind variables to be used to drive the item table query, if there are any items allowed for this category type. | |
| METHOD_CODE | VARCHAR2 | (150) | Used in lieu of a perz query to retrieve category type members. Generally used to access key flexfield segments. | |
| CATEGORY_NAME | VARCHAR2 | (1024) | Translated name of a category type member for this category type. | |
| LANGUAGE | VARCHAR2 | (4) | Yes | For translation purposes. |
| DELETE_FLAG | VARCHAR2 | (1) | Yes | To mark old data when the Java concurrent program is refreshing the cache. |
| LAST_UPDATE_DATE | DATE | Used to determine if the cache needs to be refreshed. |
Cut, paste (and edit) the following text to query this object:
SELECT CACHE_ID
, PARENT_ID
, CATEGORY_TYPE
, CATEGORY_ID
, DISPLAY_ORDER
, MEANING_CODE
, MAX_CHILDREN
, CHILD_COUNT
, PERZ_QUERY_ID
, SUBCAT_TYPE
, VO_CLASSNAME
, TD_CLASSNAME
, QUERY_TYPE
, PERZ_QUERY_BIND_VARS
, ITEM_BIND_VARS
, METHOD_CODE
, CATEGORY_NAME
, LANGUAGE
, DELETE_FLAG
, LAST_UPDATE_DATE
FROM AMS.AMS_PORTAL_CACHE;
AMS.AMS_PORTAL_CACHE does not reference any database object
AMS.AMS_PORTAL_CACHE is referenced by following:
APPS
AMS_PORTAL_CACHE
|
|
|
|