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_SEEDED_FUNCTIONS_PVT dependencies on OKL_STREAMS_REP_V

Line 6254: okl_streams_rep_v str,

6250: IS
6251: SELECT NVL(SUM(sele.amount),0)
6252: FROM okl_strm_elements sele,
6253: --okl_streams str, MGAAP 7263041
6254: okl_streams_rep_v str,
6255: okl_strm_type_v sty
6256: WHERE sele.stm_id = str.id
6257: AND str.sty_id = sty.id
6258: AND UPPER(sty.stream_type_purpose) = 'LEASE_INCOME'

Line 6287: okl_streams_rep_v str,

6283: CURSOR line (p_contract_line_id NUMBER) IS
6284: SELECT NVL(SUM(sele.amount),0)
6285: FROM okl_strm_elements sele,
6286: --okl_streams str, MGAAP 7263041
6287: okl_streams_rep_v str,
6288: okl_strm_type_v sty
6289: WHERE sele.stm_id = str.id
6290: AND str.sty_id = sty.id
6291: AND UPPER(sty.name) = 'PRE-TAX INCOME'

Line 11044: okl_streams_rep_v str,

11040: SELECT NVL(str.link_hist_stream_id,-1) link_hist_stream_id,
11041: NVL(SUM(sele.amount),0) amount
11042: FROM okl_strm_elements sele,
11043: --okl_streams str, MGAAP 7263041
11044: okl_streams_rep_v str,
11045: okl_strm_type_v sty,
11046: okc_k_headers_b CHR,
11047: okc_statuses_b sts
11048: WHERE sele.stm_id = str.id

Line 11075: okl_streams_rep_v str,

11071: SELECT NVL(str.link_hist_stream_id,-1) link_hist_stream_id,
11072: NVL(SUM(sele.amount),0) amount
11073: FROM okl_strm_elements sele,
11074: --okl_streams str, MGAAP 7263041
11075: okl_streams_rep_v str,
11076: okl_strm_type_v sty,
11077: okc_k_headers_b CHR,
11078: okc_statuses_b sts,
11079: okc_k_lines_b cle,

Line 12803: FROM okl_streams_rep_v stm,

12799: cp_stream_type_id NUMBER,
12800: cp_trx_date DATE) IS
12801: SELECT SUM (NVL (ste.amount, 0)) amount_due
12802: --FROM okl_streams stm,
12803: FROM okl_streams_rep_v stm,
12804: okl_strm_type_b sty,
12805: okl_strm_elements ste
12806: WHERE stm.khr_id = cp_contract_id
12807: AND stm.kle_id = cp_contract_line_id

Line 13232: okl_streams_rep_v stm,

13228: p_sty_id NUMBER) IS
13229: SELECT NVL(SUM(sel.amount),0)
13230: FROM okl_strm_elements sel,
13231: --okl_streams stm, MGAAP 7263041
13232: okl_streams_rep_v stm,
13233: okl_strm_type_v sty
13234: WHERE sty.id = p_sty_id
13235: AND stm.sty_id = sty.id
13236: AND stm.say_code = 'CURR'

Line 13254: okl_streams_rep_v stm,

13250: CURSOR line_reporting_csr (c_contract_line_id IN NUMBER, cp_trx_date IN DATE, p_sty_id NUMBER) IS
13251: SELECT NVL(SUM(sel.amount),0)
13252: FROM okl_strm_elements sel,
13253: --okl_streams stm, MGAAP 7263041
13254: okl_streams_rep_v stm,
13255: okl_strm_type_v sty
13256: WHERE sty.id = p_sty_id
13257: AND stm.sty_id = sty.id
13258: AND stm.say_code = 'CURR' -- reporting streams are current

Line 13292: okl_streams_rep_v stm,

13288: p_sty_id NUMBER) IS
13289: SELECT NVL(sel.amount,0) amount
13290: FROM okl_strm_elements sel,
13291: --okl_streams stm, MGAAP 7263041
13292: okl_streams_rep_v stm,
13293: okl_strm_type_v sty
13294: WHERE sty.id = p_sty_id
13295: AND stm.sty_id = sty.id
13296: AND stm.say_code = 'CURR'

Line 14629: ,okl_streams_rep_v str

14625: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS
14626: SELECT NVL(SUM(sele.amount),0)
14627: FROM okl_strm_elements sele
14628: --,okl_streams str MGAAP 7263041
14629: ,okl_streams_rep_v str
14630: ,okl_strm_type_v sty
14631: ,okc_k_lines_b line
14632: ,okc_line_styles_b style
14633: ,okc_statuses_b sts

Line 14736: ,okl_streams_rep_v str

14732: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE ,cp_contract_line_id okc_k_lines_b.id%TYPE) IS
14733: SELECT NVL(SUM(sele.amount),0)
14734: FROM okl_strm_elements sele
14735: --,okl_streams str MGAAP 7263041
14736: ,okl_streams_rep_v str
14737: ,okl_strm_type_v sty
14738: ,okc_k_lines_b line
14739: ,okc_line_styles_b style
14740: -- ,okc_statuses_b sts