[Home] [Help] [Dependency Information]
Object Name: | OKL_AMORT_SCHED_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRINCIPAL | NUMBER | Principal Amount | ||
INTEREST | NUMBER | Interest Amount | ||
PRINCIPAL_BALANCE | NUMBER | Principal Balance Amount | ||
LOAN_PAYMENT | NUMBER | Loan Payment Amount | ||
DATE_FROM | DATE | Date From | ||
DATE_TO | DATE | Date To | ||
PAYMENT_TYPE | VARCHAR2 | (240) | Type of Payment | |
TRX_REQ_ID | NUMBER | Yes | Request identifier | |
AMORT_REPORT_FLAG | VARCHAR2 | (1) | Yes | Summary or Detail indicator |
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
ORDER_BY | NUMBER | ORDER BY COLUMN | ||
PAYMENT_TYPE_FORMS | VARCHAR2 | (240) | Payment Type decoded for Forms Display | |
PROJ_INTEREST_RATE | NUMBER | Projected Interest Rate |
Cut, paste (and edit) the following text to query this object:
SELECT PRINCIPAL
, INTEREST
, PRINCIPAL_BALANCE
, LOAN_PAYMENT
, DATE_FROM
, DATE_TO
, PAYMENT_TYPE
, TRX_REQ_ID
, AMORT_REPORT_FLAG
, CURRENCY_CODE
, ORDER_BY
, PAYMENT_TYPE_FORMS
, PROJ_INTEREST_RATE
FROM APPS.OKL_AMORT_SCHED_V;
APPS.OKL_AMORT_SCHED_V is not referenced by any database object
|
|
|