[Home] [Help] [Dependency Information]
Object Name: | LNS_LOAN_DTLS_ALL_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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 |
LNS_LOAN_PRODUCTS_ALL
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
APPS.LNS_LOAN_DTLS_ALL_MV is not referenced by any database object
|
|
|