[Home] [Help] [Dependency Information]
Object Name: | LNS_LOAN_HISTORIES_H |
---|---|
Object Type: | TABLE |
Owner: | LNS |
FND Design Data: | LNS.LNS_LOAN_HISTORIES_H |
Subobject Name: | |
Status: | VALID |
LNS_LOAN_HISTORIES_H logs the activities that has happened to a loan. Upon updating the loan, both the old value and new value are stored into this table, as well as the affected table name and column.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
LNS_LOAN_HISTORIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LOAN_HISTORY_ID |
LNS_LOAN_HISTORIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LOAN_ID
TABLE_NAME COLUMN_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOAN_HISTORY_ID | NUMBER | (15) | Yes | Loan History Id |
LOAN_ID | NUMBER | (15) | Loan Id | |
TABLE_NAME | VARCHAR2 | (50) | Name of table | |
COLUMN_NAME | VARCHAR2 | (50) | Name of column | |
OLD_VALUE | VARCHAR2 | (250) | Original value before update | |
NEW_VALUE | VARCHAR2 | (250) | New value after update | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
DATA_TYPE | VARCHAR2 | (106) | Datatype of column | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object Version Number | |
PRIMARY_KEY_ID | NUMBER | (15) | Primary Key ID |
Cut, paste (and edit) the following text to query this object:
SELECT LOAN_HISTORY_ID
, LOAN_ID
, TABLE_NAME
, COLUMN_NAME
, OLD_VALUE
, NEW_VALUE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DATA_TYPE
, OBJECT_VERSION_NUMBER
, PRIMARY_KEY_ID
FROM LNS.LNS_LOAN_HISTORIES_H;
LNS.LNS_LOAN_HISTORIES_H does not reference any database object
LNS.LNS_LOAN_HISTORIES_H is referenced by following:
|
|
|