[Home] [Help]
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
Name |
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 |