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]

TABLE: LNS.LNS_EVENT_ACTIONS

Object Details

Object Name:	LNS_EVENT_ACTIONS
Object Type:	TABLE
Owner:	LNS
FND Design Data:	LNS.LNS_EVENT_ACTIONS
Subobject Name:
Status:	VALID

This table stores actionable events for a Loan type and loan class

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
LNS_EVENT_ACTIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	EVENT_ACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_ACTION_ID	NUMBER	(15)	Yes	Event Action Id
EVENT_ID	NUMBER	(15)	Yes	Event Id
EVENT_ACTION_NAME	VARCHAR2	(30)	Yes	Event Action Name
DESCRIPTION	VARCHAR2	(250)	Yes	Description
DELIVERY_METHOD	VARCHAR2	(30)		Notification Delivery method
LOAN_TYPE	VARCHAR2	(30)		Loan Type
ACTION_TYPE	VARCHAR2	(30)	Yes	Action Type
ENABLED_FLAG	VARCHAR2	(1)	Yes	This column indicates whether the event action is enabled or not
API_NAME	VARCHAR2	(250)		API Name
NOTIFICATION_TYPE	VARCHAR2	(30)		Notification Type
SETUP_TYPE	VARCHAR2	(30)		Setup Type
PRIMARY_RECIPIENT_TYPE	VARCHAR2	(30)		Primary Recipient Type
PRIMARY_RECIPIENT_NAME	VARCHAR2	(30)		Primary Recipient Name
SECONDARY_RECIPIENT_TYPE	VARCHAR2	(30)		Secondary Recipient Type
SECONDARY_RECIPIENT_NAME	VARCHAR2	(30)		Secondary Recipient Name
PRIORITY_NUM	NUMBER			Priority
DAYS_PRIOR_NUM	NUMBER			Days Prior
ACTIVE_FOR_NUM	NUMBER			Active For
LOAN_TYPE_ID	NUMBER	(15)		Loan Type Id
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column

Query Text

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


SELECT EVENT_ACTION_ID
,      EVENT_ID
,      EVENT_ACTION_NAME
,      DESCRIPTION
,      DELIVERY_METHOD
,      LOAN_TYPE
,      ACTION_TYPE
,      ENABLED_FLAG
,      API_NAME
,      NOTIFICATION_TYPE
,      SETUP_TYPE
,      PRIMARY_RECIPIENT_TYPE
,      PRIMARY_RECIPIENT_NAME
,      SECONDARY_RECIPIENT_TYPE
,      SECONDARY_RECIPIENT_NAME
,      PRIORITY_NUM
,      DAYS_PRIOR_NUM
,      ACTIVE_FOR_NUM
,      LOAN_TYPE_ID
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM LNS.LNS_EVENT_ACTIONS;

Dependencies

[top of page]

LNS.LNS_EVENT_ACTIONS does not reference any database object

LNS.LNS_EVENT_ACTIONS is referenced by following:

APPS: LNS_EVENT_ACTIONS