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

TABLE: LNS.LNS_LOAN_AMOUNT_ADJS

Object Details
Object Name: LNS_LOAN_AMOUNT_ADJS
Object Type: TABLE
Owner: LNS
Subobject Name:
Status: VALID


Table contains adjustment details of a loan


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LOAN_AMOUNT_ADJ_ID NUMBER (15) Yes Uniquely Identifies the Loan Adjustment
LOAN_ID NUMBER (15) Yes Identifies the Loan
DESCRIPTION VARCHAR2 (250)
Description about the adjustment
ADJUSTMENT_AMOUNT NUMBER

Loan Adjustment Amount
STATUS VARCHAR2 (30)
Identifies the Loan Adjustment Status
APPR_REJECT_DATE DATE

Date on which the adjustment was approved or rejected
APPR_REJECT_BY NUMBER

Identifies the user who approved or rejected the adjustment
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
CREATION_DATE DATE
Yes Loan Adjustment Creation Date
CREATED_BY NUMBER (15) Yes Identifies the user who created loan adjustment
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATED_BY NUMBER (15) Yes Last Updated By
LAST_UPDATE_LOGIN NUMBER (15) Yes Last Update Login
END_DATE DATE

End date of loan adjustment
EFFECTIVE_DATE DATE

The date from which the adjustment becomes effective
FUNDS_RESERVED_FLAG VARCHAR2 (1)
Identifies whether the funds are reserved for this loan adjustment
Query Text

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


SELECT LOAN_AMOUNT_ADJ_ID
,      LOAN_ID
,      DESCRIPTION
,      ADJUSTMENT_AMOUNT
,      STATUS
,      APPR_REJECT_DATE
,      APPR_REJECT_BY
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      END_DATE
,      EFFECTIVE_DATE
,      FUNDS_RESERVED_FLAG
FROM LNS.LNS_LOAN_AMOUNT_ADJS;

Dependencies

[top of page]

LNS.LNS_LOAN_AMOUNT_ADJS does not reference any database object

LNS.LNS_LOAN_AMOUNT_ADJS is referenced by following:

SchemaLNS
ViewLNS_LOAN_AMOUNT_ADJS#