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_STREAMS_UTIL dependencies on OKL_PRODUCTS

Line 894: FROM okl_k_headers_full_v khr, okl_products pdt

890: IS
891:
892: CURSOR cntrct_csr (l_khr_id NUMBER)IS
893: SELECT pdt.reporting_pdt_id, khr.start_date
894: FROM okl_k_headers_full_v khr, okl_products pdt
895: WHERE khr.id = l_khr_id
896: AND khr.pdt_id = pdt.id;
897:
898: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS

Line 1000: FROM okl_k_headers_full_v khr, okl_products pdt

996: IS
997:
998: CURSOR cntrct_csr (l_khr_id NUMBER)IS
999: SELECT pdt.reporting_pdt_id, khr.start_date
1000: FROM okl_k_headers_full_v khr, okl_products pdt
1001: WHERE khr.id = l_khr_id
1002: AND khr.pdt_id = pdt.id;
1003:
1004: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS

Line 1409: FROM okl_k_headers_full_v khr, okl_products pdt

1405: IS
1406:
1407: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1408: SELECT pdt.reporting_pdt_id, khr.start_date
1409: FROM okl_k_headers_full_v khr, okl_products pdt
1410: WHERE khr.id = l_khr_id
1411: AND khr.pdt_id = pdt.id;
1412:
1413: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS

Line 1514: FROM okl_k_headers_full_v khr, okl_products pdt

1510: IS
1511:
1512: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1513: SELECT pdt.reporting_pdt_id, khr.start_date
1514: FROM okl_k_headers_full_v khr, okl_products pdt
1515: WHERE khr.id = l_khr_id
1516: AND khr.pdt_id = pdt.id;
1517:
1518: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS

Line 1623: FROM okl_k_headers_full_v khr, okl_products pdt

1619: IS
1620:
1621: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1622: SELECT pdt.reporting_pdt_id, khr.start_date
1623: FROM okl_k_headers_full_v khr, okl_products pdt
1624: WHERE khr.id = l_khr_id
1625: AND khr.pdt_id = pdt.id;
1626:
1627: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS

Line 1849: okl_products_v pdt,

1845: SELECT
1846: gts.pricing_engine
1847: FROM
1848: okl_k_headers khr,
1849: okl_products_v pdt,
1850: okl_ae_tmpt_sets_v aes,
1851: OKL_ST_GEN_TMPT_SETS gts
1852: WHERE
1853: khr.pdt_id = pdt.id AND

Line 1901: okl_products_v pdt,

1897: SELECT
1898: gts.name
1899: FROM
1900: okl_k_headers khr,
1901: okl_products_v pdt,
1902: okl_ae_tmpt_sets_v aes,
1903: OKL_ST_GEN_TMPT_SETS gts
1904: WHERE
1905: khr.pdt_id = pdt.id AND

Line 2893: ,okl_products pdt

2889: from okl_sys_acct_opts_all sao
2890: ,okl_stream_interfaces osi
2891: ,okc_k_headers_all_b chr
2892: ,okl_k_headers khr
2893: ,okl_products pdt
2894: ,okl_ae_tmpt_sets_all aes
2895: ,okl_st_gen_tmpt_sets_all gts
2896: Where sao.org_id = chr.authoring_org_id
2897: and chr.id = osi.khr_id

Line 3027: ,okl_products pdt

3023: select gts.deal_type deal_type
3024: ,gts.interest_calc_meth_code interest_calc_meth_code
3025: from okc_k_headers_all_b chr
3026: ,okl_k_headers khr
3027: ,okl_products pdt
3028: ,okl_ae_tmpt_sets_all aes
3029: ,okl_st_gen_tmpt_sets_all gts
3030: Where chr.id = p_khr_id
3031: and chr.id = khr.id

Line 3150: ,okl_products pdt

3146: FROM okl_stream_interfaces osi
3147: ,okl_sif_yields siyb
3148: ,okc_k_headers_all_b chr
3149: ,okl_k_headers khr
3150: ,okl_products pdt
3151: ,okl_ae_tmpt_sets_all aes
3152: ,okl_st_gen_tmpt_sets_all gts
3153: WHERE osi.transaction_number = p_trx_id
3154: AND siyb.sif_id = osi.id