VIEW: APPS.OKL_BPD_CSH_PRORATE_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'