Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - LNS Tables and Views

TABLE - LNS.LNS_AMORTIZATION_LINES
TABLE - LNS.LNS_AMORTIZATION_SCHEDS
TABLE - LNS.LNS_AMORT_SCHEDS_GT
TABLE - LNS.LNS_APPROVAL_ACTIONS
TABLE - LNS.LNS_ASSETS
TABLE - LNS.LNS_ASSET_ASSIGNMENTS
TABLE - LNS.LNS_BORROWER_SUMMARIES
TABLE - LNS.LNS_CONDITIONS
TABLE - LNS.LNS_COND_ASSIGNMENTS
TABLE - LNS.LNS_CUSTOM_PAYMNT_SCHEDS
TABLE - LNS.LNS_DEFAULT_DISTRIBS_ALL
TABLE - LNS.LNS_DISB_HEADERS
TABLE - LNS.LNS_DISB_HISTORIES_H
TABLE - LNS.LNS_DISB_LINES
TABLE - LNS.LNS_DISTRIBUTIONS
TABLE - LNS.LNS_EVENTS
TABLE - LNS.LNS_EVENT_ACTIONS
TABLE - LNS.LNS_EVT_ACTION_HISTORY_H
TABLE - LNS.LNS_FEES_ALL
TABLE - LNS.LNS_FEE_ASSIGNMENTS
TABLE - LNS.LNS_FEE_SCHEDULES
TABLE - LNS.LNS_INT_RATE_HEADERS
TABLE - LNS.LNS_INT_RATE_LINES
TABLE - LNS.LNS_LOAN_API_ERRORS_GT
TABLE - LNS.LNS_LOAN_CREATE_ERRORS_GT
TABLE - LNS.LNS_LOAN_DOCUMENTS
TABLE - LNS.LNS_LOAN_HEADERS_ALL
TABLE - LNS.LNS_LOAN_HISTORIES_H
TABLE - LNS.LNS_LOAN_LINES
TABLE - LNS.LNS_LOAN_PRODUCTS_ALL
TABLE - LNS.LNS_LOAN_PRODUCTS_ALL_TL
TABLE - LNS.LNS_LOAN_PRODUCT_FLAGS
TABLE - LNS.LNS_LOAN_PRODUCT_LINES
TABLE - LNS.LNS_LOAN_TYPES
TABLE - LNS.LNS_PARTICIPANTS
TABLE - LNS.LNS_RATE_SCHEDULES
TABLE - LNS.LNS_SYSTEM_OPTIONS_ALL
TABLE - LNS.LNS_TERMS
VIEW - APPS.LNS_AEL_GL_V
VIEW - APPS.LNS_AMORTIZATION_SCHEDULES_V
VIEW - APPS.LNS_AM_SCHEDS_DTL_V
VIEW - APPS.LNS_AM_SCHEDS_V
VIEW - APPS.LNS_AR_AMORTIZATIONS_V
VIEW - APPS.LNS_LOAN_DETAILS_EXT_V
VIEW - APPS.LNS_LOAN_HEADERS_EXT_V
VIEW - APPS.LNS_LOAN_INFO
VIEW - APPS.LNS_LOAN_PARTICIPANTS_V
VIEW - APPS.LNS_LOAN_PAYMENT_SUMMARY_V
VIEW - APPS.LNS_LOAN_PRODUCTS_ALL_VL
VIEW - APPS.LNS_LOAN_PRODUCTS_VL
VIEW - APPS.LNS_LOAN_SUMMARY_V
VIEW - APPS.LNS_LOOKUPS
VIEW - APPS.LNS_OPEN_RECEIVABLES_V
VIEW - APPS.LNS_PAYMENTS_SUMMARY_V
VIEW - APPS.LNS_PAY_SUM_OVERDUE_V
VIEW - APPS.LNS_PAY_SUM_V
VIEW - APPS.LNS_PAY_SUM_YEARLY_V
VIEW - APPS.LNS_RECEIVABLE_ACTIVITIES_V
VIEW - APPS.LNS_REC_ACT_ADJ_V
VIEW - APPS.LNS_REC_ACT_CASH_CM_V
VIEW - APPS.LNS_SL_GL_V2

Table: LNS_AMORTIZATION_LINES

Description: Amortization Lines reprensents the details of any give Amortization represented on the Amortization Schedules table
Primary Key: LNS_AMORTIZATION_LINES_PK
  1. AMORTIZATION_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_AMORTIZATION_LINES.AMORTIZATION_SCHEDULE_ID %
LNS_AMORTIZATION_LINES.LOAN_ID %
LNS_AMORTIZATION_LINES.CUST_TRX_ID RA_CUSTOMER_TRX_ALL
LNS_AMORTIZATION_LINES.CUST_TRX_LINE_ID RA_CUSTOMER_TRX_LINES_ALL

[top of page]

LNS.LNS_AMORTIZATION_LINES does not reference any database object

LNS.LNS_AMORTIZATION_LINES is referenced by following:

LNS
VIEW - LNS_AMORTIZATION_LINES#

[top of page]

Table: LNS_AMORTIZATION_SCHEDS

Description: Amortizations Table - Records installments due for a loan as billing generates them. Also stores any reversal and re-amortization information
Primary Key: LNS_AMORTIZATION_SCHEDS_PK
  1. AMORTIZATION_SCHEDULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_AMORTIZATION_SCHEDS.LOAN_ID %
LNS_AMORTIZATION_SCHEDS.PRINCIPAL_TRX_ID RA_CUSTOMER_TRX_ALL
LNS_AMORTIZATION_SCHEDS.INTEREST_TRX_ID RA_CUSTOMER_TRX_ALL
LNS_AMORTIZATION_SCHEDS.FEE_TRX_ID RA_CUSTOMER_TRX_ALL
LNS_AMORTIZATION_SCHEDS.RATE_ID %

[top of page]

LNS.LNS_AMORTIZATION_SCHEDS does not reference any database object

LNS.LNS_AMORTIZATION_SCHEDS is referenced by following:

LNS
VIEW - LNS_AMORTIZATION_SCHEDS#

[top of page]

Table: LNS_AMORT_SCHEDS_GT

Description:

[top of page]

LNS.LNS_AMORT_SCHEDS_GT does not reference any database object

LNS.LNS_AMORT_SCHEDS_GT is referenced by following:

APPS
SYNONYM - LNS_AMORT_SCHEDS_GT

[top of page]

Table: LNS_APPROVAL_ACTIONS

Description: Loans Approval Actions Table
Primary Key: LNS_APPROVAL_ACTIONS_PK
  1. ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_APPROVAL_ACTIONS.LOAN_ID %

[top of page]

LNS.LNS_APPROVAL_ACTIONS does not reference any database object

LNS.LNS_APPROVAL_ACTIONS is referenced by following:

LNS
VIEW - LNS_APPROVAL_ACTIONS#

[top of page]

Table: LNS_ASSETS

Description: LNS_ASSETS is used to store the assets of a loan participant.
Primary Key: LNS_ASSETS_PK
  1. ASSET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_ASSETS.ASSET_OWNER_ID HZ_PARTIES
LNS_ASSETS.CUSTODIAN_ID HZ_PARTIES
LNS_ASSETS.CONTACT_PERS_PARTY_ID HZ_PARTIES
LNS_ASSETS.CONTACT_REL_PARTY_ID HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_ASSET_ASSIGNMENTS.ASSET_ID LNS_ASSETS

[top of page]

LNS.LNS_ASSETS does not reference any database object

LNS.LNS_ASSETS is referenced by following:

LNS
VIEW - LNS_ASSETS#

[top of page]

Table: LNS_ASSET_ASSIGNMENTS

Description: LNS_ASSET_ASSIGNMENTS stores the assignment of assets to a loan as collateral.
Primary Key: LNS_ASSET_ASSIGNMENTS_PK
  1. ASSET_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_ASSET_ASSIGNMENTS.ASSET_ID LNS_ASSETS

[top of page]

LNS.LNS_ASSET_ASSIGNMENTS does not reference any database object

LNS.LNS_ASSET_ASSIGNMENTS is referenced by following:

LNS
VIEW - LNS_ASSET_ASSIGNMENTS#

[top of page]

Table: LNS_BORROWER_SUMMARIES

Description: Borrower Summary Table

[top of page]

LNS.LNS_BORROWER_SUMMARIES does not reference any database object

LNS.LNS_BORROWER_SUMMARIES is referenced by following:

LNS
VIEW - LNS_BORROWER_SUMMARIES#

[top of page]

Table: LNS_CONDITIONS

Description: Loan Conditions Table
Primary Key: LNS_CONDITIONS_PK
  1. CONDITION_ID
Primary Key: UNIQUE_CONDITION_NAME
  1. CONDITION_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_COND_ASSIGNMENTS.CONDITION_ID LNS_CONDITIONS

[top of page]

LNS.LNS_CONDITIONS does not reference any database object

LNS.LNS_CONDITIONS is referenced by following:

LNS
VIEW - LNS_CONDITIONS#

[top of page]

Table: LNS_COND_ASSIGNMENTS

Description: Loan Condition Assignment Table
Primary Key: LNS_COND_ASSIGNMENTS_PK
  1. COND_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_COND_ASSIGNMENTS.CONDITION_ID LNS_CONDITIONS
LNS_COND_ASSIGNMENTS.LOAN_ID %
LNS_COND_ASSIGNMENTS.FULFILLMENT_UPDATED_BY FND_USER

[top of page]

LNS.LNS_COND_ASSIGNMENTS does not reference any database object

LNS.LNS_COND_ASSIGNMENTS is referenced by following:

LNS
VIEW - LNS_COND_ASSIGNMENTS#

[top of page]

Table: LNS_CUSTOM_PAYMNT_SCHEDS

Description: Loans Custom Schedule Table
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_CUSTOM_PAYMNT_SCHEDS.LOAN_ID %

[top of page]

LNS.LNS_CUSTOM_PAYMNT_SCHEDS does not reference any database object

LNS.LNS_CUSTOM_PAYMNT_SCHEDS is referenced by following:

LNS
VIEW - LNS_CUSTOM_PAYMNT_SCHEDS#

[top of page]

Table: LNS_DEFAULT_DISTRIBS_ALL

Description: Loans Default Distributions Table - This table establishes the accounting to default for loans and fees. The Default for loans will be based on the combination of LOAN_CLASS + LOAN_TYPE. The default for fees is associated to the fee_id.
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_DEFAULT_DISTRIBS_ALL.CODE_COMBINATION_ID GL_CODE_COMBINATIONS
LNS_DEFAULT_DISTRIBS_ALL.ORG_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

LNS.LNS_DEFAULT_DISTRIBS_ALL does not reference any database object

LNS.LNS_DEFAULT_DISTRIBS_ALL is referenced by following:

LNS
VIEW - LNS_DEFAULT_DISTRIBS_ALL#

[top of page]

Table: LNS_DISB_HEADERS

Description: This table stores header level disbursement information

[top of page]

LNS.LNS_DISB_HEADERS does not reference any database object

LNS.LNS_DISB_HEADERS is referenced by following:

LNS
VIEW - LNS_DISB_HEADERS#

[top of page]

Table: LNS_DISB_HISTORIES_H

Description: This table stores disbursement changes

[top of page]

LNS.LNS_DISB_HISTORIES_H does not reference any database object

LNS.LNS_DISB_HISTORIES_H is referenced by following:

LNS
VIEW - LNS_DISB_HISTORIES_H#

[top of page]

Table: LNS_DISB_LINES

Description: Stores line level disbursement information

[top of page]

LNS.LNS_DISB_LINES does not reference any database object

LNS.LNS_DISB_LINES is referenced by following:

LNS
VIEW - LNS_DISB_LINES#

[top of page]

Table: LNS_DISTRIBUTIONS

Description: Loans Distributions Table - stores actual accounting distributions for a give loan_id
Primary Key: LNS_DISTRIBUTIONS_PK
  1. DISTRIBUTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_DISTRIBUTIONS.LOAN_ID %

[top of page]

LNS.LNS_DISTRIBUTIONS does not reference any database object

LNS.LNS_DISTRIBUTIONS is referenced by following:

LNS
VIEW - LNS_DISTRIBUTIONS#

[top of page]

Table: LNS_EVENTS

Description: This table stores actionable events for a loan class
Primary Key: LNS_EVENTS_PK
  1. EVENT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_EVENT_ACTIONS.EVENT_ID LNS_EVENTS

[top of page]

LNS.LNS_EVENTS does not reference any database object

LNS.LNS_EVENTS is referenced by following:

LNS
VIEW - LNS_EVENTS#

[top of page]

Table: LNS_EVENT_ACTIONS

Description: This table stores actionable events for a Loan type and loan class
Primary Key: LNS_EVENT_ACTIONS_PK
  1. EVENT_ACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_EVENT_ACTIONS.EVENT_ID LNS_EVENTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_EVT_ACTION_HISTORY_H.EVENT_ACTION_ID LNS_EVENT_ACTIONS

[top of page]

LNS.LNS_EVENT_ACTIONS does not reference any database object

LNS.LNS_EVENT_ACTIONS is referenced by following:

LNS
VIEW - LNS_EVENT_ACTIONS#

[top of page]

Table: LNS_EVT_ACTION_HISTORY_H

Description: This table stores the information about workflow actions performed for a Loan event
Primary Key: LNS_EVT_ACTION_HISTORY_H_PK
  1. EVENT_ACTION_HISTORY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_EVT_ACTION_HISTORY_H.EVENT_ACTION_ID LNS_EVENT_ACTIONS
LNS_EVT_ACTION_HISTORY_H.LOAN_ID %

[top of page]

LNS.LNS_EVT_ACTION_HISTORY_H does not reference any database object

LNS.LNS_EVT_ACTION_HISTORY_H is referenced by following:

LNS
VIEW - LNS_EVT_ACTION_HISTORY_H#

[top of page]

Table: LNS_FEES_ALL

Description: Loan Fees Setup Table
Primary Key: UNIQUE_FEE_NAME
  1. FEE_NAME
  2. ORG_ID

[top of page]

LNS.LNS_FEES_ALL does not reference any database object

LNS.LNS_FEES_ALL is referenced by following:

LNS
VIEW - LNS_FEES_ALL#

[top of page]

Table: LNS_FEE_ASSIGNMENTS

Description: Loan Fees Assignment Table
Primary Key: LNS_FEE_ASSIGNMENTS_PK
  1. FEE_ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_FEE_ASSIGNMENTS.LOAN_ID %

[top of page]

LNS.LNS_FEE_ASSIGNMENTS does not reference any database object

LNS.LNS_FEE_ASSIGNMENTS is referenced by following:

LNS
VIEW - LNS_FEE_ASSIGNMENTS#

[top of page]

Table: LNS_FEE_SCHEDULES

Description: Loans Fees Schedules Table
Primary Key: LNS_FEE_SCHEDULES_PK
  1. FEE_SCHEDULE_ID

[top of page]

LNS.LNS_FEE_SCHEDULES does not reference any database object

LNS.LNS_FEE_SCHEDULES is referenced by following:

LNS
VIEW - LNS_FEE_SCHEDULES#

[top of page]

Table: LNS_INT_RATE_HEADERS

Description: Interest Rate Headers table
Primary Key: LNS_INT_RATE_HEADERS_PK
  1. INTEREST_RATE_ID
Primary Key: UNIQUE_INDEX_NAME
  1. INTEREST_RATE_NAME

[top of page]

LNS.LNS_INT_RATE_HEADERS does not reference any database object

LNS.LNS_INT_RATE_HEADERS is referenced by following:

LNS
VIEW - LNS_INT_RATE_HEADERS#

[top of page]

Table: LNS_INT_RATE_LINES

Description: Interest Rate Lines Table
Primary Key: LNS_INT_RATE_LINES_PK
  1. INTEREST_RATE_LINE_ID
Primary Key: UNIQUE_START_DATE
  1. INTEREST_RATE_ID
  2. START_DATE_ACTIVE

[top of page]

LNS.LNS_INT_RATE_LINES does not reference any database object

LNS.LNS_INT_RATE_LINES is referenced by following:

LNS
VIEW - LNS_INT_RATE_LINES#

[top of page]

Table: LNS_LOAN_API_ERRORS_GT

Description:

[top of page]

LNS.LNS_LOAN_API_ERRORS_GT does not reference any database object

LNS.LNS_LOAN_API_ERRORS_GT is referenced by following:

APPS
SYNONYM - LNS_LOAN_API_ERRORS_GT

[top of page]

Table: LNS_LOAN_CREATE_ERRORS_GT

Description:

[top of page]

LNS.LNS_LOAN_CREATE_ERRORS_GT does not reference any database object

LNS.LNS_LOAN_CREATE_ERRORS_GT is referenced by following:

APPS
SYNONYM - LNS_LOAN_CREATE_ERRORS_GT

[top of page]

Table: LNS_LOAN_DOCUMENTS

Description: This table stores all the documents related to a Source Object
Primary Key: LNS_LOAN_DOCUMENTS_PK
  1. DOCUMENT_ID

[top of page]

LNS.LNS_LOAN_DOCUMENTS does not reference any database object

LNS.LNS_LOAN_DOCUMENTS is referenced by following:

LNS
VIEW - LNS_LOAN_DOCUMENTS#

[top of page]

Table: LNS_LOAN_HEADERS_ALL

Description: Loans Header Table
Primary Key: LNS_LOAN_HEADERS_ALL_PK
  1. LOAN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_LOAN_HEADERS_ALL.PRIMARY_BORROWER_ID HZ_PARTIES
LNS_LOAN_HEADERS_ALL.CONTACT_PERS_PARTY_ID HZ_PARTIES
LNS_LOAN_HEADERS_ALL.CONTACT_REL_PARTY_ID HZ_PARTIES
LNS_LOAN_HEADERS_ALL.CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
LNS_LOAN_HEADERS_ALL.REFERENCE_ID RA_CUSTOMER_TRX_ALL
LNS_LOAN_HEADERS_ALL.REFERENCE_TYPE_ID RA_CUST_TRX_TYPES_ALL
LNS_LOAN_HEADERS_ALL.BILL_TO_ACCT_SITE_ID HZ_CUST_ACCT_SITES_ALL
LNS_LOAN_HEADERS_ALL.PRODUCT_ID %
LNS_LOAN_HEADERS_ALL.LOAN_ASSIGNED_TO JTF_RS_RESOURCE_EXTNS
LNS_LOAN_HEADERS_ALL.LOAN_APPROVED_BY JTF_RS_RESOURCE_EXTNS
LNS_LOAN_HEADERS_ALL.ORG_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_LOAN_HISTORIES_H.LOAN_ID LNS_LOAN_HEADERS_ALL
LNS_PARTICIPANTS.LOAN_ID LNS_LOAN_HEADERS_ALL
LNS_TERMS.LOAN_ID LNS_LOAN_HEADERS_ALL

[top of page]

LNS.LNS_LOAN_HEADERS_ALL does not reference any database object

LNS.LNS_LOAN_HEADERS_ALL is referenced by following:

LNS
VIEW - LNS_LOAN_HEADERS_ALL#

[top of page]

Table: LNS_LOAN_HISTORIES_H

Description: Loan History Table
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_LOAN_HISTORIES_H.LOAN_ID LNS_LOAN_HEADERS_ALL

[top of page]

LNS.LNS_LOAN_HISTORIES_H does not reference any database object

LNS.LNS_LOAN_HISTORIES_H is referenced by following:

LNS
VIEW - LNS_LOAN_HISTORIES_H#

[top of page]

Table: LNS_LOAN_LINES

Description: Loan Lines Table
Primary Key: LNS_LOAN_LINES_PK
  1. LOAN_LINE_ID

[top of page]

LNS.LNS_LOAN_LINES does not reference any database object

LNS.LNS_LOAN_LINES is referenced by following:

LNS
VIEW - LNS_LOAN_LINES#

[top of page]

Table: LNS_LOAN_PRODUCTS_ALL

Description: Loan Product Setup Table
Primary Key: LNS_LOAN_PRODUCTS_ALL_PK
  1. LOAN_PRODUCT_ID
Primary Key: UNIQUE_PRODUCT_NAME
  1. LOAN_PRODUCT_NAME
  2. ORG_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_LOAN_PRODUCT_FLAGS.LOAN_PRODUCT_ID LNS_LOAN_PRODUCTS_ALL
LNS_LOAN_PRODUCT_LINES.LOAN_PRODUCT_ID LNS_LOAN_PRODUCTS_ALL

[top of page]

LNS.LNS_LOAN_PRODUCTS_ALL does not reference any database object

LNS.LNS_LOAN_PRODUCTS_ALL is referenced by following:

LNS
VIEW - LNS_LOAN_PRODUCTS_ALL#

[top of page]

Table: LNS_LOAN_PRODUCTS_ALL_TL

Description: Stores the multi lingual columns for each record of the base table LNS_LOAN_PRODUCTS_ALL
Primary Key: LNS_LOAN_PRODUCTS_ALL_TL_PK
  1. LOAN_PRODUCT_ID
  2. LANGUAGE

[top of page]

LNS.LNS_LOAN_PRODUCTS_ALL_TL does not reference any database object

LNS.LNS_LOAN_PRODUCTS_ALL_TL is referenced by following:

LNS
VIEW - LNS_LOAN_PRODUCTS_ALL_TL#

[top of page]

Table: LNS_LOAN_PRODUCT_FLAGS

Description: Loan Product Setup Read-Only Column Names Table
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_LOAN_PRODUCT_FLAGS.LOAN_PRODUCT_ID LNS_LOAN_PRODUCTS_ALL

[top of page]

LNS.LNS_LOAN_PRODUCT_FLAGS does not reference any database object

LNS.LNS_LOAN_PRODUCT_FLAGS is referenced by following:

LNS
VIEW - LNS_LOAN_PRODUCT_FLAGS#

[top of page]

Table: LNS_LOAN_PRODUCT_LINES

Description: Loan Product Setup Lines Table
Primary Key: LNS_LOAN_PRODUCT_LINES_PK
  1. LOAN_PRODUCT_LINES_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_LOAN_PRODUCT_LINES.LOAN_PRODUCT_ID LNS_LOAN_PRODUCTS_ALL
LNS_LOAN_PRODUCT_LINES.PARENT_PRODUCT_LINES_ID LNS_LOAN_PRODUCT_LINES
Foreign Keys to this table:
Foreign Key Column Foreign Table
LNS_LOAN_PRODUCT_LINES.PARENT_PRODUCT_LINES_ID LNS_LOAN_PRODUCT_LINES

[top of page]

LNS.LNS_LOAN_PRODUCT_LINES does not reference any database object

LNS.LNS_LOAN_PRODUCT_LINES is referenced by following:

LNS
VIEW - LNS_LOAN_PRODUCT_LINES#

[top of page]

Table: LNS_LOAN_TYPES

Description: Loan Types Setup Table
Primary Key: LNS_LOAN_TYPES_PK
  1. LOAN_TYPE_ID
Primary Key: UNIQUE_TYPE_NAME
  1. LOAN_CLASS_CODE
  2. LOAN_TYPE_NAME

[top of page]

LNS.LNS_LOAN_TYPES does not reference any database object

LNS.LNS_LOAN_TYPES is referenced by following:

LNS
VIEW - LNS_LOAN_TYPES#

[top of page]

Table: LNS_PARTICIPANTS

Description: Loan Participants Table
Primary Key: LNS_PARTICIPANTS_PK
  1. PARTICIPANT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_PARTICIPANTS.LOAN_ID LNS_LOAN_HEADERS_ALL
LNS_PARTICIPANTS.HZ_PARTY_ID HZ_PARTIES
LNS_PARTICIPANTS.CUST_ACCOUNT_ID HZ_CUST_ACCOUNTS
LNS_PARTICIPANTS.BILL_TO_ACCT_SITE_ID HZ_CUST_ACCT_SITES_ALL
LNS_PARTICIPANTS.CONTACT_PERS_PARTY_ID HZ_PARTIES
LNS_PARTICIPANTS.CONTACT_REL_PARTY_ID HZ_PARTIES
LNS_PARTICIPANTS.CREDIT_REQUEST_ID AR_CMGT_CREDIT_REQUESTS
LNS_PARTICIPANTS.CASE_FOLDER_ID AR_CMGT_CASE_FOLDERS

[top of page]

LNS.LNS_PARTICIPANTS does not reference any database object

LNS.LNS_PARTICIPANTS is referenced by following:

LNS
VIEW - LNS_PARTICIPANTS#

[top of page]

Table: LNS_RATE_SCHEDULES

Description: Loan Interest Rate Schedule Table
Primary Key: LNS_RATE_SCHEDULES_PK
  1. RATE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_RATE_SCHEDULES.TERM_ID %

[top of page]

LNS.LNS_RATE_SCHEDULES does not reference any database object

LNS.LNS_RATE_SCHEDULES is referenced by following:

LNS
VIEW - LNS_RATE_SCHEDULES#

[top of page]

Table: LNS_SYSTEM_OPTIONS_ALL

Description: Loans System Options Table
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_SYSTEM_OPTIONS_ALL.TRX_TYPE_ID RA_CUST_TRX_TYPES_ALL
LNS_SYSTEM_OPTIONS_ALL.INTEREST_TRX_TYPE_ID RA_CUST_TRX_TYPES_ALL
LNS_SYSTEM_OPTIONS_ALL.FEE_TRX_TYPE_ID RA_CUST_TRX_TYPES_ALL
LNS_SYSTEM_OPTIONS_ALL.BATCH_SOURCE_ID RA_BATCH_SOURCES_ALL
LNS_SYSTEM_OPTIONS_ALL.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS_11I
LNS_SYSTEM_OPTIONS_ALL.ORG_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

LNS.LNS_SYSTEM_OPTIONS_ALL does not reference any database object

LNS.LNS_SYSTEM_OPTIONS_ALL is referenced by following:

LNS
VIEW - LNS_SYSTEM_OPTIONS_ALL#

[top of page]

Table: LNS_TERMS

Description: Loans Terms Table
Primary Key: LNS_TERMS_PK
  1. TERM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
LNS_TERMS.LOAN_ID LNS_LOAN_HEADERS_ALL

[top of page]

LNS.LNS_TERMS does not reference any database object

LNS.LNS_TERMS is referenced by following:

LNS
VIEW - LNS_TERMS#

[top of page]

View: LNS_AEL_GL_V

[top of page]

APPS.LNS_AEL_GL_V references the following:

APPS
SYNONYM - GL_IMPORT_REFERENCES
SYNONYM - GL_JE_HEADERS
SYNONYM - GL_JE_LINES
SYNONYM - HZ_PARTIES
SYNONYM - LNS_LOAN_HEADERS_ALL
PACKAGE - LNS_UTILITY_PUB
SYNONYM - XLA_AE_HEADERS
SYNONYM - XLA_AE_LINES
SYNONYM - XLA_EVENTS
SYNONYM - XLA_TRANSACTION_ENTITIES

APPS.LNS_AEL_GL_V is not referenced by any database object

[top of page]

View: LNS_AMORTIZATION_SCHEDULES_V

[top of page]

APPS.LNS_AMORTIZATION_SCHEDULES_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL
VIEW - LNS_LOOKUPS

APPS.LNS_AMORTIZATION_SCHEDULES_V is not referenced by any database object

[top of page]

View: LNS_AM_SCHEDS_DTL_V

[top of page]

APPS.LNS_AM_SCHEDS_DTL_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
PACKAGE - FND_GLOBAL
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL
VIEW - LNS_LOOKUPS

APPS.LNS_AM_SCHEDS_DTL_V is not referenced by any database object

[top of page]

View: LNS_AM_SCHEDS_V

[top of page]

APPS.LNS_AM_SCHEDS_V references the following:

APPS
SYNONYM - AR_ADJUSTMENTS_ALL
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_DISB_HEADERS
SYNONYM - LNS_DISB_LINES
SYNONYM - LNS_LOAN_AMOUNT_ADJS
SYNONYM - LNS_LOAN_HEADERS_ALL
SYNONYM - LNS_LOAN_LINES
VIEW - LNS_LOOKUPS

APPS.LNS_AM_SCHEDS_V is not referenced by any database object

[top of page]

View: LNS_AR_AMORTIZATIONS_V

[top of page]

APPS.LNS_AR_AMORTIZATIONS_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.LNS_AR_AMORTIZATIONS_V is not referenced by any database object

[top of page]

View: LNS_LOAN_DETAILS_EXT_V

[top of page]

APPS.LNS_LOAN_DETAILS_EXT_V references the following:

APPS
SYNONYM - FV_FUND_PARAMETERS
SYNONYM - GL_CODE_COMBINATIONS
SYNONYM - LNS_DISB_HEADERS
SYNONYM - LNS_DISTRIBUTIONS
PACKAGE - LNS_DISTRIBUTIONS_PUB
SYNONYM - LNS_LOAN_AMOUNT_ADJS
SYNONYM - LNS_LOAN_HEADERS_ALL
PACKAGE - LNS_UTILITY_PUB
SYNONYM - XLA_EVENTS
SYNONYM - XLA_TRANSACTION_ENTITIES

APPS.LNS_LOAN_DETAILS_EXT_V is not referenced by any database object

[top of page]

View: LNS_LOAN_HEADERS_EXT_V

[top of page]

APPS.LNS_LOAN_HEADERS_EXT_V references the following:

APPS
SYNONYM - HZ_PARTIES
SYNONYM - XLA_EVENTS
SYNONYM - XLA_TRANSACTION_ENTITIES
- LNS_LOAN_HEADERS_ALL_VL
- LNS_LOAN_TYPES_VL

APPS.LNS_LOAN_HEADERS_EXT_V is not referenced by any database object

[top of page]

View: LNS_LOAN_INFO

[top of page]

APPS.LNS_LOAN_INFO references the following:

APPS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_PARTIES
SYNONYM - LNS_DISB_HEADERS
SYNONYM - LNS_LOAN_AMOUNT_ADJS
SYNONYM - LNS_LOAN_HEADERS_ALL
SYNONYM - LNS_LOAN_LINES
PACKAGE - LNS_UTILITY_PUB
- LNS_LOAN_TYPES_VL

APPS.LNS_LOAN_INFO is not referenced by any database object

[top of page]

View: LNS_LOAN_PARTICIPANTS_V

[top of page]

APPS.LNS_LOAN_PARTICIPANTS_V references the following:

APPS
VIEW - AR_LOOKUPS
PACKAGE - FND_GLOBAL
VIEW - FND_TERRITORIES_VL
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_PARTIES
VIEW - LNS_LOOKUPS
SYNONYM - LNS_PARTICIPANTS

APPS.LNS_LOAN_PARTICIPANTS_V is not referenced by any database object

[top of page]

View: LNS_LOAN_PAYMENT_SUMMARY_V

[top of page]

APPS.LNS_LOAN_PAYMENT_SUMMARY_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL

APPS.LNS_LOAN_PAYMENT_SUMMARY_V is not referenced by any database object

[top of page]

View: LNS_LOAN_PRODUCTS_ALL_VL

[top of page]

APPS.LNS_LOAN_PRODUCTS_ALL_VL references the following:

APPS
SYNONYM - LNS_LOAN_PRODUCTS_ALL
SYNONYM - LNS_LOAN_PRODUCTS_ALL_TL

APPS.LNS_LOAN_PRODUCTS_ALL_VL is not referenced by any database object

[top of page]

View: LNS_LOAN_PRODUCTS_VL

[top of page]

APPS.LNS_LOAN_PRODUCTS_VL references the following:

APPS
SYNONYM - LNS_LOAN_PRODUCTS
SYNONYM - LNS_LOAN_PRODUCTS_ALL_TL

APPS.LNS_LOAN_PRODUCTS_VL is not referenced by any database object

[top of page]

View: LNS_LOAN_SUMMARY_V

[top of page]

APPS.LNS_LOAN_SUMMARY_V references the following:

APPS
VIEW - FND_CURRENCIES_VL
PACKAGE - FND_GLOBAL
SYNONYM - HZ_PARTIES
SYNONYM - JTF_RS_RESOURCE_EXTNS
PACKAGE - LNS_FIN_UTILS
SYNONYM - LNS_LOAN_HEADERS
SYNONYM - LNS_LOAN_TYPES
VIEW - LNS_LOOKUPS

APPS.LNS_LOAN_SUMMARY_V is not referenced by any database object

[top of page]

View: LNS_LOOKUPS

[top of page]

APPS.LNS_LOOKUPS references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
APPS.LNS_LOOKUPS is referenced by following:

APPS
VIEW - LNS_AMORTIZATION_SCHEDULES_V
VIEW - LNS_AM_SCHEDS_DTL_V
VIEW - LNS_AM_SCHEDS_V
VIEW - LNS_LOAN_PARTICIPANTS_V
VIEW - LNS_LOAN_SUMMARY_V
VIEW - LNS_RECEIVABLE_ACTIVITIES_V
VIEW - LNS_REC_ACT_ADJ_V
VIEW - LNS_REC_ACT_CASH_CM_V

[top of page]

View: LNS_OPEN_RECEIVABLES_V

[top of page]

APPS.LNS_OPEN_RECEIVABLES_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - HZ_CUST_ACCOUNTS

APPS.LNS_OPEN_RECEIVABLES_V is not referenced by any database object

[top of page]

View: LNS_PAYMENTS_SUMMARY_V

[top of page]

APPS.LNS_PAYMENTS_SUMMARY_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL

APPS.LNS_PAYMENTS_SUMMARY_V is not referenced by any database object

[top of page]

View: LNS_PAY_SUM_OVERDUE_V

[top of page]

APPS.LNS_PAY_SUM_OVERDUE_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL

APPS.LNS_PAY_SUM_OVERDUE_V is not referenced by any database object

[top of page]

View: LNS_PAY_SUM_V

[top of page]

APPS.LNS_PAY_SUM_V references the following:

APPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL

APPS.LNS_PAY_SUM_V is not referenced by any database object

[top of page]

View: LNS_PAY_SUM_YEARLY_V

[top of page]

APPS.LNS_PAY_SUM_YEARLY_V references the following:

APPS
SYNONYM - AR_ADJUSTMENTS_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL

APPS.LNS_PAY_SUM_YEARLY_V is not referenced by any database object

[top of page]

View: LNS_RECEIVABLE_ACTIVITIES_V

[top of page]

APPS.LNS_RECEIVABLE_ACTIVITIES_V references the following:

APPS
SYNONYM - AR_ADJUSTMENTS_ALL
VIEW - AR_LOOKUPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLES_TRX_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
PACKAGE - FND_GLOBAL
SYNONYM - LNS_AMORTIZATION_LINES
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL
VIEW - LNS_LOOKUPS
SYNONYM - RA_CUSTOMER_TRX_ALL
SYNONYM - RA_CUSTOMER_TRX_LINES_ALL

APPS.LNS_RECEIVABLE_ACTIVITIES_V is not referenced by any database object

[top of page]

View: LNS_REC_ACT_ADJ_V

[top of page]

APPS.LNS_REC_ACT_ADJ_V references the following:

APPS
SYNONYM - AR_ADJUSTMENTS_ALL
VIEW - AR_LOOKUPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLES_TRX_ALL
PACKAGE - FND_GLOBAL
SYNONYM - LNS_AMORTIZATION_LINES
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL
VIEW - LNS_LOOKUPS
SYNONYM - RA_CUSTOMER_TRX_ALL
SYNONYM - RA_CUSTOMER_TRX_LINES_ALL

APPS.LNS_REC_ACT_ADJ_V is not referenced by any database object

[top of page]

View: LNS_REC_ACT_CASH_CM_V

[top of page]

APPS.LNS_REC_ACT_CASH_CM_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - AR_PAYMENT_SCHEDULES_ALL
SYNONYM - AR_RECEIVABLE_APPLICATIONS_ALL
PACKAGE - FND_GLOBAL
SYNONYM - LNS_AMORTIZATION_LINES
SYNONYM - LNS_AMORTIZATION_SCHEDS
SYNONYM - LNS_LOAN_HEADERS_ALL
VIEW - LNS_LOOKUPS
SYNONYM - RA_CUSTOMER_TRX_ALL
SYNONYM - RA_CUSTOMER_TRX_LINES_ALL

APPS.LNS_REC_ACT_CASH_CM_V is not referenced by any database object

[top of page]

View: LNS_SL_GL_V2

[top of page]

APPS.LNS_SL_GL_V2 references the following:

APPS
PACKAGE - FND_FLEX_EXT
SYNONYM - GL_CODE_COMBINATIONS
SYNONYM - GL_IMPORT_REFERENCES
SYNONYM - GL_JE_HEADERS
SYNONYM - GL_JE_LINES
SYNONYM - LNS_DISB_HEADERS
SYNONYM - LNS_DISTRIBUTIONS
SYNONYM - LNS_LOAN_HEADERS_ALL
PACKAGE - LNS_UTILITY_PUB
SYNONYM - XLA_AE_HEADERS
SYNONYM - XLA_AE_LINES
SYNONYM - XLA_EVENTS
SYNONYM - XLA_TRANSACTION_ENTITIES

APPS.LNS_SL_GL_V2 is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract