[Home] [Help] [Dependency Information]
Object Name: | IEX_LOAN_SUMMARY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
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 | VARCHAR2 | (0) | Loan ID | |
LOAN_NUMBER | VARCHAR2 | (0) | Loan Number | |
LOAN_STATUS | VARCHAR2 | (0) | Loan info | |
LOAN_CURRENCY_CODE | VARCHAR2 | (0) | Loan info | |
LOAN_CURRENCY_MEANING | VARCHAR2 | (0) | Loan info | |
LOAN_TYPE | VARCHAR2 | (0) | Loan info | |
LOAN_CLASS | VARCHAR2 | (0) | Loan info | |
LOAN_SUBTYPE | VARCHAR2 | (0) | Loan info | |
LOAN_PRODUCT | VARCHAR2 | (0) | Loan info | |
LOAN_DESCRIPTION | VARCHAR2 | (0) | Loan info | |
LOAN_PURPOSE | VARCHAR2 | (0) | Loan info | |
REQUESTED_AMOUNT | VARCHAR2 | (0) | Loan info | |
FUNDED_AMOUNT | VARCHAR2 | (0) | Loan info | |
CREATION_DATE | VARCHAR2 | (0) | Loan info | |
LOAN_APPLICATION_DATE | VARCHAR2 | (0) | Loan info | |
LOAN_APPROVAL_DATE | VARCHAR2 | (0) | Loan info | |
LOAN_START_DATE | VARCHAR2 | (0) | Loan info | |
LOAN_MATURITY_DATE | VARCHAR2 | (0) | Loan info | |
LOAN_CLOSING_DATE | VARCHAR2 | (0) | Loan info | |
CURRENT_INTEREST_RATE | VARCHAR2 | (0) | Loan info | |
LOAN_TERM | VARCHAR2 | (0) | Loan info | |
LOAN_TERM_PERIOD | VARCHAR2 | (0) | Loan info | |
LOAN_AMORTIZED_TERM | VARCHAR2 | (0) | Loan info | |
LOAN_AMORTIZED_TERM_PERIOD | VARCHAR2 | (0) | Loan info | |
REFERENCE_ID | VARCHAR2 | (0) | Loan info | |
REFERENCE_TYPE | VARCHAR2 | (0) | Loan info | |
REFERENCE_NUMBER | VARCHAR2 | (0) | Loan info | |
REFERENCE_DESCRIPTION | VARCHAR2 | (0) | Loan info | |
REFERENCE_TYPE_ID | VARCHAR2 | (0) | Loan info | |
PRIMARY_BORROWER_ID | VARCHAR2 | (0) | Loan info | |
CUST_ACCOUNT_ID | VARCHAR2 | (0) | Loan info | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE1 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE2 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE3 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE4 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE5 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE6 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE7 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE8 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE9 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE10 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE11 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE12 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE13 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE14 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE15 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE16 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE17 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE18 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE19 | VARCHAR2 | (0) | Loan Attribute | |
ATTRIBUTE20 | VARCHAR2 | (0) | Loan Attribute | |
TOTAL_PRINCIPAL_BALANCE | VARCHAR2 | (0) | Loan info | |
NEXT_PAYMENT_DUE_DATE | VARCHAR2 | (0) | Loan info | |
NEXT_PAYMENT_TOTAL_DUE | VARCHAR2 | (0) | Loan info | |
TOTAL_OVERDUE | VARCHAR2 | (0) | Loan info | |
LAST_OVERDUE_DATE | VARCHAR2 | (0) | Loan info | |
LAST_PAYMENT_AMOUNT | VARCHAR2 | (0) | Loan info | |
LAST_PAYMENT_DATE | VARCHAR2 | (0) | Loan info |
Cut, paste (and edit) the following text to query this object:
SELECT LOAN_ID
, LOAN_NUMBER
, LOAN_STATUS
, LOAN_CURRENCY_CODE
, LOAN_CURRENCY_MEANING
, LOAN_TYPE
, LOAN_CLASS
, LOAN_SUBTYPE
, LOAN_PRODUCT
, LOAN_DESCRIPTION
, LOAN_PURPOSE
, REQUESTED_AMOUNT
, FUNDED_AMOUNT
, CREATION_DATE
, LOAN_APPLICATION_DATE
, LOAN_APPROVAL_DATE
, LOAN_START_DATE
, LOAN_MATURITY_DATE
, LOAN_CLOSING_DATE
, CURRENT_INTEREST_RATE
, LOAN_TERM
, LOAN_TERM_PERIOD
, LOAN_AMORTIZED_TERM
, LOAN_AMORTIZED_TERM_PERIOD
, REFERENCE_ID
, REFERENCE_TYPE
, REFERENCE_NUMBER
, REFERENCE_DESCRIPTION
, REFERENCE_TYPE_ID
, PRIMARY_BORROWER_ID
, CUST_ACCOUNT_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, TOTAL_PRINCIPAL_BALANCE
, NEXT_PAYMENT_DUE_DATE
, NEXT_PAYMENT_TOTAL_DUE
, TOTAL_OVERDUE
, LAST_OVERDUE_DATE
, LAST_PAYMENT_AMOUNT
, LAST_PAYMENT_DATE
FROM APPS.IEX_LOAN_SUMMARY_V;
APPS.IEX_LOAN_SUMMARY_V is not referenced by any database object
|
|
|