DBA Data[Home] [Help]

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_STREAMS_REP_V

Line 9830: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041

9826: orig_stm.sty_id,
9827: orig_stm.kle_id,
9828: sty.name
9829: --FROM okl_streams new_stm,
9830: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041
9831: okl_prod_strm_types psty,
9832: okl_k_headers khr,
9833: --okl_streams orig_stm,
9834: okl_streams_rep_v orig_stm, -- MGAAP 7263041

Line 9834: okl_streams_rep_v orig_stm, -- MGAAP 7263041

9830: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041
9831: okl_prod_strm_types psty,
9832: okl_k_headers khr,
9833: --okl_streams orig_stm,
9834: okl_streams_rep_v orig_stm, -- MGAAP 7263041
9835: okl_strm_type_v sty
9836: WHERE khr.id = p_khr_id
9837: --AND psty.pdt_id = khr.pdt_id
9838: AND psty.pdt_id = DECODE(OKL_STREAMS_SEC_PVT.GET_STREAMS_POLICY,

Line 9883: FROM okl_streams_rep_v orig_stm, -- MGAAP 7263041

9879: orig_stm.kle_id,
9880: sty.name,
9881: cle.lse_id
9882: --FROM okl_streams orig_stm,
9883: FROM okl_streams_rep_v orig_stm, -- MGAAP 7263041
9884: okl_prod_strm_types psty,
9885: okl_k_headers khr,
9886: okc_k_lines_b cle,
9887: okl_strm_type_v sty

Line 9901: FROM okl_streams_rep_v new_stm -- MGAAP 7263041

9897: AND cle.id(+) = orig_stm.kle_id
9898: AND cle.dnz_chr_id(+) = orig_stm.khr_id
9899: AND NOT EXISTS (SELECT 1
9900: --FROM okl_streams new_stm
9901: FROM okl_streams_rep_v new_stm -- MGAAP 7263041
9902: WHERE new_stm.khr_id = p_rbk_khr_id
9903: AND new_stm.say_code = 'CURR'
9904: AND new_stm.link_hist_stream_id = orig_stm.id)
9905: AND sty.id = orig_stm.sty_id

Line 11174: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041

11170: orig_stm.sty_id,
11171: orig_stm.kle_id,
11172: sty.name
11173: --FROM okl_streams new_stm,
11174: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041
11175: okl_prod_strm_types psty,
11176: okl_k_headers khr,
11177: --okl_streams orig_stm,
11178: okl_streams_rep_v orig_stm, -- MGAAP 7263041

Line 11178: okl_streams_rep_v orig_stm, -- MGAAP 7263041

11174: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041
11175: okl_prod_strm_types psty,
11176: okl_k_headers khr,
11177: --okl_streams orig_stm,
11178: okl_streams_rep_v orig_stm, -- MGAAP 7263041
11179: okl_strm_type_v sty
11180: WHERE khr.id = p_khr_id
11181: --AND psty.pdt_id = khr.pdt_id
11182: AND psty.pdt_id = NVL(p_product_id, khr.pdt_id) -- MGAAP 7263041