[Home] [Help] [Dependency Information]
Object Name: | LNS_LOAN_INFO |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | LNS.LNS_LOAN_INFO |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOAN_ID | NUMBER | (15) | Loan identifier | |
CUSTOMER_NAME | VARCHAR2 | (360) | customer name | |
CUSTOMER_NUMBER | VARCHAR2 | (30) | customer number | |
LOAN_NUMBER | VARCHAR2 | (60) | loan number | |
LOAN_START_DATE | DATE | start date | ||
FUNDED_AMOUNT | NUMBER | funded amount | ||
LOAN_STATUS | VARCHAR2 | (4000) | loan status | |
LOAN_CLASS | VARCHAR2 | (4000) | loan class | |
LOAN_TYPE | VARCHAR2 | (80) | loan type | |
DISB_HEADER_ID | NUMBER | Disbursement Header ID | ||
DISBURSEMENT_STATUS | VARCHAR2 | (4000) | Disbursement Status | |
DISBURSEMENT_NUMBER | NUMBER | Disbursement Number | ||
DISBURSEMENT_REQUEST_DATE | DATE | Disbursement Request Date | ||
LOAN_AMOUNT_ADJ_ID | NUMBER | Loan Amount Adjustment Id | ||
LOAN_ADJUSTMENT_DESCRIPTION | VARCHAR2 | (250) | Loan Adjustment Description | |
LOAN_LINE_ID | NUMBER | ERS Loan Additional Receivable Line Id | ||
REFERENCE_DESCRIPTION | VARCHAR2 | (250) | ERS Loan Additional Receivable Line Description |
Cut, paste (and edit) the following text to query this object:
SELECT LOAN_ID
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, LOAN_NUMBER
, LOAN_START_DATE
, FUNDED_AMOUNT
, LOAN_STATUS
, LOAN_CLASS
, LOAN_TYPE
, DISB_HEADER_ID
, DISBURSEMENT_STATUS
, DISBURSEMENT_NUMBER
, DISBURSEMENT_REQUEST_DATE
, LOAN_AMOUNT_ADJ_ID
, LOAN_ADJUSTMENT_DESCRIPTION
, LOAN_LINE_ID
, REFERENCE_DESCRIPTION
FROM APPS.LNS_LOAN_INFO;
APPS.LNS_LOAN_INFO is not referenced by any database object
|
|
|