[Home] [Help]
View: OKL_ST_MAP_PERIODIC_INDEX_V
Product: | OKL - Lease and Finance Management |
Description: | View on OKL_SIF_FEES & OKL_STREAM_INTERFACES. |
Implementation/DBA Data: |
APPS.OKL_ST_MAP_PERIODIC_INDEX_V
|
View Text
SELECT DISTINCT SFEB.FEE_INDEX_NUMBER FEE_INDEX_NUMBER
, SFEB.SFE_TYPE SFE_TYPE
, SFEB.DESCRIPTION DESCRIPTION
, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, SFEB.STRUCTURE STRUCTURE
, SFEB.DAYS_IN_MONTH DAYS_IN_MONTH
, SFEB.DAYS_IN_YEAR DAYS_IN_YEAR
, SFEB.DOWN_PAYMENT_AMOUNT
FROM OKL_SIF_FEES SFEB
, OKL_STREAM_INTERFACES SIFB
WHERE SFEB.SIF_ID = SIFB.ID ORDER BY SFEB.FEE_INDEX_NUMBER
Columns
Name |
FEE_INDEX_NUMBER |
SFE_TYPE |
DESCRIPTION |
TRANSACTION_NUMBER |
STRUCTURE |
DAYS_IN_MONTH |
DAYS_IN_YEAR |
DOWN_PAYMENT_AMOUNT |