[Home] [Help] [Dependency Information]
Object Name: | LNS_LOAN_EXTENSIONS |
---|---|
Object Type: | TABLE |
Owner: | LNS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOAN_EXT_ID | NUMBER | (15) | Yes | |
LOAN_ID | NUMBER | (15) | Yes | |
DESCRIPTION | VARCHAR2 | (30) | ||
OLD_TERM | NUMBER | |||
OLD_TERM_PERIOD | VARCHAR2 | (30) | ||
OLD_AMORT_TERM | NUMBER | |||
OLD_MATURITY_DATE | DATE | |||
OLD_INSTALLMENTS | NUMBER | |||
EXT_TERM | NUMBER | |||
EXT_TERM_PERIOD | VARCHAR2 | (30) | ||
EXT_AMORT_TERM | NUMBER | |||
EXT_RATE | NUMBER | |||
EXT_SPREAD | NUMBER | |||
EXT_IO_FLAG | VARCHAR2 | (1) | ||
EXT_INDEX_DATE | DATE | |||
NEW_TERM | NUMBER | |||
NEW_TERM_PERIOD | VARCHAR2 | (30) | ||
NEW_AMORT_TERM | NUMBER | |||
NEW_MATURITY_DATE | DATE | |||
NEW_INSTALLMENTS | NUMBER | |||
STATUS | VARCHAR2 | (30) | Yes | |
APPR_REJECT_DATE | DATE | |||
APPR_REJECT_BY | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_BILLED_INSTALLMENT | NUMBER | |||
OLD_BALLOON_TYPE | VARCHAR2 | (30) | ||
OLD_BALLOON_AMOUNT | NUMBER | |||
EXT_BALLOON_TYPE | VARCHAR2 | (30) | ||
EXT_BALLOON_AMOUNT | NUMBER | |||
NEW_BALLOON_TYPE | VARCHAR2 | (30) | ||
NEW_BALLOON_AMOUNT | NUMBER | |||
EXT_FLOATING_FLAG | VARCHAR2 | (1) |
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:
|
|
|