View: OKL_BPD_CSH_PRORATE_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_CSH_PRORATE_UV

View Text

SELECT STYV.STY_ID STY_ID
, STYV.STY_NAME
, STYV.STY_PURPOSE_MEANING
, CATV.ID CAT_ID
, -1 ID
, TO_NUMBER(OKL_CASH_APPLN_RULE_PVT.GET_STRM_TYP_ALLOCS(CATV.ID
, STYV.STY_ID
, 'PRO'
, 'SEQ')) SEQUENCE_NUMBER
, OKL_CASH_APPLN_RULE_PVT.GET_STRM_TYP_ALLOCS(CATV.ID
, STYV.STY_ID
, 'PRO'
, 'SAT') STREAM_ALLC_TYPE
, CATV.ORG_ID
FROM OKL_STRM_TMPT_ALL_TYPES_UV STYV
, OKL_CASH_ALLCTN_RLS CATV
WHERE NVL(OKL_CASH_APPLN_RULE_PVT.GET_STRM_TYP_ALLOCS(CATV.ID
, STYV.STY_ID
, 'PRO'
, 'SAT')
, 'PRO') = 'PRO'

Columns