[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | LNS_LOAN_HEADERS_ALL_VL |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
MultiLingual view (a language resolved view of the data.)
View on LNS_LOAN_HEADERS_ALL_TL table. Used for MLS.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row id | |
| LOAN_ID | NUMBER | (15) | Yes | Loan Id |
| PROGRAM_ID | NUMBER | (15) | Program Id | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| OBJECT_VERSION_NUMBER | NUMBER | Yes | Object Version Number | |
| REQUEST_ID | NUMBER | (15) | Request Id | |
| LOAN_NUMBER | VARCHAR2 | (60) | Yes | Loan Number |
| LOAN_DESCRIPTION | VARCHAR2 | (250) | Loan Description in MLS | |
| REFERENCE_DESCRIPTION | VARCHAR2 | (250) | Reference Description in MLS | |
| INITIAL_LOAN_BALANCE | NUMBER | Yes | Initial Loan Balance | |
| LAST_PAYMENT_DATE | DATE | Last Payment Date | ||
| LAST_PAYMENT_AMOUNT | NUMBER | Last Payment Amount | ||
| LOAN_TERM | NUMBER | Yes | Loan Term | |
| LOAN_TERM_PERIOD | VARCHAR2 | (30) | Yes | Loan Term Period |
| LOAN_CURRENCY | VARCHAR2 | (15) | Yes | Loan Currency |
| LOAN_CLASS_CODE | VARCHAR2 | (30) | Loan Class Code | |
| LOAN_TYPE | VARCHAR2 | (30) | Loan Type | |
| LOAN_SUBTYPE | VARCHAR2 | (30) | Loan SubType | |
| LOAN_PURPOSE_CODE | VARCHAR2 | (30) | Loan Purpose Code | |
| AMORTIZED_TERM | NUMBER | Amortized Term | ||
| AMORTIZED_TERM_PERIOD | VARCHAR2 | (30) | Amortized Term Period | |
| LOAN_MATURITY_DATE | DATE | Loan Maturity Date | ||
| LOAN_START_DATE | DATE | Yes | Loan Start Date | |
| LOAN_APPLICATION_DATE | DATE | Yes | Loan Application Date | |
| LOAN_CLOSING_DATE | DATE | Loan 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 | |
| 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 Name | |
| REFERENCE_TYPE | VARCHAR2 | (30) | Reference Type | |
| 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 | Org Id |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | USSGL Transaction Code | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| 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) | Contact Pers Party Id | |
| CONTACT_REL_PARTY_ID | NUMBER | (15) | Contact Rel Party Id | |
| COLLATERAL_PERCENT | NUMBER | Collateral Percent | ||
| CREDIT_REVIEW_FLAG | VARCHAR2 | (1) | Credit Review flag | |
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange Rate Type | |
| EXCHANGE_DATE | DATE | Exchange Date | ||
| EXCHANGE_RATE | NUMBER | Exchange Rate | ||
| 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 | |
| BALLOON_PAYMENT_AMOUNT | NUMBER | Balloon Payment Amount | ||
| OPEN_LOAN_START_DATE | DATE | Open Loan Start Date | ||
| OPEN_LOAN_TERM | NUMBER | Open Loan Term | ||
| OPEN_LOAN_TERM_PERIOD | VARCHAR2 | (30) | Open Loan Term Period | |
| CURRENT_PHASE | VARCHAR2 | (30) | Current Phase | |
| OPEN_MATURITY_DATE | DATE | Open Maturity Date | ||
| FUNDS_RESERVED_FLAG | VARCHAR2 | (1) | Funds Reserved Flag | |
| FUNDS_CHECK_DATE | DATE | Funds Check Date | ||
| SUBSIDY_RATE | NUMBER | Subsidy Rate | ||
| APPLICATION_ID | NUMBER | (15) | Application Id | |
| CREATED_BY_MODULE | VARCHAR2 | (150) | Created By Module | |
| PARTY_TYPE | VARCHAR2 | (30) | Party Type | |
| FORGIVENESS_FLAG | VARCHAR2 | (1) | Identifies whether the loan is forgiveness enabled | |
| FORGIVENESS_PERCENT | NUMBER | This column defines the required forgiveness loanEMIPrincipal-to-value ratio for forgiveness enabled loan as a percentage of the loanEMI Principal |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, LOAN_ID
, PROGRAM_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, REQUEST_ID
, LOAN_NUMBER
, LOAN_DESCRIPTION
, REFERENCE_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
, PRODUCT_ID
, REQUESTED_AMOUNT
, FUNDED_AMOUNT
, REFERENCE_AMOUNT
, REFERENCE_NUMBER
, REFERENCE_NAME
, REFERENCE_TYPE
, 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
, COLLATERAL_PERCENT
, CREDIT_REVIEW_FLAG
, EXCHANGE_RATE_TYPE
, EXCHANGE_DATE
, EXCHANGE_RATE
, 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
, BALLOON_PAYMENT_AMOUNT
, OPEN_LOAN_START_DATE
, OPEN_LOAN_TERM
, OPEN_LOAN_TERM_PERIOD
, CURRENT_PHASE
, OPEN_MATURITY_DATE
, FUNDS_RESERVED_FLAG
, FUNDS_CHECK_DATE
, SUBSIDY_RATE
, APPLICATION_ID
, CREATED_BY_MODULE
, PARTY_TYPE
, FORGIVENESS_FLAG
, FORGIVENESS_PERCENT
FROM APPS.LNS_LOAN_HEADERS_ALL_VL;
APPS
LNS_LOAN_HEADERS_ALL
LNS_LOAN_HEADERS_ALL_TL
APPS
LNS_LOAN_HEADER_ALL_PKG
- show dependent code
LNS_WORK_FLOW
- show dependent code
|
|
|
|