eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPLSYS.FND_PORTLET_DEPENDENCY

Object Details

Object Name:	FND_PORTLET_DEPENDENCY
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_PORTLET_DEPENDENCY
Subobject Name:
Status:	VALID

FND_PORTLET_DEPENDENCY stores the relationship between a row in
fnd_form_functions and the data collector program that effects the content
that is displayed in that form function. For example, a portlet form
function might require a refresh of it's cached display content based on
running a concurrent program. When the concurrent program that effects that
portlet is run, the concurrent manager will automatically look for any form
function references it needs to refresh based on the relationship in
FND_PORTLET_DEPENDENCY. When the concurrent manager finds an instance of
the concurrent program it sets the cache status for the function_name
representing the portlet to dirty. This caching status information is
actually stored in a separate table called ICX_PORTLET_CUSTOMIZATIONS. The
REFRESH_DEPENDENCY and REFRESH_DEPENDENCY_CONTEXT are generically named
columns so that other types of portlet functions and refresh mechanisms can
be defined besides concurrent programs.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_PORTLET_DEPENDENCY_U1	NORMAL	UNIQUE	APPS_TS_SEED	REFRESH_DEPENDENCY REFRESH_DEPENDENCY_CONTEXT FUNCTION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
REFRESH_DEPENDENCY	VARCHAR2	(30)	Yes	Name of concurrent program, UI function, or other datasource that causes a refresh of the portlet content.
REFRESH_DEPENDENCY_CONTEXT	VARCHAR2	(50)		Additional column that uniquely identifies thedata source. For concurrent programs this column stores the applicationshort name value for the concurrent program definition.
FUNCTION_NAME	VARCHAR2	(30)	Yes	Portlet function that should have its cached content refreshed wheneverthe concurrent program or other data source is run.
LAST_UPDATE_DATE	DATE		Yes	LAST_UPDATE_DATE
LAST_UPDATED_BY	NUMBER	(15)	Yes	LAST_UPDATED_BY
CREATION_DATE	DATE		Yes	CREATION_DATE
CREATED_BY	NUMBER	(15)	Yes	CREATED_BY
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	LAST_UPDATE_LOGIN

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REFRESH_DEPENDENCY
,      REFRESH_DEPENDENCY_CONTEXT
,      FUNCTION_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPLSYS.FND_PORTLET_DEPENDENCY;

Dependencies

[top of page]

APPLSYS.FND_PORTLET_DEPENDENCY does not reference any database object

APPLSYS.FND_PORTLET_DEPENDENCY is referenced by following:

APPS: FND_PORTLET_DEPENDENCY