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

VIEW: LNS.LNS_LOAN_CANCEL_DETAILS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOAN_CANCEL_DETAIL_ID NUMBER (15) Yes
LOAN_CANCELLATION_ID NUMBER (15) Yes
LOAN_ID NUMBER (15) Yes
PURPOSE_CODE VARCHAR2 (30)
PURPOSE_DESC VARCHAR2 (256)
AMOUNT_DUE NUMBER

PERCENT_TO_PROCESS NUMBER

AMOUNT_TO_PROCESS NUMBER

DUE_DATE DATE

BILLED_FLAG VARCHAR2 (1)
ACTION VARCHAR2 (30)
LOAN_LINE_ID NUMBER

PAYMENT_SCHEDULE_ID NUMBER

CUST_TRX_ID NUMBER

ADJUSTMENT_NUMBER VARCHAR2 (20)
ADJUSTMENT_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
INVOICE_NUMBER VARCHAR2 (60)
INSTALLMENT_NUMBER NUMBER

TRANSACTION_TYPE VARCHAR2 (100)
GL_DATE DATE

TRX_DATE DATE

Query Text

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


SELECT LOAN_CANCEL_DETAIL_ID
,      LOAN_CANCELLATION_ID
,      LOAN_ID
,      PURPOSE_CODE
,      PURPOSE_DESC
,      AMOUNT_DUE
,      PERCENT_TO_PROCESS
,      AMOUNT_TO_PROCESS
,      DUE_DATE
,      BILLED_FLAG
,      ACTION
,      LOAN_LINE_ID
,      PAYMENT_SCHEDULE_ID
,      CUST_TRX_ID
,      ADJUSTMENT_NUMBER
,      ADJUSTMENT_ID
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      INVOICE_NUMBER
,      INSTALLMENT_NUMBER
,      TRANSACTION_TYPE
,      GL_DATE
,      TRX_DATE
FROM LNS.LNS_LOAN_CANCEL_DETAILS#;

Dependencies

[top of page]

LNS.LNS_LOAN_CANCEL_DETAILS# references the following:

SchemaLNS
TableLNS_LOAN_CANCEL_DETAILS
LNS.LNS_LOAN_CANCEL_DETAILS# is referenced by following:

SchemaAPPS
SynonymLNS_LOAN_CANCEL_DETAILS