[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 |