FND Design Data [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: ViewAPPS.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