Skip to content

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

VIEW: LNS.LNS_LOAN_HEADERS_ALL#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOAN_ID NUMBER (15) Yes
LOAN_NUMBER VARCHAR2 (60) Yes
LOAN_DESCRIPTION VARCHAR2 (250)
INITIAL_LOAN_BALANCE NUMBER
Yes
LAST_PAYMENT_DATE DATE

LAST_PAYMENT_AMOUNT NUMBER

LOAN_TERM NUMBER
Yes
LOAN_TERM_PERIOD VARCHAR2 (30) Yes
LOAN_CURRENCY VARCHAR2 (15) Yes
LOAN_CLASS_CODE VARCHAR2 (30)
LOAN_TYPE VARCHAR2 (30)
LOAN_SUBTYPE VARCHAR2 (30)
LOAN_PURPOSE_CODE VARCHAR2 (30)
AMORTIZED_TERM NUMBER

AMORTIZED_TERM_PERIOD VARCHAR2 (30)
LOAN_MATURITY_DATE DATE

LOAN_START_DATE DATE
Yes
LOAN_APPLICATION_DATE DATE
Yes
LOAN_CLOSING_DATE DATE

LAST_BILLED_DATE DATE

END_DATE DATE

PRODUCT_FLAG VARCHAR2 (1)
CUST_ACCOUNT_ID NUMBER (15)
PRIMARY_BORROWER_ID NUMBER (15)
PRODUCT_ID NUMBER (15)
REQUESTED_AMOUNT NUMBER
Yes
FUNDED_AMOUNT NUMBER

REFERENCE_AMOUNT NUMBER

REFERENCE_NUMBER VARCHAR2 (60)
REFERENCE_NAME VARCHAR2 (60)
REFERENCE_TYPE VARCHAR2 (30)
REFERENCE_DESCRIPTION VARCHAR2 (250)
LOAN_APPROVAL_DATE DATE

LOAN_APPROVED_BY NUMBER

LOAN_STATUS VARCHAR2 (30) Yes
LOAN_ASSIGNED_TO NUMBER

REFERENCE_ID NUMBER (15)
CUSTOM_PAYMENTS_FLAG VARCHAR2 (1)
BILLED_FLAG VARCHAR2 (1)
ORG_ID NUMBER (15) Yes
USSGL_TRANSACTION_CODE VARCHAR2 (30)
REQUEST_ID NUMBER (15)
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
PROGRAM_ID NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER
Yes
GL_DATE DATE

REFERENCE_TYPE_ID NUMBER (15)
BILL_TO_ACCT_SITE_ID NUMBER (15)
REC_ADJUSTMENT_NUMBER VARCHAR2 (20)
CONTACT_PERS_PARTY_ID NUMBER (15)
CONTACT_REL_PARTY_ID NUMBER (15)
COLLATERAL_PERCENT NUMBER

CREDIT_REVIEW_FLAG VARCHAR2 (1)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
EXCHANGE_DATE DATE

EXCHANGE_RATE NUMBER

LAST_PAYMENT_NUMBER NUMBER

LAST_AMORTIZATION_ID NUMBER

OPEN_TO_TERM_FLAG VARCHAR2 (1)
MULTIPLE_FUNDING_FLAG VARCHAR2 (1)
LOAN_TYPE_ID NUMBER (15)
SECONDARY_STATUS VARCHAR2 (30)
OPEN_TO_TERM_EVENT VARCHAR2 (30)
BALLOON_PAYMENT_TYPE VARCHAR2 (30)
BALLOON_PAYMENT_AMOUNT NUMBER

OPEN_LOAN_START_DATE DATE

OPEN_LOAN_TERM NUMBER

OPEN_LOAN_TERM_PERIOD VARCHAR2 (30)
CURRENT_PHASE VARCHAR2 (30)
OPEN_MATURITY_DATE DATE

FUNDS_RESERVED_FLAG VARCHAR2 (1)
FUNDS_CHECK_DATE DATE

SUBSIDY_RATE NUMBER

APPLICATION_ID NUMBER (15)
CREATED_BY_MODULE VARCHAR2 (150)
PARTY_TYPE VARCHAR2 (30)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
FORGIVENESS_FLAG VARCHAR2 (1)
FORGIVENESS_PERCENT NUMBER

DISABLE_BILLING_FLAG VARCHAR2 (1)
ADD_REQUESTED_AMOUNT NUMBER

DISABLE_INT_ACCRUAL_FLAG VARCHAR2 (1)
BILL_ON_APPR_AMOUNT_FLAG VARCHAR2 (1)
Query Text

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


SELECT LOAN_ID
,      LOAN_NUMBER
,      LOAN_DESCRIPTION
,      INITIAL_LOAN_BALANCE
,      LAST_PAYMENT_DATE
,      LAST_PAYMENT_AMOUNT
,      LOAN_TERM
,      LOAN_TERM_PERIOD
,      LOAN_CURRENCY
,      LOAN_CLASS_CODE
,      LOAN_TYPE
,      LOAN_SUBTYPE
,      LOAN_PURPOSE_CODE
,      AMORTIZED_TERM
,      AMORTIZED_TERM_PERIOD
,      LOAN_MATURITY_DATE
,      LOAN_START_DATE
,      LOAN_APPLICATION_DATE
,      LOAN_CLOSING_DATE
,      LAST_BILLED_DATE
,      END_DATE
,      PRODUCT_FLAG
,      CUST_ACCOUNT_ID
,      PRIMARY_BORROWER_ID
,      PRODUCT_ID
,      REQUESTED_AMOUNT
,      FUNDED_AMOUNT
,      REFERENCE_AMOUNT
,      REFERENCE_NUMBER
,      REFERENCE_NAME
,      REFERENCE_TYPE
,      REFERENCE_DESCRIPTION
,      LOAN_APPROVAL_DATE
,      LOAN_APPROVED_BY
,      LOAN_STATUS
,      LOAN_ASSIGNED_TO
,      REFERENCE_ID
,      CUSTOM_PAYMENTS_FLAG
,      BILLED_FLAG
,      ORG_ID
,      USSGL_TRANSACTION_CODE
,      REQUEST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PROGRAM_ID
,      OBJECT_VERSION_NUMBER
,      GL_DATE
,      REFERENCE_TYPE_ID
,      BILL_TO_ACCT_SITE_ID
,      REC_ADJUSTMENT_NUMBER
,      CONTACT_PERS_PARTY_ID
,      CONTACT_REL_PARTY_ID
,      COLLATERAL_PERCENT
,      CREDIT_REVIEW_FLAG
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      LAST_PAYMENT_NUMBER
,      LAST_AMORTIZATION_ID
,      LEGAL_ENTITY_ID
,      OPEN_TO_TERM_FLAG
,      MULTIPLE_FUNDING_FLAG
,      LOAN_TYPE_ID
,      SECONDARY_STATUS
,      OPEN_TO_TERM_EVENT
,      BALLOON_PAYMENT_TYPE
,      BALLOON_PAYMENT_AMOUNT
,      OPEN_LOAN_START_DATE
,      OPEN_LOAN_TERM
,      OPEN_LOAN_TERM_PERIOD
,      CURRENT_PHASE
,      OPEN_MATURITY_DATE
,      FUNDS_RESERVED_FLAG
,      FUNDS_CHECK_DATE
,      SUBSIDY_RATE
,      APPLICATION_ID
,      CREATED_BY_MODULE
,      PARTY_TYPE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      FORGIVENESS_FLAG
,      FORGIVENESS_PERCENT
,      DISABLE_BILLING_FLAG
,      ADD_REQUESTED_AMOUNT
,      DISABLE_INT_ACCRUAL_FLAG
,      BILL_ON_APPR_AMOUNT_FLAG
FROM LNS.LNS_LOAN_HEADERS_ALL#;

Dependencies

[top of page]

LNS.LNS_LOAN_HEADERS_ALL# references the following:

SchemaLNS
TableLNS_LOAN_HEADERS_ALL
LNS.LNS_LOAN_HEADERS_ALL# is referenced by following:

SchemaAPPS
SynonymLNS_LOAN_HEADERS
SynonymLNS_LOAN_HEADERS_ALL