[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | LNS_LOAN_SPLITS |
|---|---|
| Object Type: | TABLE |
| Owner: | LNS |
| Subobject Name: | |
| Status: | VALID |
Table for loan split requests
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| SYS_IL0000872473C00054$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LOAN_SPLIT_ID | NUMBER | (15) | Yes | Identifies the Loan split Request |
| LOAN_ID | NUMBER | (15) | Yes | Identifies the Loan |
| DESCRIPTION | VARCHAR2 | (30) | Loan split Request Description | |
| STATUS | VARCHAR2 | (30) | Loan Cancelation Request Status | |
| APPR_REJECT_DATE | DATE | Approved/Rejected Date | ||
| APPR_REJECT_BY | NUMBER | Approved/Rejected By | ||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | Object Version Number | |
| CREATION_DATE | DATE | Yes | Creation Date | |
| CREATED_BY | NUMBER | (15) | Yes | Created By |
| LAST_UPDATE_DATE | DATE | Yes | Last Update Date | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Last Updated By |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Last Update Login | |
| PRODUCT_ID | NUMBER | (15) | New loan product ID | |
| ORG_ID | NUMBER | (15) | New loan org ID | |
| LEGAL_ENTITY_ID | NUMBER | (15) | New loan legal entity ID | |
| LOAN_CLASS_CODE | VARCHAR2 | (30) | New loan class code | |
| LOAN_TYPE_ID | NUMBER | (15) | New loan type ID | |
| LOAN_PURPOSE_CODE | VARCHAR2 | (30) | New loan purpose code | |
| LOAN_DESCRIPTION | VARCHAR2 | (250) | New loan description | |
| LOAN_APPLICATION_DATE | DATE | New loan application Date | ||
| LOAN_CURRENCY | VARCHAR2 | (15) | New loan currency code | |
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | New loan exchange rate type | |
| EXCHANGE_DATE | DATE | New loan exchange date | ||
| EXCHANGE_RATE | NUMBER | New loan exchange rate | ||
| LOAN_ASSIGNED_TO | NUMBER | (15) | New loan assigned to | |
| PRIMARY_BORROWER_ID | NUMBER | (15) | New loan primary borrower ID | |
| CUST_ACCOUNT_ID | NUMBER | (15) | New loan account ID | |
| BILL_TO_ACCT_SITE_ID | NUMBER | (15) | New loan bill-to-account ID | |
| CONTACT_REL_PARTY_ID | NUMBER | (15) | New loan contact | |
| CONTACT_PERS_PARTY_ID | NUMBER | (15) | New loan contact | |
| REFERENCE_TYPE_ID | NUMBER | (15) | New loan trx type ID | |
| REQUESTED_AMOUNT | NUMBER | New loan amount | ||
| LOAN_START_DATE | DATE | New loan start date | ||
| LOAN_TERM | NUMBER | New loan term | ||
| LOAN_TERM_PERIOD | VARCHAR2 | (30) | New loan term period | |
| BALLOON_PAYMENT_TYPE | VARCHAR2 | (30) | New loan balloon type | |
| BALLOON_PAYMENT_AMOUNT | NUMBER | New loan balloon amount | ||
| BALLOON_TERM | NUMBER | New loan balloon term | ||
| LOAN_SUBTYPE | VARCHAR2 | (30) | New loan subtype | |
| CREDIT_REVIEW_FLAG | VARCHAR2 | (1) | New loan credit review flag | |
| COLLATERAL_PERCENT | NUMBER | New loan collateral percent | ||
| RATE_TYPE | VARCHAR2 | (30) | New loan rate type | |
| INDEX_RATE_ID | NUMBER | (15) | New loan rate index | |
| PAYMENT_CALC_METHOD | VARCHAR2 | (30) | New loan payment calculation method | |
| DAY_COUNT_METHOD | VARCHAR2 | (50) | New loan day count method | |
| AMORTIZATION_FREQUENCY | VARCHAR2 | (30) | New loan amortization frequency | |
| CALCULATION_METHOD | VARCHAR2 | (30) | New loan calculation method | |
| INTEREST_COMPOUNDING_FREQ | VARCHAR2 | (30) | New loan interest compounding frequency | |
| PRIN_PAYMENT_FREQUENCY | VARCHAR2 | (30) | New loan principal compounding frequency | |
| TERM_INDEX_DATE | DATE | New loan initial index date | ||
| INDEX_RATE | NUMBER | New loan initial index rate | ||
| SPREAD | NUMBER | New loan initial spread | ||
| INT_RATE | NUMBER | New loan initial interest rate | ||
| CUSTOM_SCHEDULE | CLOB | (4000) | New loan initial custom schedule | |
| CUSTOM_CALC_METHOD | VARCHAR2 | (30) | New loan custom calculation method | |
| PARTY_TYPE | VARCHAR2 | (30) | New loan borrower party type | |
| NEW_AM_SCHED_ID | NUMBER | New amortization schedule ID | ||
| NEW_LOAN_ID | NUMBER | New loan ID | ||
| LOAN_NUMBER | VARCHAR2 | (60) | New loan number |
Cut, paste (and edit) the following text to query this object:
SELECT LOAN_SPLIT_ID
, LOAN_ID
, DESCRIPTION
, STATUS
, APPR_REJECT_DATE
, APPR_REJECT_BY
, OBJECT_VERSION_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PRODUCT_ID
, ORG_ID
, LEGAL_ENTITY_ID
, LOAN_CLASS_CODE
, LOAN_TYPE_ID
, LOAN_PURPOSE_CODE
, LOAN_DESCRIPTION
, LOAN_APPLICATION_DATE
, LOAN_CURRENCY
, EXCHANGE_RATE_TYPE
, EXCHANGE_DATE
, EXCHANGE_RATE
, LOAN_ASSIGNED_TO
, PRIMARY_BORROWER_ID
, CUST_ACCOUNT_ID
, BILL_TO_ACCT_SITE_ID
, CONTACT_REL_PARTY_ID
, CONTACT_PERS_PARTY_ID
, REFERENCE_TYPE_ID
, REQUESTED_AMOUNT
, LOAN_START_DATE
, LOAN_TERM
, LOAN_TERM_PERIOD
, BALLOON_PAYMENT_TYPE
, BALLOON_PAYMENT_AMOUNT
, BALLOON_TERM
, LOAN_SUBTYPE
, CREDIT_REVIEW_FLAG
, COLLATERAL_PERCENT
, RATE_TYPE
, INDEX_RATE_ID
, PAYMENT_CALC_METHOD
, DAY_COUNT_METHOD
, AMORTIZATION_FREQUENCY
, CALCULATION_METHOD
, INTEREST_COMPOUNDING_FREQ
, PRIN_PAYMENT_FREQUENCY
, TERM_INDEX_DATE
, INDEX_RATE
, SPREAD
, INT_RATE
, CUSTOM_SCHEDULE
, CUSTOM_CALC_METHOD
, PARTY_TYPE
, NEW_AM_SCHED_ID
, NEW_LOAN_ID
, LOAN_NUMBER
FROM LNS.LNS_LOAN_SPLITS;
LNS.LNS_LOAN_SPLITS does not reference any database object
LNS.LNS_LOAN_SPLITS is referenced by following:
LNS
LNS_LOAN_SPLITS#
|
|
|
|