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

VIEW: APPS.LNS_LOAN_HEADERS_EXT_V

Object Details
Object Name: LNS_LOAN_HEADERS_EXT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewLNS.LNS_LOAN_HEADERS_EXT_V
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
EVENT_ID NUMBER (15) Yes Event ID
LEDGER_ID NUMBER (15) Yes Ledger ID
LOAN_ID NUMBER (15) Yes Loan ID
LAST_UPDATE_DATE DATE
Yes Standard WHo Columns
LAST_UPDATED_BY NUMBER (15) Yes Standard WHo Columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHo Columns
CREATION_DATE DATE
Yes Standard WHo Columns
CREATED_BY NUMBER (15) Yes Standard WHo Columns
PROGRAM_ID NUMBER (15)
Standard WHo Columns
OBJECT_VERSION_NUMBER NUMBER
Yes Standard WHo Columns
REQUEST_ID NUMBER (15)
Standard WHo Columns
LOAN_NUMBER VARCHAR2 (60) Yes Loan Number
LOAN_DESCRIPTION VARCHAR2 (250)
Loan Description
INITIAL_LOAN_BALANCE NUMBER
Yes Loan Balance
LAST_PAYMENT_DATE DATE

Last Pay Date
LAST_PAYMENT_AMOUNT NUMBER

Last Pay Amount
LOAN_TERM NUMBER
Yes Term
LOAN_TERM_PERIOD VARCHAR2 (30) Yes Term Period
LOAN_CURRENCY VARCHAR2 (15) Yes Currency
LOAN_CLASS_CODE VARCHAR2 (30)
Loan Class
LOAN_TYPE VARCHAR2 (80) Yes Loan Type
LOAN_SUBTYPE VARCHAR2 (30)
Loan SubType
LOAN_PURPOSE_CODE VARCHAR2 (30)
Loan Purpose
AMORTIZED_TERM NUMBER

Amortized Term
AMORTIZED_TERM_PERIOD VARCHAR2 (30)
Term Period
LOAN_MATURITY_DATE DATE

Maturity Date
LOAN_START_DATE DATE
Yes Loan Start Date
LOAN_APPLICATION_DATE DATE
Yes Application Date
LOAN_CLOSING_DATE DATE

Closing Date
LAST_BILLED_DATE DATE

Last Billed Date
END_DATE DATE

End Date
PRODUCT_FLAG VARCHAR2 (1)
Product Flag
CUST_ACCOUNT_ID NUMBER (15)
Cust Account ID
PRIMARY_BORROWER_ID NUMBER (15)
Primary Borrower ID
PARTY_NAME VARCHAR2 (360) Yes Party Type
PRODUCT_ID NUMBER (15)
Product ID
REQUESTED_AMOUNT NUMBER
Yes Requested Amount
FUNDED_AMOUNT NUMBER

Funded Amount
REFERENCE_AMOUNT NUMBER

Reference Amount
REFERENCE_NUMBER VARCHAR2 (60)
Reference NUmber
REFERENCE_NAME VARCHAR2 (60)
Reference Number
REFERENCE_TYPE VARCHAR2 (30)
Reference Type
REFERENCE_DESCRIPTION VARCHAR2 (250)
Reference Description
LOAN_APPROVAL_DATE DATE

Loan Approval Date
LOAN_APPROVED_BY NUMBER

Loan Approved By
LOAN_STATUS VARCHAR2 (30) Yes Loan Status
LOAN_ASSIGNED_TO NUMBER

Loan Assigned To
REFERENCE_ID NUMBER (15)
reference ID
CUSTOM_PAYMENTS_FLAG VARCHAR2 (1)
Custom Payments Flag
BILLED_FLAG VARCHAR2 (1)
Billed Flag
ORG_ID NUMBER (15) Yes Organization ID
USSGL_TRANSACTION_CODE VARCHAR2 (30)
obsoleted
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Flexfield
ATTRIBUTE16 VARCHAR2 (150)
Flexfield
ATTRIBUTE17 VARCHAR2 (150)
Flexfield
ATTRIBUTE18 VARCHAR2 (150)
Flexfield
ATTRIBUTE19 VARCHAR2 (150)
Flexfield
ATTRIBUTE20 VARCHAR2 (150)
Flexfield
GL_DATE DATE

GL Date
REFERENCE_TYPE_ID NUMBER (15)
reference Type ID
BILL_TO_ACCT_SITE_ID NUMBER (15)
Bill to Acct Site ID
REC_ADJUSTMENT_NUMBER VARCHAR2 (20)
Rec Adjustment NUmber
CONTACT_PERS_PARTY_ID NUMBER (15)
Conact Person Party ID
CONTACT_REL_PARTY_ID NUMBER (15)
Contact Relationship Party ID
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange Rate information
EXCHANGE_DATE DATE

Exchange Rate information
EXCHANGE_RATE NUMBER

Exchange Rate information
COLLATERAL_PERCENT NUMBER

Collateral PErcent
CREDIT_REVIEW_FLAG VARCHAR2 (1)
Credit Review Flag
LAST_PAYMENT_NUMBER NUMBER

Last Payment NUmber
LAST_AMORTIZATION_ID NUMBER

Last Amortization ID
LEGAL_ENTITY_ID NUMBER (15)
Legal Entity ID
OPEN_TO_TERM_FLAG VARCHAR2 (1)
Open To Term Flag
MULTIPLE_FUNDING_FLAG VARCHAR2 (1)
Multiple Funding Flag
LOAN_TYPE_ID NUMBER (15)
Loan Type ID
SECONDARY_STATUS VARCHAR2 (30)
Secondary Status
OPEN_TO_TERM_EVENT VARCHAR2 (30)
Open To Term Event
BALLOON_PAYMENT_TYPE VARCHAR2 (30)
Balloon Payment Type
CURRENT_PHASE VARCHAR2 (30)
Current Phase
OPEN_LOAN_START_DATE DATE

loan start date
OPEN_LOAN_TERM NUMBER

open loan term
OPEN_LOAN_TERM_PERIOD VARCHAR2 (30)
loan term period
OPEN_MATURITY_DATE DATE

maturity date
FUNDS_CHECK_DATE DATE

funds check date
FUNDS_RESERVED_FLAG VARCHAR2 (1)
funds reserved flag
SUBSIDY_RATE NUMBER

subsidy rate
SUBSIDY_COST NUMBER

subsidy cost
UNSUBSIDIZED_AMOUNT NUMBER

unsubsidized amount
APPLICATION_ID NUMBER

Application Id of the Loans
ENTITY_CODE VARCHAR2 (30) Yes Entity Code representing Loans Application
Query Text

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


SELECT EVENT_ID
,      LEDGER_ID
,      LOAN_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PROGRAM_ID
,      OBJECT_VERSION_NUMBER
,      REQUEST_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
,      PARTY_NAME
,      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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      GL_DATE
,      REFERENCE_TYPE_ID
,      BILL_TO_ACCT_SITE_ID
,      REC_ADJUSTMENT_NUMBER
,      CONTACT_PERS_PARTY_ID
,      CONTACT_REL_PARTY_ID
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      COLLATERAL_PERCENT
,      CREDIT_REVIEW_FLAG
,      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
,      CURRENT_PHASE
,      OPEN_LOAN_START_DATE
,      OPEN_LOAN_TERM
,      OPEN_LOAN_TERM_PERIOD
,      OPEN_MATURITY_DATE
,      FUNDS_CHECK_DATE
,      FUNDS_RESERVED_FLAG
,      SUBSIDY_RATE
,      SUBSIDY_COST
,      UNSUBSIDIZED_AMOUNT
,      APPLICATION_ID
,      ENTITY_CODE
FROM APPS.LNS_LOAN_HEADERS_EXT_V;

Dependencies

[top of page]

APPS.LNS_LOAN_HEADERS_EXT_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewLNS_LOAN_HEADERS_ALL_VL
ViewLNS_LOAN_TYPES_VL
SynonymXLA_EVENTS
SynonymXLA_TRANSACTION_ENTITIES
APPS.LNS_LOAN_HEADERS_EXT_V is referenced by following:

SchemaAPPS
Package BodyXLA_00206_AAD_S_000003_PKG - show dependent code
Package BodyXLA_00206_AAD_S_000004_BC_PKG - show dependent code
Package BodyXLA_00206_AAD_S_000004_PKG - show dependent code