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_CUSTOM_ACTIONS

Object Details

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

Holds the Actions for a specified Rule - used by FNDCUSTM.fmb and APPCORE to apply customizations.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_FORM_CUSTOM_ACTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTION_ID ZD_EDITION_NAME
FND_FORM_CUSTOM_ACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RULE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SEQUENCE	NUMBER		Yes	The sequence the action will be applied
PROPERTY_VALUE	VARCHAR2	(4000)		The new Value for the property PROPERTY_NAME
ARGUMENT_TYPE	VARCHAR2	(1)		The Argument Type of the Property PROPERTY_NAME
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who column
TARGET_OBJECT	VARCHAR2	(100)		The Object in the form to apply the property
ACTION_TYPE	VARCHAR2	(1)	Yes	Message, Builtin, Property or Special
ENABLED	VARCHAR2	(1)	Yes	Indicates if the action is enabled
OBJECT_TYPE	VARCHAR2	(30)		The Type of the Object
FOLDER_PROMPT_BLOCK	VARCHAR2	(30)		If a Folder, the prompt block for the Folder
MESSAGE_TYPE	VARCHAR2	(1)		The Type of the Message
MESSAGE_TEXT	VARCHAR2	(4000)		The Text of the Message
SUMMARY	VARCHAR2	(255)		A Summary of the Action
BUILTIN_TYPE	VARCHAR2	(1)		The Type of the Builtin
BUILTIN_ARGUMENTS	VARCHAR2	(4000)		The Arguments of the Builtin
LANGUAGE	VARCHAR2	(4)	Yes	The Language for the Action
RULE_ID	NUMBER		Yes	The FK to the FND_FORM_CUSTOM_RULES table
PROPERTY_NAME	NUMBER			The Internal ID of the property to change
MENU_ENTRY	VARCHAR2	(30)		The Special Menu Entry to modify
MENU_LABEL	VARCHAR2	(80)		The New Label for the Menu Entry
MENU_SEPERATOR	VARCHAR2	(1)		Indicates if a seperator is shown after the menu entry
MENU_ENABLED_IN	VARCHAR2	(255)		The Block(s) the menu is enabled in
MENU_ACTION	VARCHAR2	(1)		The Action Type for the menu entry
MENU_ARGUMENT_LONG	VARCHAR2	(2000)		Long Arguments for the menu. Valid for URL and Function
MENU_ARGUMENT_SHORT	VARCHAR2	(255)		Short Arguments for the menu. Valid for Function
ACTION_ID	NUMBER		Yes	A Generated sequence
REQUEST_APPLICATION_ID	NUMBER			The Application ID for Mernu Action of Concurrent Request
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT SEQUENCE
,      PROPERTY_VALUE
,      ARGUMENT_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TARGET_OBJECT
,      ACTION_TYPE
,      ENABLED
,      OBJECT_TYPE
,      FOLDER_PROMPT_BLOCK
,      MESSAGE_TYPE
,      MESSAGE_TEXT
,      SUMMARY
,      BUILTIN_TYPE
,      BUILTIN_ARGUMENTS
,      LANGUAGE
,      RULE_ID
,      PROPERTY_NAME
,      MENU_ENTRY
,      MENU_LABEL
,      MENU_SEPERATOR
,      MENU_ENABLED_IN
,      MENU_ACTION
,      MENU_ARGUMENT_LONG
,      MENU_ARGUMENT_SHORT
,      ACTION_ID
,      REQUEST_APPLICATION_ID
,      ZD_EDITION_NAME
FROM APPLSYS.FND_FORM_CUSTOM_ACTIONS;

Dependencies

[top of page]

APPLSYS.FND_FORM_CUSTOM_ACTIONS does not reference any database object

APPLSYS.FND_FORM_CUSTOM_ACTIONS is referenced by following:

APPLSYS: FND_FORM_CUSTOM_ACTIONS#