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]

TABLE: APPS.LNS_LOAN_DTLS_ALL_MV

Object Details

Object Name:	LNS_LOAN_DTLS_ALL_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	LNS.LNS_LOAN_DTLS_ALL_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
LNS_LOAN_DTLS_ALL_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	LOAN_ID
LNS_LOAN_DTLS_ALL_MV_N10	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_SUMMARY	UPPER("LOAN_DESCRIPTION")
LNS_LOAN_DTLS_ALL_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORG_ID
LNS_LOAN_DTLS_ALL_MV_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	LOAN_CURRENCY
LNS_LOAN_DTLS_ALL_MV_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PRIMARY_STATUS_MEANING
LNS_LOAN_DTLS_ALL_MV_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	LOAN_STATUS
LNS_LOAN_DTLS_ALL_MV_N6	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	LOAN_TYPE_ID
LNS_LOAN_DTLS_ALL_MV_N7	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PRODUCT_ID
LNS_LOAN_DTLS_ALL_MV_N8	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	LEGAL_ENTITY_ID
LNS_LOAN_DTLS_ALL_MV_N9	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_SUMMARY	UPPER("LOAN_NUMBER")

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 does not reference any database object

APPS.LNS_LOAN_DTLS_ALL_MV is referenced by following:

APPS: LNS_LOAN_DTLS_ALL_MV