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.
Description: | Amortization Lines reprensents the details of any give Amortization represented on the Amortization Schedules 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 |
LNS.LNS_AMORTIZATION_LINES does not reference any database object
LNS.LNS_AMORTIZATION_LINES is referenced by following:
Description: | Amortizations Table - Records installments due for a loan as billing generates them. Also stores any reversal and re-amortization information |
---|
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 | % |
LNS.LNS_AMORTIZATION_SCHEDS does not reference any database object
LNS.LNS_AMORTIZATION_SCHEDS is referenced by following:
Description: | Loans Approval Actions Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_APPROVAL_ACTIONS.LOAN_ID | % |
LNS.LNS_APPROVAL_ACTIONS does not reference any database object
LNS.LNS_APPROVAL_ACTIONS is referenced by following:
Description: | LNS_ASSETS is used to store the assets of a loan participant. |
---|
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 Key Column | Foreign Table |
---|---|
LNS_ASSET_ASSIGNMENTS.ASSET_ID | LNS_ASSETS |
LNS.LNS_ASSETS does not reference any database object
LNS.LNS_ASSETS is referenced by following:
Description: | LNS_ASSET_ASSIGNMENTS stores the assignment of assets to a loan as collateral. |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_ASSET_ASSIGNMENTS.ASSET_ID | LNS_ASSETS |
LNS.LNS_ASSET_ASSIGNMENTS does not reference any database object
LNS.LNS_ASSET_ASSIGNMENTS is referenced by following:
Description: | Borrower Summary Table |
---|
LNS.LNS_BORROWER_SUMMARIES does not reference any database object
LNS.LNS_BORROWER_SUMMARIES is referenced by following:
Description: | Loan Conditions Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_COND_ASSIGNMENTS.CONDITION_ID | LNS_CONDITIONS |
LNS.LNS_CONDITIONS does not reference any database object
LNS.LNS_CONDITIONS is referenced by following:
Description: | Loan Condition Assignment 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 |
LNS.LNS_COND_ASSIGNMENTS does not reference any database object
LNS.LNS_COND_ASSIGNMENTS is referenced by following:
Description: | Loans Custom Schedule Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_CUSTOM_PAYMNT_SCHEDS.LOAN_ID | % |
LNS.LNS_CUSTOM_PAYMNT_SCHEDS does not reference any database object
LNS.LNS_CUSTOM_PAYMNT_SCHEDS is referenced by following:
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 Key Column | Foreign Table |
---|---|
LNS_DEFAULT_DISTRIBS_ALL.CODE_COMBINATION_ID | GL_CODE_COMBINATIONS |
LNS_DEFAULT_DISTRIBS_ALL.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
LNS.LNS_DEFAULT_DISTRIBS_ALL does not reference any database object
LNS.LNS_DEFAULT_DISTRIBS_ALL is referenced by following:
Description: | This table stores header level disbursement information |
---|
LNS.LNS_DISB_HEADERS does not reference any database object
LNS.LNS_DISB_HEADERS is referenced by following:
Description: | This table stores disbursement changes |
---|
LNS.LNS_DISB_HISTORIES_H does not reference any database object
LNS.LNS_DISB_HISTORIES_H is referenced by following:
Description: | Stores line level disbursement information |
---|
LNS.LNS_DISB_LINES does not reference any database object
LNS.LNS_DISB_LINES is referenced by following:
Description: | Loans Distributions Table - stores actual accounting distributions for a give loan_id |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_DISTRIBUTIONS.LOAN_ID | % |
LNS.LNS_DISTRIBUTIONS does not reference any database object
LNS.LNS_DISTRIBUTIONS is referenced by following:
Description: | This table stores actionable events for a loan class |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_EVENT_ACTIONS.EVENT_ID | LNS_EVENTS |
LNS.LNS_EVENTS does not reference any database object
LNS.LNS_EVENTS is referenced by following:
Description: | This table stores actionable events for a Loan type and loan class |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_EVENT_ACTIONS.EVENT_ID | LNS_EVENTS |
Foreign Key Column | Foreign Table |
---|---|
LNS_EVT_ACTION_HISTORY_H.EVENT_ACTION_ID | LNS_EVENT_ACTIONS |
LNS.LNS_EVENT_ACTIONS does not reference any database object
LNS.LNS_EVENT_ACTIONS is referenced by following:
Description: | This table stores the information about workflow actions performed for a Loan event |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_EVT_ACTION_HISTORY_H.EVENT_ACTION_ID | LNS_EVENT_ACTIONS |
LNS_EVT_ACTION_HISTORY_H.LOAN_ID | % |
LNS.LNS_EVT_ACTION_HISTORY_H does not reference any database object
LNS.LNS_EVT_ACTION_HISTORY_H is referenced by following:
Description: | Loan Fees Setup Table |
---|
LNS.LNS_FEES_ALL does not reference any database object
LNS.LNS_FEES_ALL is referenced by following:
Description: | Loan Fees Assignment Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_FEE_ASSIGNMENTS.LOAN_ID | % |
LNS.LNS_FEE_ASSIGNMENTS does not reference any database object
LNS.LNS_FEE_ASSIGNMENTS is referenced by following:
Description: | Loans Fees Schedules Table |
---|
LNS.LNS_FEE_SCHEDULES does not reference any database object
LNS.LNS_FEE_SCHEDULES is referenced by following:
Description: | Interest Rate Headers table |
---|
LNS.LNS_INT_RATE_HEADERS does not reference any database object
LNS.LNS_INT_RATE_HEADERS is referenced by following:
Description: | Interest Rate Lines Table |
---|
LNS.LNS_INT_RATE_LINES does not reference any database object
LNS.LNS_INT_RATE_LINES is referenced by following:
Description: |
---|
LNS.LNS_LOAN_API_ERRORS_GT does not reference any database object
LNS.LNS_LOAN_API_ERRORS_GT is referenced by following:
Description: |
---|
LNS.LNS_LOAN_CREATE_ERRORS_GT does not reference any database object
LNS.LNS_LOAN_CREATE_ERRORS_GT is referenced by following:
Description: | This table stores all the documents related to a Source Object |
---|
LNS.LNS_LOAN_DOCUMENTS does not reference any database object
LNS.LNS_LOAN_DOCUMENTS is referenced by following:
Description: |
---|
APPS.LNS_LOAN_DTLS_ALL_MV does not reference any database object
APPS.LNS_LOAN_DTLS_ALL_MV is referenced by following:
Description: | Loans Header 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 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 |
LNS.LNS_LOAN_HEADERS_ALL does not reference any database object
LNS.LNS_LOAN_HEADERS_ALL is referenced by following:
Description: | Loan History Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_LOAN_HISTORIES_H.LOAN_ID | LNS_LOAN_HEADERS_ALL |
LNS.LNS_LOAN_HISTORIES_H does not reference any database object
LNS.LNS_LOAN_HISTORIES_H is referenced by following:
Description: | Loan Lines Table |
---|
LNS.LNS_LOAN_LINES does not reference any database object
LNS.LNS_LOAN_LINES is referenced by following:
Description: | Loan Product Setup 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 |
LNS.LNS_LOAN_PRODUCTS_ALL does not reference any database object
LNS.LNS_LOAN_PRODUCTS_ALL is referenced by following:
Description: | Loan Product Setup Read-Only Column Names Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_LOAN_PRODUCT_FLAGS.LOAN_PRODUCT_ID | LNS_LOAN_PRODUCTS_ALL |
LNS.LNS_LOAN_PRODUCT_FLAGS does not reference any database object
LNS.LNS_LOAN_PRODUCT_FLAGS is referenced by following:
Description: | Loan Product Setup Lines 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 Key Column | Foreign Table |
---|---|
LNS_LOAN_PRODUCT_LINES.PARENT_PRODUCT_LINES_ID | LNS_LOAN_PRODUCT_LINES |
LNS.LNS_LOAN_PRODUCT_LINES does not reference any database object
LNS.LNS_LOAN_PRODUCT_LINES is referenced by following:
Description: | Loan Types Setup Table |
---|
LNS.LNS_LOAN_TYPES does not reference any database object
LNS.LNS_LOAN_TYPES is referenced by following:
Description: | Loan Participants 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 |
LNS.LNS_PARTICIPANTS does not reference any database object
LNS.LNS_PARTICIPANTS is referenced by following:
Description: | Loan Interest Rate Schedule Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_RATE_SCHEDULES.TERM_ID | % |
LNS.LNS_RATE_SCHEDULES does not reference any database object
LNS.LNS_RATE_SCHEDULES is referenced by following:
Description: | Loans System Options 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 |
LNS.LNS_SYSTEM_OPTIONS_ALL does not reference any database object
LNS.LNS_SYSTEM_OPTIONS_ALL is referenced by following:
Description: | Loans Terms Table |
---|
Foreign Key Column | Foreign Table |
---|---|
LNS_TERMS.LOAN_ID | LNS_LOAN_HEADERS_ALL |
LNS.LNS_TERMS does not reference any database object
LNS.LNS_TERMS is referenced by following:
APPS.LNS_AEL_GL_V is not referenced by any database object
APPS.LNS_AMORTIZATION_SCHEDULES_V is not referenced by any database object
APPS.LNS_AM_SCHEDS_DTL_V is not referenced by any database object
APPS.LNS_AR_AMORTIZATIONS_V is not referenced by any database object
APPS.LNS_LOAN_INFO is not referenced by any database object
APPS.LNS_LOAN_PAYMENT_SUMMARY_V is not referenced by any database object
APPS.LNS_LOAN_SUMMARY_V is not referenced by any database object
APPS.LNS_PAY_SUM_YEARLY_V is not referenced by any database object
APPS.LNS_RECEIVABLE_ACTIVITIES_V is not referenced by any database object
APPS.LNS_REC_ACT_ADJ_V is not referenced by any database object
APPS.LNS_SL_GL_V2 is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |