DBA Data[Home] [Help]

APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKL_STREAMS_REP_V

Line 3305: FROM okl_streams_rep_v str, -- Bug# 10091594

3301: IS
3302: SELECT
3303: str.sty_id sty_id
3304: --FROM okl_streams str,
3305: FROM okl_streams_rep_v str, -- Bug# 10091594
3306: okl_strm_type_b sty
3307: WHERE str.sty_id = sty.id
3308: AND str.say_code = 'CURR'
3309: AND str.khr_id = chrid

Line 3319: FROM okl_streams_rep_v str, -- MGAAP 7263041

3315: SELECT
3316: sum(ste.amount) amount,
3317: str.sty_id sty_id
3318: --FROM okl_streams str,
3319: FROM okl_streams_rep_v str, -- MGAAP 7263041
3320: okl_strm_elements ste,
3321: okl_strm_type_b sty
3322: WHERE ste.stm_id = str.id
3323: AND str.sty_id = sty.id

Line 3337: FROM okl_streams_rep_v str, -- MGAAP 7263041

3333: SELECT
3334: sum(ste.amount) amount,
3335: str.sty_id sty_id
3336: --FROM okl_streams str,
3337: FROM okl_streams_rep_v str, -- MGAAP 7263041
3338: okl_strm_elements ste,
3339: okl_strm_type_b sty
3340: WHERE ste.stm_id = str.id
3341: AND str.sty_id = sty.id

Line 3355: FROM okl_streams_rep_v str, -- MGAAP 7263041

3351: IS
3352: SELECT
3353: sum(ste.amount)
3354: --FROM okl_streams str,
3355: FROM okl_streams_rep_v str, -- MGAAP 7263041
3356: okl_strm_elements ste,
3357: okl_strm_type_b sty
3358: WHERE ste.stm_id = str.id
3359: AND str.sty_id = sty.id

Line 3371: FROM okl_streams_rep_v str, -- MGAAP 7263041

3367: IS
3368: SELECT
3369: sum(ste.amount)
3370: --FROM okl_streams str,
3371: FROM okl_streams_rep_v str, -- MGAAP 7263041
3372: okl_strm_elements ste,
3373: okl_strm_type_b sty
3374: WHERE ste.stm_id = str.id
3375: AND str.sty_id = sty.id

Line 3443: FROM okl_streams_rep_v str, -- MGAAP 7263041

3439: SELECT
3440: sum(ste.amount) amount,
3441: str.sty_id sty_id
3442: --FROM okl_streams str,
3443: FROM okl_streams_rep_v str, -- MGAAP 7263041
3444: okl_strm_elements ste,
3445: okl_strm_type_b sty
3446: WHERE ste.stm_id = str.id
3447: AND str.sty_id = sty.id