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

VIEW: APPS.LNS_LOAN_INFO

Object Details
Object Name: LNS_LOAN_INFO
Object Type: VIEW
Owner: APPS
FND Design Data: ViewLNS.LNS_LOAN_INFO
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 NUMBER (15) Yes Loan identifier
CUSTOMER_NAME VARCHAR2 (360) Yes customer name
CUSTOMER_NUMBER VARCHAR2 (30) Yes customer number
LOAN_NUMBER VARCHAR2 (60) Yes loan number
LOAN_START_DATE DATE
Yes start date
FUNDED_AMOUNT NUMBER

funded amount
LOAN_STATUS VARCHAR2 (4000)
loan status
LOAN_CLASS VARCHAR2 (4000)
loan class
LOAN_TYPE VARCHAR2 (80)
loan type
DISB_HEADER_ID NUMBER

Disbursement Header ID
DISBURSEMENT_STATUS VARCHAR2 (4000)
Disbursement Status
DISBURSEMENT_NUMBER NUMBER

Disbursement Number
DISBURSEMENT_REQUEST_DATE DATE

Disbursement Request Date
Query Text

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


SELECT LOAN_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      LOAN_NUMBER
,      LOAN_START_DATE
,      FUNDED_AMOUNT
,      LOAN_STATUS
,      LOAN_CLASS
,      LOAN_TYPE
,      DISB_HEADER_ID
,      DISBURSEMENT_STATUS
,      DISBURSEMENT_NUMBER
,      DISBURSEMENT_REQUEST_DATE
FROM APPS.LNS_LOAN_INFO;

Dependencies

[top of page]

APPS.LNS_LOAN_INFO references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymLNS_DISB_HEADERS
SynonymLNS_LOAN_HEADERS_ALL
SynonymLNS_LOAN_TYPES
PL/SQL PackageLNS_UTILITY_PUB - show dependent code

APPS.LNS_LOAN_INFO is not referenced by any database object