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

VIEW: LNS.LNS_LOAN_LINES#

Object Details
Object Name: LNS_LOAN_LINES#
Object Type: VIEW
Owner: LNS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOAN_LINE_ID NUMBER (15) Yes
LOAN_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
OBJECT_VERSION_NUMBER NUMBER
Yes
REFERENCE_TYPE VARCHAR2 (30)
REFERENCE_ID NUMBER (15)
REFERENCE_NUMBER VARCHAR2 (60)
REFERENCE_DESCRIPTION VARCHAR2 (250)
REFERENCE_AMOUNT NUMBER

REQUESTED_AMOUNT NUMBER
Yes
REC_ADJUSTMENT_NUMBER VARCHAR2 (20)
REC_ADJUSTMENT_ID NUMBER (15)
PAYMENT_SCHEDULE_ID NUMBER (15)
INSTALLMENT_NUMBER NUMBER (15)
END_DATE DATE

STATUS VARCHAR2 (30)
APPR_REJECT_DATE DATE

APPR_REJECT_BY NUMBER

ADJUSTMENT_DATE DATE

ORIGINAL_FLAG VARCHAR2 (1)
Query Text

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


SELECT LOAN_LINE_ID
,      LOAN_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      OBJECT_VERSION_NUMBER
,      REFERENCE_TYPE
,      REFERENCE_ID
,      REFERENCE_NUMBER
,      REFERENCE_DESCRIPTION
,      REFERENCE_AMOUNT
,      REQUESTED_AMOUNT
,      REC_ADJUSTMENT_NUMBER
,      REC_ADJUSTMENT_ID
,      PAYMENT_SCHEDULE_ID
,      INSTALLMENT_NUMBER
,      END_DATE
,      STATUS
,      APPR_REJECT_DATE
,      APPR_REJECT_BY
,      ADJUSTMENT_DATE
,      ORIGINAL_FLAG
FROM LNS.LNS_LOAN_LINES#;

Dependencies

[top of page]

LNS.LNS_LOAN_LINES# references the following:

SchemaLNS
TableLNS_LOAN_LINES
LNS.LNS_LOAN_LINES# is referenced by following:

SchemaAPPS
SynonymLNS_LOAN_LINES