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 5656: okl_streams_rep_v str,

5652: IS
5653: SELECT NVL(SUM(sele.amount),0)
5654: FROM okl_strm_elements sele,
5655: --okl_streams str, MGAAP 7263041
5656: okl_streams_rep_v str,
5657: okl_strm_type_v sty
5658: WHERE sele.stm_id = str.id
5659: AND str.sty_id = sty.id
5660: AND UPPER(sty.stream_type_purpose) = 'LEASE_INCOME'

Line 5689: okl_streams_rep_v str,

5685: CURSOR line (p_contract_line_id NUMBER) IS
5686: SELECT NVL(SUM(sele.amount),0)
5687: FROM okl_strm_elements sele,
5688: --okl_streams str, MGAAP 7263041
5689: okl_streams_rep_v str,
5690: okl_strm_type_v sty
5691: WHERE sele.stm_id = str.id
5692: AND str.sty_id = sty.id
5693: AND UPPER(sty.name) = 'PRE-TAX INCOME'

Line 10187: okl_streams_rep_v str,

10183: SELECT NVL(str.link_hist_stream_id,-1) link_hist_stream_id,
10184: NVL(SUM(sele.amount),0) amount
10185: FROM okl_strm_elements sele,
10186: --okl_streams str, MGAAP 7263041
10187: okl_streams_rep_v str,
10188: okl_strm_type_v sty,
10189: okc_k_headers_b CHR,
10190: okc_statuses_b sts
10191: WHERE sele.stm_id = str.id

Line 11715: FROM okl_streams_rep_v stm,

11711: cp_stream_type_id NUMBER,
11712: cp_trx_date DATE) IS
11713: SELECT SUM (NVL (ste.amount, 0)) amount_due
11714: --FROM okl_streams stm,
11715: FROM okl_streams_rep_v stm,
11716: okl_strm_type_b sty,
11717: okl_strm_elements ste
11718: WHERE stm.khr_id = cp_contract_id
11719: AND stm.kle_id = cp_contract_line_id

Line 12035: okl_streams_rep_v stm,

12031: p_sty_id NUMBER) IS
12032: SELECT NVL(SUM(sel.amount),0)
12033: FROM okl_strm_elements sel,
12034: --okl_streams stm, MGAAP 7263041
12035: okl_streams_rep_v stm,
12036: okl_strm_type_v sty
12037: WHERE sty.id = p_sty_id
12038: AND stm.sty_id = sty.id
12039: AND stm.say_code = 'CURR'

Line 12057: okl_streams_rep_v stm,

12053: CURSOR line_reporting_csr (c_contract_line_id IN NUMBER, cp_trx_date IN DATE, p_sty_id NUMBER) IS
12054: SELECT NVL(SUM(sel.amount),0)
12055: FROM okl_strm_elements sel,
12056: --okl_streams stm, MGAAP 7263041
12057: okl_streams_rep_v stm,
12058: okl_strm_type_v sty
12059: WHERE sty.id = p_sty_id
12060: AND stm.sty_id = sty.id
12061: AND stm.say_code = 'CURR' -- reporting streams are current

Line 12095: okl_streams_rep_v stm,

12091: p_sty_id NUMBER) IS
12092: SELECT NVL(sel.amount,0) amount
12093: FROM okl_strm_elements sel,
12094: --okl_streams stm, MGAAP 7263041
12095: okl_streams_rep_v stm,
12096: okl_strm_type_v sty
12097: WHERE sty.id = p_sty_id
12098: AND stm.sty_id = sty.id
12099: AND stm.say_code = 'CURR'

Line 13397: ,okl_streams_rep_v str

13393: CURSOR c_pre_tax_csr(cp_contract_id okc_k_headers_b.id%TYPE) IS
13394: SELECT NVL(SUM(sele.amount),0)
13395: FROM okl_strm_elements sele
13396: --,okl_streams str MGAAP 7263041
13397: ,okl_streams_rep_v str
13398: ,okl_strm_type_v sty
13399: ,okc_k_lines_b line
13400: ,okc_line_styles_b style
13401: ,okc_statuses_b sts

Line 13504: ,okl_streams_rep_v str

13500: 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
13501: SELECT NVL(SUM(sele.amount),0)
13502: FROM okl_strm_elements sele
13503: --,okl_streams str MGAAP 7263041
13504: ,okl_streams_rep_v str
13505: ,okl_strm_type_v sty
13506: ,okc_k_lines_b line
13507: ,okc_line_styles_b style
13508: -- ,okc_statuses_b sts