eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

MATERIALIZED VIEW: APPS.LNS_LOAN_DTLS_ALL_MV

Object Details

Object Name:	LNS_LOAN_DTLS_ALL_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	LNS_LOAN_DTLS_ALL_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	NONE
Refresh Mode:	DEMAND
Refresh Method:	COMPLETE
Build Mode:	DEFERRED
Fast Refreshable:	NO

MV Log Dependencies:


LNS_LOAN_PRODUCTS_ALL

[View Source Query]

Columns

Name	Datatype	Length	Mandatory
LOAN_ID	NUMBER	(15)	Yes
LOAN_NUMBER	VARCHAR2	(60)	Yes
LOAN_DESCRIPTION	VARCHAR2	(250)
TOTAL_PRINCIPAL_BALANCE	NUMBER
PRIMARY_BORROWER_ID	NUMBER	(15)
PARTY_NAME	VARCHAR2	(360)	Yes
LOAN_STATUS_MEANING	VARCHAR2	(162)
DETAIL_VIEW_FLAG	CHAR	(1)
INITIAL_LOAN_BALANCE	NUMBER		Yes
TERM_PERIOD	VARCHAR2	(121)
ADDRESS	VARCHAR2	(963)
CITY_COUNTY	VARCHAR2	(121)
STATE	VARCHAR2	(60)
POSTAL_CODE	VARCHAR2	(60)
TAX_REFERENCE	VARCHAR2	(20)
PRODUCT_ID	NUMBER	(15)
RATE	VARCHAR2	(41)
RATE_TYPE	VARCHAR2	(80)	Yes
CONTACT_PHONE_NUMBER	VARCHAR2	(60)
SELECT_LOAN_ROW	CHAR	(1)
CONTACT_PERSON_NAME	VARCHAR2	(360)
LOAN_TYPE	VARCHAR2	(30)
LOAN_CLASS_CODE	VARCHAR2	(30)
CREATION_DATE	DATE		Yes
LOAN_MATURITY_DATE	DATE
LOAN_START_DATE	DATE		Yes
LOAN_CURRENCY	VARCHAR2	(15)	Yes
REQUESTED_AMOUNT	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
END_DATE	DATE
DELETE_SWITCHER	VARCHAR2	(14)
LOAN_STATUS	VARCHAR2	(30)	Yes
TERM_ID	NUMBER	(15)	Yes
LOAN_APPROVAL_DATE	DATE
LOAN_CLASS_MEANING	VARCHAR2	(80)	Yes
LOAN_TYPE_MEANING	VARCHAR2	(80)	Yes
UPDATE_SWITCHER	VARCHAR2	(14)
LOAN_AGENT_ID	NUMBER		Yes
LOAN_AGENT_NAME	VARCHAR2	(360)
LOAN_AGENT_USER_ID	NUMBER
LOAN_MAX_LAST_UPDATE_DATE	DATE		Yes
FUNDING_ADVICE_SUBMITTED_DATE	DATE
LEGAL_ENTITY_ID	NUMBER	(15)
LEGAL_ENTITY_NAME	VARCHAR2	(240)	Yes
OPERATING_UNIT_NAME	VARCHAR2	(240)	Yes
LOAN_TYPE_ID	NUMBER	(15)
SECONDARY_STATUS	VARCHAR2	(30)
LOAN_PRODUCT_NAME	VARCHAR2	(80)
PRIMARY_STATUS_MEANING	VARCHAR2	(80)	Yes
SECONDARY_STATUS_MEANING	VARCHAR2	(80)
ORG_ID	NUMBER	(15)	Yes
LOAN_PRODUCT_ID	NUMBER	(15)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOAN_ID
,      LOAN_NUMBER
,      LOAN_DESCRIPTION
,      TOTAL_PRINCIPAL_BALANCE
,      PRIMARY_BORROWER_ID
,      PARTY_NAME
,      LOAN_STATUS_MEANING
,      DETAIL_VIEW_FLAG
,      INITIAL_LOAN_BALANCE
,      TERM_PERIOD
,      ADDRESS
,      CITY_COUNTY
,      STATE
,      POSTAL_CODE
,      TAX_REFERENCE
,      PRODUCT_ID
,      RATE
,      RATE_TYPE
,      CONTACT_PHONE_NUMBER
,      SELECT_LOAN_ROW
,      CONTACT_PERSON_NAME
,      LOAN_TYPE
,      LOAN_CLASS_CODE
,      CREATION_DATE
,      LOAN_MATURITY_DATE
,      LOAN_START_DATE
,      LOAN_CURRENCY
,      REQUESTED_AMOUNT
,      LAST_UPDATE_DATE
,      END_DATE
,      DELETE_SWITCHER
,      LOAN_STATUS
,      TERM_ID
,      LOAN_APPROVAL_DATE
,      LOAN_CLASS_MEANING
,      LOAN_TYPE_MEANING
,      UPDATE_SWITCHER
,      LOAN_AGENT_ID
,      LOAN_AGENT_NAME
,      LOAN_AGENT_USER_ID
,      LOAN_MAX_LAST_UPDATE_DATE
,      FUNDING_ADVICE_SUBMITTED_DATE
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      OPERATING_UNIT_NAME
,      LOAN_TYPE_ID
,      SECONDARY_STATUS
,      LOAN_PRODUCT_NAME
,      PRIMARY_STATUS_MEANING
,      SECONDARY_STATUS_MEANING
,      ORG_ID
,      LOAN_PRODUCT_ID
FROM APPS.LNS_LOAN_DTLS_ALL_MV;

Dependencies

[top of page]

APPS.LNS_LOAN_DTLS_ALL_MV references the following:

APPLSYS: FND_LOOKUP_VALUES
APPS: AR_PAYMENT_SCHEDULES_ALL; FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES; HR_ALL_ORGANIZATION_UNITS_TL; HZ_CONTACT_POINTS; HZ_CUST_ACCT_SITES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; JTF_RS_RESOURCE_EXTNS; LNS_AMORTIZATION_SCHEDS; LNS_DISB_HEADERS; LNS_LOAN_DTLS_ALL_MV; LNS_LOAN_HEADERS_ALL; LNS_LOAN_PRODUCTS_ALL; LNS_LOAN_TYPES; LNS_LOOKUPS; LNS_RATE_SCHEDULES; LNS_TERMS; XLE_ENTITY_PROFILES
AR: AR_PAYMENT_SCHEDULES_ALL; HZ_CONTACT_POINTS; HZ_CUST_ACCT_SITES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES
HR: HR_ALL_ORGANIZATION_UNITS_TL
JTF: JTF_RS_RESOURCE_EXTNS
LNS: LNS_AMORTIZATION_SCHEDS; LNS_DISB_HEADERS; LNS_LOAN_HEADERS_ALL; LNS_LOAN_PRODUCTS_ALL; LNS_LOAN_TYPES; LNS_RATE_SCHEDULES; LNS_TERMS
XLE: XLE_ENTITY_PROFILES

APPS.LNS_LOAN_DTLS_ALL_MV is not referenced by any database object