eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.ALR_ACTIONS_V

Object Details

Object Name:	ALR_ACTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ALR.ALR_ACTIONS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
NAME	VARCHAR2	(80)	Yes	Action name
DESCRIPTION	VARCHAR2	(240)		Action Description
ACTION_TYPE	VARCHAR2	(1)	Yes	Action type lookup code
ACTION_LEVEL_TYPE	VARCHAR2	(1)		Action level lookup code
LIST	VARCHAR2	(30)		Distribution list name
LIST_ID	NUMBER			Distribution list identifier
LIST_APPLICATION_ID	NUMBER			Application identifier for distribution list
TO_RECIPIENTS	VARCHAR2	(240)		List of primary message recipients
CC_RECIPIENTS	VARCHAR2	(240)		List of copy message recipients
BCC_RECIPIENTS	VARCHAR2	(240)		List of blind copy message recipients
PRINT_RECIPIENTS	VARCHAR2	(240)		List of print message recipients
PRINTER	VARCHAR2	(30)		Printer name
REPLY_TO	VARCHAR2	(240)		Reply to mail ID
SUBJECT	VARCHAR2	(240)		Message subject text
RESPONSE_SET_ID	NUMBER			Response set identifier
RESPONSE_SET	VARCHAR2	(30)		Response name
FOLLOW_UP_AFTER_DAYS	NUMBER			Number of days after which outstanding responses are automatically closed
MSG_FILE_NAME	VARCHAR2	(240)		Name of message, operating system script, or SQL script whose body resides in an operating system file
MSG_BODY	VARCHAR2	(2000)		Body of message, SQL script, or operating system script
COLUMN_WRAP_FLAG	VARCHAR2	(1)		Column wrap flag
MAXIMUM_SUMMARY_MESSAGE_WIDTH	NUMBER			Right margin of summary message
CONCURRENT_PROGRAM_ID	NUMBER			Concurrent program identifier
CNC_PROGRAM_APPLICATION	VARCHAR2	(240)		Name of application
CNC_FILE_NAME	VARCHAR2	(240)		Name of message, operating system script, or SQL script whose body resides in an operating system file
CNC_ARGUMENT_STRING	VARCHAR2	(240)		Argument list for SQL, operating system, and concurrent program actions
OS_PROGRAM_APPLICATION	VARCHAR2	(240)		Name of application
OS_ARGUMENT_STRING	VARCHAR2	(240)		Argument list for SQL, operating system, and concurrent program actions
OS_FILE_NAME	VARCHAR2	(240)		Name of message, operating system script, or SQL script whose body resides in an operating system file
OS_BODY	VARCHAR2	(2000)		Body of message, SQL script, or operating system script
SQL_PROGRAM_APPLICATION	VARCHAR2	(240)		Name of application
SQL_ARGUMENT_STRING	VARCHAR2	(240)		Argument list for SQL, operating system, and concurrent program actions
SQL_FILE_NAME	VARCHAR2	(240)		Name of message, operating system script, or SQL script whose body resides in an operating system file
SQL_BODY	VARCHAR2	(2000)		Body of message, SQL script, or operating system script
PROGRAM_APPLICATION_ID	NUMBER			Application identifier for concurrent program
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
END_DATE_ACTIVE	DATE			Last date action is enabled
ENABLED_FLAG	VARCHAR2	(1)		Enabled flag
DATE_LAST_EXECUTED	DATE			Date action was last performed
APPLICATION_ID	NUMBER		Yes	Application identifier
ALERT_ID	NUMBER		Yes	Alert identifier
ACTION_ID	NUMBER		Yes	Action identifier
VERSION_NUMBER	NUMBER		Yes	Version number of action
ROW_ID	ROWID	(10)		Row identifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NAME
,      DESCRIPTION
,      ACTION_TYPE
,      ACTION_LEVEL_TYPE
,      LIST
,      LIST_ID
,      LIST_APPLICATION_ID
,      TO_RECIPIENTS
,      CC_RECIPIENTS
,      BCC_RECIPIENTS
,      PRINT_RECIPIENTS
,      PRINTER
,      REPLY_TO
,      SUBJECT
,      RESPONSE_SET_ID
,      RESPONSE_SET
,      FOLLOW_UP_AFTER_DAYS
,      MSG_FILE_NAME
,      MSG_BODY
,      COLUMN_WRAP_FLAG
,      MAXIMUM_SUMMARY_MESSAGE_WIDTH
,      CONCURRENT_PROGRAM_ID
,      CNC_PROGRAM_APPLICATION
,      CNC_FILE_NAME
,      CNC_ARGUMENT_STRING
,      OS_PROGRAM_APPLICATION
,      OS_ARGUMENT_STRING
,      OS_FILE_NAME
,      OS_BODY
,      SQL_PROGRAM_APPLICATION
,      SQL_ARGUMENT_STRING
,      SQL_FILE_NAME
,      SQL_BODY
,      PROGRAM_APPLICATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      END_DATE_ACTIVE
,      ENABLED_FLAG
,      DATE_LAST_EXECUTED
,      APPLICATION_ID
,      ALERT_ID
,      ACTION_ID
,      VERSION_NUMBER
,      ROW_ID
FROM APPS.ALR_ACTIONS_V;

Dependencies

[top of page]

APPS.ALR_ACTIONS_V references the following:

APPS: ALR_ACTIONS; ALR_DISTRIBUTION_LISTS; ALR_RESPONSE_SETS; FND_APPLICATION_TL

APPS.ALR_ACTIONS_V is not referenced by any database object