DBA Data[Home] [Help] [Dependency Information]

TABLE: AMS.AMS_PORTAL_CACHE

Object Details
Object Name: AMS_PORTAL_CACHE
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.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


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_PORTAL_CACHE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnDELETE_FLAG
AMS_PORTAL_CACHE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnLANGUAGE
Columns
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.
Query Text

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;

Dependencies

[top of page]

AMS.AMS_PORTAL_CACHE does not reference any database object

AMS.AMS_PORTAL_CACHE is referenced by following:

SchemaAMS
ViewAMS_PORTAL_CACHE#