Product: | ALR - Alert |
---|---|
Description: | Alert Actions View |
Implementation/DBA Data: | APPS.ALR_ACTIONS_V |
SELECT A.NAME
, A.DESCRIPTION
, A.ACTION_TYPE
, A.ACTION_LEVEL_TYPE
, DL.NAME LIST
, A.LIST_ID
, A.LIST_APPLICATION_ID
, A.TO_RECIPIENTS
, A.CC_RECIPIENTS
, A.BCC_RECIPIENTS
, A.PRINT_RECIPIENTS
, A.PRINTER
, A.REPLY_TO
, A.SUBJECT
, A.RESPONSE_SET_ID
, RS.NAME RESPONSE_SET
, A.FOLLOW_UP_AFTER_DAYS
, A.FILE_NAME MSG_FILE_NAME
, A.BODY MSG_BODY
, A.COLUMN_WRAP_FLAG
, A.MAXIMUM_SUMMARY_MESSAGE_WIDTH
, A.CONCURRENT_PROGRAM_ID
, FA.APPLICATION_NAME CNC_PROGRAM_APPLICATION_ID
, A.FILE_NAME CNC_FILE_NAME
, A.ARGUMENT_STRING CNC_ARGUMENT_STRING
, FA.APPLICATION_NAME OS_PROGRAM_APPLICATION
, A.ARGUMENT_STRING OS_ARGUMENT_STRING
, A.FILE_NAME OS_FILE_NAME
, A.BODY OS_BODY
, FA.APPLICATION_NAME SQL_PROGRAM_APPLICATION
, A.ARGUMENT_STRING SQL_ARGUMENT_STRING
, A.FILE_NAME SQL_FILE_NAME
, A.BODY SQL_BODY
, A.PROGRAM_APPLICATION_ID
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.END_DATE_ACTIVE
, A.ENABLED_FLAG
, A.DATE_LAST_EXECUTED
, A.APPLICATION_ID
, A.ALERT_ID
, A.ACTION_ID
, A.VERSION_NUMBER
, A.ROWID ROW_ID
FROM ALR_ACTIONS A
, (SELECT APPLICATION_ID
, APPLICATION_NAME
FROM FND_APPLICATION_TL
WHERE LANGUAGE = USERENV('LANG')) FA
, ALR_RESPONSE_SETS RS
, ALR_DISTRIBUTION_LISTS DL
WHERE FA.APPLICATION_ID (+) = A.PROGRAM_APPLICATION_ID
AND RS.RESPONSE_SET_ID (+) = A.RESPONSE_SET_ID
AND RS.ENABLED_FLAG (+) = 'Y'
AND DL.LIST_ID (+) = A.LIST_ID
AND DL.ENABLED_FLAG (+) = 'Y'