View: OE_ACTIONS

Product:	ONT - Order Management
Description:	Internal Forms View for the default actions and the customized actions for an user.
Implementation/DBA Data:	APPS.OE_ACTIONS

View Text

SELECT ACTION_ID
, OBJECT
, ACTION_NAME
, USER_ENTERED_PROMPT
, 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 OE_CUSTOM_ACTIONS UNION SELECT ACTION_ID
, OBJECT
, ACTION_NAME
, NULL USER_ENTERED_PROMPT
, -1 FOLDER_ID
, WIDTH
, NULL ACCESS_KEY
, DISPLAY_AS_BUTTON_FLAG
, NULL DEFAULT_PROMPT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM OE_DEFAULT_ACTIONS ODA
WHERE ACTION_NAME NOT IN (SELECT ACTION_NAME
FROM OE_CUSTOM_ACTIONS OCA
WHERE OCA.USER_ID=FND_PROFILE.VALUE('USER_ID') )

Columns