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_FORM_FUNCTIONS

Object Details

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

FND_FORM_FUNCTIONS stores information about function grouping
in forms. Each row includes a function identifier, the function
name, and the application identifier. Each row also includes the
form identifier and the parameters for calling the form. You need
one row for each function. Oracle Application Object Library uses
this information to implementation the subdivision of forms into
different functionality groups using the existing menu system. This
view is only used for Oracle Applications in GUI mode.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_FORM_FUNCTIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	FUNCTION_ID
FND_FORM_FUNCTIONS_U2	NORMAL	UNIQUE	APPS_TS_SEED	FUNCTION_NAME
SYS_IL0000034459C00028$$	LOB	UNIQUE	APPS_TS_SEED
SYS_IL0000034459C00030$$	LOB	UNIQUE	APPS_TS_SEED
SYS_IL0000034459C00031$$	LOB	UNIQUE	APPS_TS_SEED
FND_FORM_FUNCTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	APPLICATION_ID FORM_ID
FND_FORM_FUNCTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	TYPE
FND_FORM_FUNCTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	IREP_CLASS_ID
FND_FORM_FUNCTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_SEED	OBJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FUNCTION_ID	NUMBER		Yes	Function identifier
FUNCTION_NAME	VARCHAR2	(480)	Yes	Function name
APPLICATION_ID	NUMBER			Application identifier
FORM_ID	NUMBER			Form identifier
PARAMETERS	VARCHAR2	(2000)		Parameters
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
TYPE	VARCHAR2	(30)		Function type
WEB_HOST_NAME	VARCHAR2	(80)		IP address or alias of machine where the Webserver is running. Defaults to the last agent used
WEB_AGENT_NAME	VARCHAR2	(80)		Name of Oracle Web Agent. Defaults to the last agent used
WEB_HTML_CALL	VARCHAR2	(240)		Contains the URL to activate this function. It may be either a static page or a procedure
WEB_ENCRYPT_PARAMETERS	VARCHAR2	(1)		Flag signifies when encrypt parameters are on a web page
WEB_SECURED	VARCHAR2	(1)		Indicates whether a function can be run without authentication the user
WEB_ICON	VARCHAR2	(30)		Icon name for OSSWA menu display
OBJECT_ID	NUMBER	(15)		OBJECT_ID
REGION_APPLICATION_ID	NUMBER	(15)		REGION_APPLICATION_ID
REGION_CODE	VARCHAR2	(30)		REGIONS_CODE
MAINTENANCE_MODE_SUPPORT	VARCHAR2	(8)	Yes	Whether this function supports limited functionalitywhile the environment is partially down
CONTEXT_DEPENDENCE	VARCHAR2	(8)	Yes	What aspect of the current context this function'sbehavior depends on
JRAD_REF_PATH	VARCHAR2	(1000)		JRAD_REF_PATH
IREP_METHOD_NAME	VARCHAR2	(80)		Native Method Name
IREP_OVERLOAD_SEQUENCE	NUMBER	(15)		Overload Sequence
IREP_SCOPE	VARCHAR2	(30)		Scope
IREP_LIFECYCLE	VARCHAR2	(30)		Lifecycle
IREP_DESCRIPTION	CLOB	(4000)		Full Description
IREP_COMPATIBILITY	VARCHAR2	(1)		Compatability Flag
IREP_INBOUND_XML_DESCRIPTION	CLOB	(4000)		Inbound XML Schema
IREP_OUTBOUND_XML_DESCRIPTION	CLOB	(4000)		Outbound XML Schema
IREP_SYNCHRO	VARCHAR2	(1)		Synchronicity
IREP_DIRECTION	VARCHAR2	(1)		Map Direction
IREP_ASSOC_FUNCTION_NAME	VARCHAR2	(480)		Base Method
IREP_CLASS_ID	NUMBER	(15)		Parent Interface
IREP_SCHEMA_VALIDATION_FLAG	VARCHAR2	(1)		Flag used for schema validation

Query Text

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


SELECT FUNCTION_ID
,      FUNCTION_NAME
,      APPLICATION_ID
,      FORM_ID
,      PARAMETERS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TYPE
,      WEB_HOST_NAME
,      WEB_AGENT_NAME
,      WEB_HTML_CALL
,      WEB_ENCRYPT_PARAMETERS
,      WEB_SECURED
,      WEB_ICON
,      OBJECT_ID
,      REGION_APPLICATION_ID
,      REGION_CODE
,      MAINTENANCE_MODE_SUPPORT
,      CONTEXT_DEPENDENCE
,      JRAD_REF_PATH
,      IREP_METHOD_NAME
,      IREP_OVERLOAD_SEQUENCE
,      IREP_SCOPE
,      IREP_LIFECYCLE
,      IREP_DESCRIPTION
,      IREP_COMPATIBILITY
,      IREP_INBOUND_XML_DESCRIPTION
,      IREP_OUTBOUND_XML_DESCRIPTION
,      IREP_SYNCHRO
,      IREP_DIRECTION
,      IREP_ASSOC_FUNCTION_NAME
,      IREP_CLASS_ID
,      IREP_SCHEMA_VALIDATION_FLAG
FROM APPLSYS.FND_FORM_FUNCTIONS;

Dependencies

[top of page]

APPLSYS.FND_FORM_FUNCTIONS does not reference any database object

APPLSYS.FND_FORM_FUNCTIONS is referenced by following:

APPS: FND_FORM_FUNCTIONS