VIEW: APPS.OE_ACTIONS

Source

View Text - Preformatted

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') )

View Text - HTML Formatted

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') )