View: OKL_LA_PASSTHROUGH_HDR_UV

Product:	OKL - Leasing 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