[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | LNS_LOAN_EXTENSIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | LNS |
| Subobject Name: | |
| Status: | VALID |
Table for Loan Term Extensions
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LOAN_EXT_ID | NUMBER | (15) | Yes | Identifies the Loan Extension |
| LOAN_ID | NUMBER | (15) | Yes | Identifies the loan |
| DESCRIPTION | VARCHAR2 | (30) | Description about loan extension | |
| OLD_TERM | NUMBER | Old term before applying extension | ||
| OLD_TERM_PERIOD | VARCHAR2 | (30) | Old term period before applying extension | |
| OLD_AMORT_TERM | NUMBER | Old balloon term before applying extension | ||
| OLD_MATURITY_DATE | DATE | Old maturity date before applying extension | ||
| OLD_INSTALLMENTS | NUMBER | Old number of installments before applying extension | ||
| EXT_TERM | NUMBER | Extension term | ||
| EXT_TERM_PERIOD | VARCHAR2 | (30) | Extension term period | |
| EXT_AMORT_TERM | NUMBER | Extension balloon term | ||
| EXT_RATE | NUMBER | Extension rate | ||
| EXT_SPREAD | NUMBER | Extension spread | ||
| EXT_IO_FLAG | VARCHAR2 | (1) | Extension interest only flag | |
| EXT_INDEX_DATE | DATE | Extension index date | ||
| NEW_TERM | NUMBER | New term after applying extension | ||
| NEW_TERM_PERIOD | VARCHAR2 | (30) | New term period after applying extension | |
| NEW_AMORT_TERM | NUMBER | New balloon term after applying extension | ||
| NEW_MATURITY_DATE | DATE | New maturity date after applying extension | ||
| NEW_INSTALLMENTS | NUMBER | New number of installments after applying extension | ||
| STATUS | VARCHAR2 | (30) | Yes | Status about extension request |
| APPR_REJECT_DATE | DATE | Date of extension getting approved or rejected | ||
| APPR_REJECT_BY | NUMBER | Extension approved or rejected by | ||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number | |
| CREATION_DATE | DATE | Yes | Extension creation date | |
| CREATED_BY | NUMBER | (15) | Yes | Extension created by |
| 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 | |
| LAST_BILLED_INSTALLMENT | NUMBER | Last billed installment | ||
| OLD_BALLOON_TYPE | VARCHAR2 | (30) | Balloon type before applying extension | |
| OLD_BALLOON_AMOUNT | NUMBER | Balloon amount before applying extension | ||
| EXT_BALLOON_TYPE | VARCHAR2 | (30) | Extension balloon type | |
| EXT_BALLOON_AMOUNT | NUMBER | Extension balloon amount | ||
| NEW_BALLOON_TYPE | VARCHAR2 | (30) | New balloon type after applying extension | |
| NEW_BALLOON_AMOUNT | NUMBER | New balloon amount after applying extension | ||
| EXT_FLOATING_FLAG | VARCHAR2 | (1) | Extension floating flag |
Cut, paste (and edit) the following text to query this object:
SELECT LOAN_EXT_ID
, LOAN_ID
, DESCRIPTION
, OLD_TERM
, OLD_TERM_PERIOD
, OLD_AMORT_TERM
, OLD_MATURITY_DATE
, OLD_INSTALLMENTS
, EXT_TERM
, EXT_TERM_PERIOD
, EXT_AMORT_TERM
, EXT_RATE
, EXT_SPREAD
, EXT_IO_FLAG
, EXT_INDEX_DATE
, NEW_TERM
, NEW_TERM_PERIOD
, NEW_AMORT_TERM
, NEW_MATURITY_DATE
, NEW_INSTALLMENTS
, STATUS
, APPR_REJECT_DATE
, APPR_REJECT_BY
, OBJECT_VERSION_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_BILLED_INSTALLMENT
, OLD_BALLOON_TYPE
, OLD_BALLOON_AMOUNT
, EXT_BALLOON_TYPE
, EXT_BALLOON_AMOUNT
, NEW_BALLOON_TYPE
, NEW_BALLOON_AMOUNT
, EXT_FLOATING_FLAG
FROM LNS.LNS_LOAN_EXTENSIONS;
LNS.LNS_LOAN_EXTENSIONS does not reference any database object
LNS.LNS_LOAN_EXTENSIONS is referenced by following:
LNS
LNS_LOAN_EXTENSIONS#
|
|
|
|