FND Design Data [Home] [Help]

Table: LNS_LOAN_HEADERS_ALL

Product: LNS - Loans
Description: Loans Header Table
Implementation/DBA Data: TableLNS.LNS_LOAN_HEADERS_ALL
Primary Key: LNS_LOAN_HEADERS_ALL_PK
  1. ColumnLOAN_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
LNS_LOAN_HEADERS_ALL FK Joins to TableHZ_PARTIES LNS_LOAN_HEADERS_ALL.PRIMARY_BORROWER_ID
LNS_LOAN_HEADERS_ALL FK Joins to TableHZ_PARTIES LNS_LOAN_HEADERS_ALL.CONTACT_PERS_PARTY_ID
LNS_LOAN_HEADERS_ALL FK Joins to TableHZ_PARTIES LNS_LOAN_HEADERS_ALL.CONTACT_REL_PARTY_ID
LNS_LOAN_HEADERS_ALL FK Joins to TableHZ_CUST_ACCOUNTS LNS_LOAN_HEADERS_ALL.CUST_ACCOUNT_ID
LNS_LOAN_HEADERS_ALL FK Joins to TableRA_CUSTOMER_TRX_ALL LNS_LOAN_HEADERS_ALL.REFERENCE_ID
LNS_LOAN_HEADERS_ALL FK Joins to TableRA_CUST_TRX_TYPES_ALL LNS_LOAN_HEADERS_ALL.REFERENCE_TYPE_ID
LNS_LOAN_HEADERS_ALL FK Joins to TableHZ_CUST_ACCT_SITES_ALL LNS_LOAN_HEADERS_ALL.BILL_TO_ACCT_SITE_ID
LNS_LOAN_HEADERS_ALL FK Joins to Table% LNS_LOAN_HEADERS_ALL.PRODUCT_ID
LNS_LOAN_HEADERS_ALL FK Joins to TableJTF_RS_RESOURCE_EXTNS LNS_LOAN_HEADERS_ALL.LOAN_ASSIGNED_TO
LNS_LOAN_HEADERS_ALL FK Joins to TableJTF_RS_RESOURCE_EXTNS LNS_LOAN_HEADERS_ALL.LOAN_APPROVED_BY
LNS_LOAN_HEADERS_ALL FK Joins to TableHR_ALL_ORGANIZATION_UNITS LNS_LOAN_HEADERS_ALL.ORG_ID
TableLNS_LOAN_HISTORIES_H FK Joins to LNS_LOAN_HEADERS_ALL LNS_LOAN_HISTORIES_H.LOAN_ID
TableLNS_PARTICIPANTS FK Joins to LNS_LOAN_HEADERS_ALL LNS_PARTICIPANTS.LOAN_ID
TableLNS_TERMS FK Joins to LNS_LOAN_HEADERS_ALL LNS_TERMS.LOAN_ID