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_LA_STREAM_PVT dependencies on OKL_STRM_ELEMENTS

Line 1711: FROM okl_strm_elements ele,

1707: WHERE LINE_ID = p_line_id;
1708: -- cursor to fetch the stream element amount
1709: CURSOR get_strmele_csr(p_khr_id NUMBER, p_strm_id NUMBER, p_sty_id NUMBER) IS
1710: SELECT ele.amount
1711: FROM okl_strm_elements ele,
1712: okl_streams str
1713: WHERE ele.stm_id = p_strm_id
1714: AND str.khr_id = p_khr_id
1715: AND str.sty_id = p_sty_id

Line 2631: l_last_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;

2627: l_old_cle_id okc_k_lines_b.ID%TYPE;
2628: l_old_sty_id okl_strm_type_b.ID%TYPE;
2629: l_old_str_stmv_rec okl_streams_pub.stmv_rec_type;
2630: l_old_acr_stmv_rec okl_streams_pub.stmv_rec_type;
2631: l_last_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
2632: l_last_acr_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
2633: --srsreeni bug 5869271 end add
2634: l_purpose_code VARCHAR2(30) := p_purpose;
2635: -- To get the header information

Line 2632: l_last_acr_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;

2628: l_old_sty_id okl_strm_type_b.ID%TYPE;
2629: l_old_str_stmv_rec okl_streams_pub.stmv_rec_type;
2630: l_old_acr_stmv_rec okl_streams_pub.stmv_rec_type;
2631: l_last_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
2632: l_last_acr_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
2633: --srsreeni bug 5869271 end add
2634: l_purpose_code VARCHAR2(30) := p_purpose;
2635: -- To get the header information
2636: CURSOR c_hdr

Line 3886: FROM okl_strm_elements ele,

3882:
3883: CURSOR l_billedrents_csr(chrId NUMBER, kleid NUMBER, p VARCHAR2)
3884: IS
3885: SELECT nvl(sum(ele.AMOUNT),0)
3886: FROM okl_strm_elements ele,
3887: okl_streams str,
3888: okl_strm_type_b sty
3889: WHERE str.khr_id = chrId
3890: AND nvl(str.kle_id, -1) = kleid

Line 4486: FROM okl_strm_elements ele,

4482: p_kle_id NUMBER,
4483: p_purpose VARCHAR2)
4484: IS
4485: SELECT NVL(SUM(ele.AMOUNT),0) amount
4486: FROM okl_strm_elements ele,
4487: okl_streams str,
4488: okl_strm_type_b sty
4489: WHERE str.khr_id = p_chr_id
4490: AND NVL(str.kle_id, -1) = p_kle_id

Line 4504: FROM okl_strm_elements ele,

4500: p_kle_id NUMBER,
4501: p_purpose VARCHAR2)
4502: IS
4503: SELECT NVL(SUM(ele.AMOUNT),0) amount
4504: FROM okl_strm_elements ele,
4505: okl_streams str,
4506: okl_strm_type_b sty
4507: WHERE str.khr_id = p_chr_id
4508: AND NVL(str.kle_id, -1) = p_kle_id

Line 5137: FROM okl_strm_elements ele

5133: ele.accrued_yn,
5134: ele.comments,
5135: ele.stm_id stm_id,
5136: ele.se_line_number se_line_number
5137: FROM okl_strm_elements ele
5138: WHERE ele.stm_id = stmid
5139: ORDER BY ele.stream_element_date;
5140:
5141: CURSOR l_stmp_yn_csr(khrid NUMBER, p VARCHAR2) IS

Line 5783: From okl_strm_elements ele,

5779:
5780: -- Changed this cursor for user defined streams
5781: Cursor l_secdep_csr( chrId NUMBER,pdtId NUMBER, pp VARCHAR2 ) is
5782: Select ele.id
5783: From okl_strm_elements ele,
5784: okl_streams str,
5785: --okl_strm_type_v sty,
5786: OKL_STRM_TMPT_LINES_UV sty,
5787: okl_k_lines_full_v kle,

Line 5841: WHERE EXISTS (SELECT ID FROM OKL_STRM_ELEMENTS ele WHERE ele.STM_ID = str.ID AND ele.DATE_BILLED IS NULL )

5837: IS
5838:
5839: SELECT 'N'
5840: FROM OKL_STREAMS str
5841: WHERE EXISTS (SELECT ID FROM OKL_STRM_ELEMENTS ele WHERE ele.STM_ID = str.ID AND ele.DATE_BILLED IS NULL )
5842: AND str.KHR_ID = chrId
5843: AND str.STY_ID = styId
5844: AND str.SAY_CODE = status
5845: AND nvl(str.purpose_code, 'ORIGIN') = pp;

Line 6481: , OKL_STRM_ELEMENTS SEL

6477: , SEL.AMOUNT
6478: , SEL.SE_LINE_NUMBER
6479: , SEL.COMMENTS -- vdamerla Forward Ported Bug 6344223
6480: FROM OKL_STREAMS STM
6481: , OKL_STRM_ELEMENTS SEL
6482: , OKL_STRM_TYPE_B STY -- vdamerla Forward Ported Bug 6082209
6483: WHERE SEL.STM_ID = STM.ID
6484: AND STM.KHR_ID = cp_chr_id
6485: AND STM.KLE_ID = cp_cle_id

Line 6580: , OKL_STRM_ELEMENTS SEL

6576: , SEL.AMOUNT
6577: , SEL.SE_LINE_NUMBER
6578: , SEL.COMMENTS
6579: FROM OKL_STREAMS STM
6580: , OKL_STRM_ELEMENTS SEL
6581: , OKL_STRM_TYPE_B STY
6582: WHERE SEL.STM_ID = STM.ID
6583: AND STM.KHR_ID = cp_chr_id
6584: AND STM.KLE_ID IS NULL