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_VARIABLE_INTEREST_PVT dependencies on OKC_STATUSES_B

Line 1530: ,okc_statuses_b sts

1526: okl_strm_elements sel
1527: ,okl_streams str
1528: ,okl_strm_type_v sty
1529: ,okc_k_lines_b cle
1530: ,okc_statuses_b sts
1531: WHERE sel.stm_id = str.id
1532: AND str.khr_id = p_contract_id
1533: AND str.say_code = 'CURR'
1534: AND str.active_yn = 'Y'

Line 1582: ,okc_statuses_b sts

1578: okl_strm_elements sel
1579: ,okl_streams str
1580: ,okl_strm_type_v sty
1581: ,okc_k_lines_b cle
1582: ,okc_statuses_b sts
1583: WHERE sel.stm_id = str.id
1584: AND str.khr_id = p_contract_id
1585: AND str.say_code = 'CURR'
1586: AND str.active_yn = 'Y'

Line 2843: okc_statuses_b sts

2839: CURSOR l_assets_csr(p_contract_id NUMBER) IS
2840: SELECT cle.id
2841: FROM okc_k_lines_v cle,
2842: okc_line_styles_b sty,
2843: okc_statuses_b sts
2844: WHERE cle.lse_id = sty.id
2845: AND cle.dnz_chr_id = p_contract_id
2846: AND sty.lty_code = 'FREE_FORM1'
2847: AND cle.sts_code = sts.code

Line 6516: okc_statuses_b khs,

6512: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bankruptcy_sts, --- Added as part of Bug# 14119181
6513: ppm.name product_name
6514: FROM okc_k_headers_b chr,
6515: okl_k_headers khr,
6516: okc_statuses_b khs,
6517: okl_product_parameters_v ppm,
6518: hz_cust_accounts hca --- Added as part of Bug# 14119181
6519: WHERE CHR.CONTRACT_NUMBER = NVL(p_contract_number,CHR.CONTRACT_NUMBER)
6520: AND khr.deal_type IN ('LOAN','LEASEDF','LOAN-REVOLVING','LEASEST','LEASEOP')