VIEW: APPS.ALR_ACTIONS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'