DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKL_AMORT_SCHED_V

Object Details
Object Name: OKL_AMORT_SCHED_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.OKL_AMORT_SCHED_V references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_ALL_B
SynonymOKL_AMORT_SCHED_HDRS
SynonymOKL_AMORT_SCHED_LINES
SynonymOKL_TRX_REQUESTS

APPS.OKL_AMORT_SCHED_V is not referenced by any database object