VIEW: APPS.OKL_LA_PASSTHROUGH_HDR_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'