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

TABLE: LNS.LNS_EVT_ACTION_HISTORY_H

Object Details
Object Name: LNS_EVT_ACTION_HISTORY_H
Object Type: TABLE
Owner: LNS
FND Design Data: TableLNS.LNS_EVT_ACTION_HISTORY_H
Subobject Name:
Status: VALID


This table stores the information about workflow actions performed for a Loan event


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
LNS_EVT_ACTION_HISTORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_ACTION_HISTORY_ID
Columns
Name Datatype Length Mandatory Comments
EVENT_ACTION_HISTORY_ID NUMBER (15) Yes Event Action History Id
EVENT_ACTION_ID NUMBER (15) Yes Event Action Id
LOAN_ID NUMBER (15) Yes Loan Id
WF_ITEMKEY VARCHAR2 (240)
Workflow Itemkey
WF_ITEMTYPE VARCHAR2 (240)
Workflow Itemvalue
ACTIVITY_DATE DATE
Yes Date of Activity
CONCURRENT_REQUEST_ID NUMBER (15)
Concurrent Request Id
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
PROGRAM_UPDATE_DATE DATE

Extended Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Extended Who column
PROGRAM_ID NUMBER (15)
Extended Who column
REQUEST_ID NUMBER (15)
Extended Who column
Query Text

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


SELECT EVENT_ACTION_HISTORY_ID
,      EVENT_ACTION_ID
,      LOAN_ID
,      WF_ITEMKEY
,      WF_ITEMTYPE
,      ACTIVITY_DATE
,      CONCURRENT_REQUEST_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
FROM LNS.LNS_EVT_ACTION_HISTORY_H;

Dependencies

[top of page]

LNS.LNS_EVT_ACTION_HISTORY_H does not reference any database object

LNS.LNS_EVT_ACTION_HISTORY_H is referenced by following:

SchemaLNS
ViewLNS_EVT_ACTION_HISTORY_H#