DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IEX_LOAN_SUMMARY_V

Object Details
Object Name: IEX_LOAN_SUMMARY_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.IEX_LOAN_SUMMARY_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.IEX_LOAN_SUMMARY_V is not referenced by any database object