DBA Data[Home] [Help]

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_STREAMS_REP_V

Line 8156: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041

8152: orig_stm.sty_id,
8153: orig_stm.kle_id,
8154: sty.name
8155: --FROM okl_streams new_stm,
8156: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041
8157: okl_prod_strm_types psty,
8158: okl_k_headers khr,
8159: --okl_streams orig_stm,
8160: okl_streams_rep_v orig_stm, -- MGAAP 7263041

Line 8160: okl_streams_rep_v orig_stm, -- MGAAP 7263041

8156: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041
8157: okl_prod_strm_types psty,
8158: okl_k_headers khr,
8159: --okl_streams orig_stm,
8160: okl_streams_rep_v orig_stm, -- MGAAP 7263041
8161: okl_strm_type_v sty
8162: WHERE khr.id = p_khr_id
8163: --AND psty.pdt_id = khr.pdt_id
8164: AND psty.pdt_id = DECODE(OKL_STREAMS_SEC_PVT.GET_STREAMS_POLICY,

Line 8209: FROM okl_streams_rep_v orig_stm, -- MGAAP 7263041

8205: orig_stm.kle_id,
8206: sty.name,
8207: cle.lse_id
8208: --FROM okl_streams orig_stm,
8209: FROM okl_streams_rep_v orig_stm, -- MGAAP 7263041
8210: okl_prod_strm_types psty,
8211: okl_k_headers khr,
8212: okc_k_lines_b cle,
8213: okl_strm_type_v sty

Line 8227: FROM okl_streams_rep_v new_stm -- MGAAP 7263041

8223: AND cle.id(+) = orig_stm.kle_id
8224: AND cle.dnz_chr_id(+) = orig_stm.khr_id
8225: AND NOT EXISTS (SELECT 1
8226: --FROM okl_streams new_stm
8227: FROM okl_streams_rep_v new_stm -- MGAAP 7263041
8228: WHERE new_stm.khr_id = p_rbk_khr_id
8229: AND new_stm.say_code = 'CURR'
8230: AND new_stm.link_hist_stream_id = orig_stm.id)
8231: AND sty.id = orig_stm.sty_id

Line 9303: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041

9299: orig_stm.sty_id,
9300: orig_stm.kle_id,
9301: sty.name
9302: --FROM okl_streams new_stm,
9303: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041
9304: okl_prod_strm_types psty,
9305: okl_k_headers khr,
9306: --okl_streams orig_stm,
9307: okl_streams_rep_v orig_stm, -- MGAAP 7263041

Line 9307: okl_streams_rep_v orig_stm, -- MGAAP 7263041

9303: FROM okl_streams_rep_v new_stm, -- MGAAP 7263041
9304: okl_prod_strm_types psty,
9305: okl_k_headers khr,
9306: --okl_streams orig_stm,
9307: okl_streams_rep_v orig_stm, -- MGAAP 7263041
9308: okl_strm_type_v sty
9309: WHERE khr.id = p_khr_id
9310: --AND psty.pdt_id = khr.pdt_id
9311: AND psty.pdt_id = NVL(p_product_id, khr.pdt_id) -- MGAAP 7263041