[Home] [Help] [Dependency Information]
Object Name: | LNS_FUNDING_ADVICES |
---|---|
Object Type: | TABLE |
Owner: | LNS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
LNS_FUNDING_ADVICES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FUNDING_ADVICE_ID |
LNS_FUNDING_ADVICES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LOAN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FUNDING_ADVICE_ID | NUMBER | (15) | Yes | |
LOAN_ID | NUMBER | (15) | Yes | |
ADVICE_NUMBER | VARCHAR2 | (60) | ||
SUBMISSION_DATE | DATE | |||
AMOUNT | NUMBER | |||
CURRENCY | VARCHAR2 | (15) | ||
DESCRIPTION | VARCHAR2 | (255) | ||
DUE_DATE | DATE | |||
INVOICE_ID | NUMBER | (15) | ||
INVOICE_NUMBER | VARCHAR2 | (50) | ||
PAYMENT_METHOD | VARCHAR2 | (30) | ||
STATUS | VARCHAR2 | (30) | ||
PAYEE_ID | NUMBER | (15) | ||
PAYEE_SITE_ID | NUMBER | (15) | ||
SITE_CONTACT_ID | NUMBER | (15) | ||
BANK_BRANCH_ID | NUMBER | (15) | ||
BANK_ACCOUNT_ID | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
REQUEST_ID | NUMBER | |||
AUTOFUNDING_FLAG | VARCHAR2 | (1) | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
FUNDING_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT FUNDING_ADVICE_ID
, LOAN_ID
, ADVICE_NUMBER
, SUBMISSION_DATE
, AMOUNT
, CURRENCY
, DESCRIPTION
, DUE_DATE
, INVOICE_ID
, INVOICE_NUMBER
, PAYMENT_METHOD
, STATUS
, PAYEE_ID
, PAYEE_SITE_ID
, SITE_CONTACT_ID
, BANK_BRANCH_ID
, BANK_ACCOUNT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, REQUEST_ID
, AUTOFUNDING_FLAG
, OBJECT_VERSION_NUMBER
, FUNDING_DATE
FROM LNS.LNS_FUNDING_ADVICES;
LNS.LNS_FUNDING_ADVICES does not reference any database object
LNS.LNS_FUNDING_ADVICES is referenced by following:
|
|
|