eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_STRM_TYPE_B

Line 8726: okl_strm_type_b sty,

8722: orig_stm.id orig_stm_id,
8723: orig_stm.sty_id,
8724: orig_stm.kle_id
8725: FROM okl_streams new_stm,
8726: okl_strm_type_b sty,
8727: okl_streams orig_stm,
8728: okl_party_payment_hdr pph
8729: WHERE new_stm.khr_id = p_khr_id
8730: AND new_stm.say_code = 'CURR'

Line 8767: okl_strm_type_b sty,

8763: orig_stm.sty_id,
8764: orig_stm.kle_id,
8765: cle.lse_id
8766: FROM okl_streams orig_stm,
8767: okl_strm_type_b sty,
8768: okc_k_lines_b cle,
8769: okl_party_payment_hdr pph
8770: WHERE orig_stm.khr_id = p_orig_khr_id
8771: AND orig_stm.say_code = 'CURR'

Line 9083: okl_strm_type_b sty,

9079: orig_stm.id orig_stm_id,
9080: orig_stm.sty_id,
9081: orig_stm.kle_id
9082: FROM okl_streams new_stm,
9083: okl_strm_type_b sty,
9084: okl_streams orig_stm
9085: WHERE new_stm.khr_id = p_khr_id
9086: AND new_stm.say_code = 'CURR'
9087: AND new_stm.sty_id = sty.id

Line 9121: okl_strm_type_b sty,

9117: orig_stm.sty_id,
9118: orig_stm.kle_id,
9119: cle.lse_id
9120: FROM okl_streams orig_stm,
9121: okl_strm_type_b sty,
9122: okc_k_lines_b cle
9123: WHERE orig_stm.khr_id = p_orig_khr_id
9124: AND orig_stm.say_code = 'CURR'
9125:

Line 10244: okl_strm_type_b sty,

10240: new_stm.id new_stm_id,
10241: orig_stm.id orig_stm_id
10242: FROM okl_pools pol,
10243: okl_pool_contents pcn,
10244: okl_strm_type_b sty,
10245: okl_streams new_stm,
10246: okl_streams orig_stm
10247: WHERE pcn.sty_id = sty.id
10248: AND pcn.pol_id = pol.id

Line 10318: okl_strm_type_b sty

10314: p_kle_id NUMBER)
10315: IS
10316: SELECT stm.id stm_id
10317: FROM okl_streams stm,
10318: okl_strm_type_b sty
10319: WHERE stm.khr_id = p_chr_id
10320: AND stm.kle_id = p_kle_id
10321: AND stm.sty_id = sty.id
10322: AND stm.say_code = 'CURR'

Line 10346: l_disb_adj_sty_id OKL_STRM_TYPE_B.id%TYPE;

10342: AND sel.date_billed IS NULL;
10343:
10344: l_undisb_adj_exists VARCHAR2(30);
10345:
10346: l_disb_adj_sty_id OKL_STRM_TYPE_B.id%TYPE;
10347: l_inv_agreement_id OKC_K_HEADERS_B.id%TYPE;
10348:
10349: BEGIN
10350: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 10784: okl_strm_type_b sty

10780: CURSOR curr_streams_csr(p_khr_id IN NUMBER) IS
10781: SELECT new_stm.id new_stm_id,
10782: new_stm.kle_id
10783: FROM okl_streams new_stm,
10784: okl_strm_type_b sty
10785: WHERE new_stm.khr_id = p_khr_id
10786: AND new_stm.say_code = 'WORK'
10787: AND new_stm.sty_id = sty.id
10788: AND nvl(new_stm.purpose_code,'XXX') <> 'REPORT' ----sechawla 12-mar-09 Added

Line 10801: okl_strm_type_b sty

10797: CURSOR curr_streams_secondary_csr(p_khr_id IN NUMBER) IS
10798: SELECT new_stm.id new_stm_id,
10799: new_stm.kle_id
10800: FROM okl_streams new_stm,
10801: okl_strm_type_b sty
10802: WHERE new_stm.khr_id = p_khr_id
10803: AND new_stm.say_code = 'WORK'
10804: AND new_stm.sty_id = sty.id
10805: AND new_stm.purpose_code = 'REPORT'