[Home] [Help]
View: OKL_LA_PASSTHROUGH_HDR_UV
Product: | OKL - Lease and Finance Management |
Description: | Passthrough fee user interface view capturing basic passthrough information |
Implementation/DBA Data: |
APPS.OKL_LA_PASSTHROUGH_HDR_UV
|
View Text
SELECT PPH.ID
, PPH.CLE_ID
, PPH.DNZ_CHR_ID
, PPH.PASSTHRU_START_DATE
, PPH.PAYOUT_BASIS
, LKP_PYT_BASIS.MEANING PAYOUT_BASIS_NAME
, PPH.EFFECTIVE_FROM
, PPH.EFFECTIVE_TO
, PPH.PASSTHRU_TERM
, PPH.PAYOUT_BASIS_FORMULA
, PPH.PASSTHRU_STREAM_TYPE_ID
, STYT.NAME
FROM OKL_STRM_TYPE_TL STYT
, OKL_PARTY_PAYMENT_HDR PPH
, FND_LOOKUPS LKP_PYT_BASIS
WHERE STYT.ID (+) = PPH.PASSTHRU_STREAM_TYPE_ID
AND STYT.LANGUAGE (+) = USERENV('LANG')
AND LKP_PYT_BASIS.LOOKUP_CODE (+) = PPH.PAYOUT_BASIS
AND LKP_PYT_BASIS.LOOKUP_TYPE (+) = 'OKL_PAYOUT_BASIS'
Columns
Name |
ID |
CLE_ID |
DNZ_CHR_ID |
PASSTHRU_START_DATE |
PAYOUT_BASIS |
PAYOUT_BASIS_NAME |
EFFECTIVE_FROM |
EFFECTIVE_TO |
PASSTHRU_TERM |
PAYOUT_BASIS_FORMULA |
PASSTHRU_STREAM_TYPE_ID |
NAME |