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

TABLE: ONT.OE_CUSTOM_ACTIONS

Object Details
Object Name: OE_CUSTOM_ACTIONS
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.OE_CUSTOM_ACTIONS
Subobject Name:
Status: VALID


This table stores the information about, all the actions that are assigned to a folder.
Each row includes the name of the action, flag to indicate if the action is displayed as button, folder object name, access key, prompt name.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACTION_ID NUMBER
Yes Action Identifier
OBJECT VARCHAR2 (30)
Folder Object Name
ACTION_NAME VARCHAR2 (500) Yes Sales Order Action Name
USER_ENTERED_PROMPT VARCHAR2 (500)
User Entered Prompt Name for Button
USER_ID NUMBER

User Identifier
FOLDER_ID NUMBER
Yes Folder Identifier, the action is associated with.
WIDTH NUMBER

Width of the button
ACCESS_KEY VARCHAR2 (6)
Access Key for button
DISPLAY_AS_BUTTON_FLAG VARCHAR2 (1)
Flag to indicate, if the action is displayed as button.
DEFAULT_PROMPT VARCHAR2 (200)
Default prompt of the button
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who column
Query Text

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


SELECT ACTION_ID
,      OBJECT
,      ACTION_NAME
,      USER_ENTERED_PROMPT
,      USER_ID
,      FOLDER_ID
,      WIDTH
,      ACCESS_KEY
,      DISPLAY_AS_BUTTON_FLAG
,      DEFAULT_PROMPT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM ONT.OE_CUSTOM_ACTIONS;

Dependencies

[top of page]

ONT.OE_CUSTOM_ACTIONS does not reference any database object

ONT.OE_CUSTOM_ACTIONS is referenced by following:

SchemaONT
ViewOE_CUSTOM_ACTIONS#