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

VIEW: LNS.LNS_FEE_ASSIGNMENTS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
FEE_ASSIGNMENT_ID NUMBER (15) Yes
LOAN_ID NUMBER (15)
FEE_ID NUMBER (15) Yes
FEE_TYPE VARCHAR2 (30)
FEE NUMBER

FEE_BASIS VARCHAR2 (30)
NUMBER_GRACE_DAYS NUMBER

CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER
Yes
COLLECTED_THIRD_PARTY_FLAG VARCHAR2 (1)
BILLING_OPTION VARCHAR2 (30)
RATE_TYPE VARCHAR2 (30)
BEGIN_INSTALLMENT_NUMBER NUMBER

END_INSTALLMENT_NUMBER NUMBER

NUMBER_OF_PAYMENTS NUMBER

START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

DISB_HEADER_ID NUMBER (15)
OPEN_PHASE_FLAG VARCHAR2 (1)
DELETE_DISABLED_FLAG VARCHAR2 (1)
PHASE VARCHAR2 (30)
CUSTOM_PROCEDURE VARCHAR2 (250)
Query Text

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


SELECT FEE_ASSIGNMENT_ID
,      LOAN_ID
,      FEE_ID
,      FEE_TYPE
,      FEE
,      FEE_BASIS
,      NUMBER_GRACE_DAYS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      COLLECTED_THIRD_PARTY_FLAG
,      BILLING_OPTION
,      RATE_TYPE
,      BEGIN_INSTALLMENT_NUMBER
,      END_INSTALLMENT_NUMBER
,      NUMBER_OF_PAYMENTS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DISB_HEADER_ID
,      OPEN_PHASE_FLAG
,      DELETE_DISABLED_FLAG
,      PHASE
,      CUSTOM_PROCEDURE
FROM LNS.LNS_FEE_ASSIGNMENTS#;

Dependencies

[top of page]

LNS.LNS_FEE_ASSIGNMENTS# references the following:

SchemaLNS
TableLNS_FEE_ASSIGNMENTS
LNS.LNS_FEE_ASSIGNMENTS# is referenced by following:

SchemaAPPS
SynonymLNS_FEE_ASSIGNMENTS