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_EVERGREEN_BILLING_PVT dependencies on OKL_STREAMS

Line 28: okl_streams stm

24: nvl(stm.kle_id, -99) kle_id
25: FROM okl_k_headers oklh,
26: okc_k_headers_b okch,
27: okc_statuses_b khs,
28: okl_streams stm
29: WHERE oklh.id = okch.id
30: AND okch.contract_number = NVL (p_contract_number, okch.contract_number)
31: AND okch.scs_code IN ('LEASE', 'LOAN')
32: AND okch.sts_code = 'EVERGREEN'

Line 57: okl_streams stm,

53: stm.kle_id, --added by pgomes
54: stm.id stm_id,
55: sty.stream_type_purpose sty_name
56: FROM okl_k_headers_full_v khr,
57: okl_streams stm,
58: okl_strm_type_v sty
59: WHERE khr.id = p_khr_id
60: AND stm.khr_id = khr.id
61: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)

Line 74: FROM okl_streams stm,

70: -- Get Count of all streams
71: ------------------------------------------------------------
72: CURSOR c_stm_count_csr ( p_khr_id NUMBER, p_kle_id NUMBER) IS
73: SELECT count(*)
74: FROM okl_streams stm,
75: okl_strm_type_v sty
76: WHERE stm.khr_id = p_khr_id
77: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
78: AND stm.sty_id = sty.id

Line 90: FROM okl_streams stm,

86: -- Get Count of specific stream type
87: ------------------------------------------------------------
88: CURSOR c_sty_count_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_purpose VARCHAR2 ) IS
89: SELECT count(*)
90: FROM okl_streams stm,
91: okl_strm_type_v sty
92: WHERE stm.khr_id = p_khr_id
93: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
94: AND stm.sty_id = sty.id

Line 104: FROM okl_streams stm,

100: -- Get Copy parameters
101: ------------------------------------------------------------
102: /*CURSOR c_copy_params_csr ( p_khr_id NUMBER) IS
103: SELECT stm.kle_id, stm.say_code, stm.active_yn
104: FROM okl_streams stm,
105: okl_strm_type_v sty
106: WHERE stm.khr_id = p_khr_id
107: AND stm.sty_id = sty.id
108: AND stm.say_code = 'CURR'

Line 125: FROM okl_streams stm,

121: -- Get Sty Id for a line and purpose
122: ------------------------------------------------------------
123: CURSOR get_prim_sty_id_csr( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_purpose VARCHAR2 ) IS
124: SELECT stm.sty_id
125: FROM okl_streams stm,
126: okl_strm_type_v sty
127: WHERE stm.khr_id = p_khr_id
128: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
129: AND stm.sty_id = sty.id

Line 139: FROM okl_streams stm,

135: -- Get Stm attributes
136: ------------------------------------------------------------
137: /*CURSOR get_stm_attrs_csr ( p_khr_id NUMBER, p_sty_name VARCHAR2 ) IS
138: SELECT stm.kle_id
139: FROM okl_streams stm,
140: okl_strm_type_v sty
141: WHERE stm.khr_id = p_khr_id
142: AND stm.sty_id = sty.id
143: AND stm.say_code = 'CURR'

Line 155: FROM okl_streams stm,

151: SELECT TRUNC(MAX( ste.STREAM_ELEMENT_DATE )) upper_stream_date
152: FROM okl_strm_elements ste
153: WHERE ste.stm_id IN (
154: SELECT stm.id
155: FROM okl_streams stm,
156: okl_strm_type_v sty
157: WHERE stm.khr_id = p_khr_id
158: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
159: AND stm.sty_id = sty.id

Line 173: FROM okl_streams stm,

169: FROM okl_strm_elements ste
170: WHERE ste.stream_element_date <= p_max_date
171: AND ste.stm_id IN (
172: SELECT stm.id
173: FROM okl_streams stm,
174: okl_strm_type_v sty
175: WHERE stm.khr_id = p_khr_id
176: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
177: AND stm.sty_id = sty.id

Line 197: okl_streams stm,

193: (
194: SELECT stm.id, to_number(rule_information6) amt
195: FROM okc_rules_b a,
196: okc_rule_groups_b b,
197: okl_streams stm,
198: okl_strm_type_v sty
199: WHERE a.dnz_chr_id = p_khr_id
200: AND a.rgp_id = b.id
201: AND b.rgd_code = 'LALEVL'

Line 222: FROM okl_streams stm,

218: SELECT MIN (ste.amount) amount
219: FROM okl_strm_elements ste
220: WHERE ste.stm_id IN (
221: SELECT stm.id
222: FROM okl_streams stm,
223: okl_strm_type_v sty
224: WHERE stm.khr_id = p_khr_id
225: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
226: AND stm.sty_id = sty.id

Line 240: FROM okl_streams stm,

236: SELECT MAX( ste.STREAM_ELEMENT_DATE ) evergreen_element_date
237: FROM okl_strm_elements ste
238: WHERE ste.stm_id IN (
239: SELECT stm.id
240: FROM okl_streams stm,
241: okl_strm_type_v sty
242: WHERE stm.khr_id = p_khr_id
243: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
244: AND stm.sty_id = sty.id

Line 309: ,okl_streams_v stm

305: ,stm.khr_id
306: ,stm.kle_id
307: ,stm.sty_id
308: FROM okl_strm_elements_v ste
309: ,okl_streams_v stm
310: ,okl_strm_type_v sty
311: WHERE ste.stm_id = stm.id
312: AND stm.khr_id = p_khr_id
313: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)

Line 343: FROM okl_streams_v stm

339: CURSOR l_stream_csr(cp_khr_id IN NUMBER
340: ,cp_kle_id IN NUMBER
341: ,cp_sty_id IN NUMBER) IS
342: SELECT stm.id
343: FROM okl_streams_v stm
344: WHERE stm.khr_id = cp_khr_id
345: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, -99)
346: AND stm.sty_id = cp_sty_id
347: AND stm.say_code = 'CURR'

Line 397: p_selv_rec Okl_Streams_Pub.selv_rec_type;

393: cns_fee_evergreen constant varchar2(50) := 'FEE_RENEWAL';
394: cns_fee constant varchar2(50) := 'FEE_PAYMENT';
395:
396: -- Stream elements
397: p_selv_rec Okl_Streams_Pub.selv_rec_type;
398: x_selv_rec Okl_Streams_Pub.selv_rec_type;
399:
400: l_selv_rec Okl_Sel_Pvt.selv_rec_type;
401: lx_selv_rec Okl_Sel_Pvt.selv_rec_type;

Line 398: x_selv_rec Okl_Streams_Pub.selv_rec_type;

394: cns_fee constant varchar2(50) := 'FEE_PAYMENT';
395:
396: -- Stream elements
397: p_selv_rec Okl_Streams_Pub.selv_rec_type;
398: x_selv_rec Okl_Streams_Pub.selv_rec_type;
399:
400: l_selv_rec Okl_Sel_Pvt.selv_rec_type;
401: lx_selv_rec Okl_Sel_Pvt.selv_rec_type;
402: l_init_selv_rec Okl_Sel_Pvt.selv_rec_type;

Line 409: l_kle_id okl_streams.kle_id%TYPE;

405: -- Declare local variables used in the program
406: ------------------------------------------------------------
407:
408: l_khr_id okl_k_headers.id%TYPE;
409: l_kle_id okl_streams.kle_id%TYPE;
410: l_sty_id okl_strm_type_v.id%TYPE;
411: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
412: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
413: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;

Line 414: l_stm_id OKL_STREAMS_V.ID%TYPE;

410: l_sty_id okl_strm_type_v.id%TYPE;
411: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
412: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
413: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
414: l_stm_id OKL_STREAMS_V.ID%TYPE;
415: l_sel_id Okl_strm_elements_v.sel_id%TYPE;
416:
417: l_amount NUMBER;
418:

Line 441: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

437: l_api_name CONSTANT VARCHAR2(30) := 'BILL_EVERGREEN_STREAMS';
438: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
439:
440: -- Streams Record
441: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
442: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
443: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
444:
445: -- Temporary variables

Line 442: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;

438: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
439:
440: -- Streams Record
441: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
442: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
443: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
444:
445: -- Temporary variables
446: l_evergreen_rent_count NUMBER;

Line 443: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;

439:
440: -- Streams Record
441: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
442: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
443: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
444:
445: -- Temporary variables
446: l_evergreen_rent_count NUMBER;
447: l_contract_rent_count NUMBER;

Line 585: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id

581: CLOSE get_prim_sty_id_csr;
582: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for RENT: ' || l_primary_sty_id);
583:
584: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
585: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
586: ,p_primary_sty_id => l_primary_sty_id
587: ,p_dependent_sty_purpose => cns_evergreen_rent
588: ,x_return_status => l_return_status
589: ,x_dependent_sty_id => l_sty_id);

Line 628: Okl_Streams_Pub.create_streams(

624: l_stmv_rec.comments := 'Evergreen Billing';
625:
626: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating EVERGREEN RENT Streams');
627:
628: Okl_Streams_Pub.create_streams(
629: p_api_version => p_api_version,
630: p_init_msg_list => p_init_msg_list,
631: x_return_status => x_return_status,
632: x_msg_count => x_msg_count,

Line 696: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id

692: CLOSE get_prim_sty_id_csr;
693: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for SERVICE AND MAINTENANCE: ' || l_primary_sty_id);
694:
695: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
696: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
697: ,p_primary_sty_id => l_primary_sty_id
698: ,p_dependent_sty_purpose => cns_sm_evergreen
699: ,x_return_status => l_return_status
700: ,x_dependent_sty_id => l_sty_id);

Line 739: Okl_Streams_Pub.create_streams(

735: l_stmv_rec.comments := 'Evergreen Billing';
736:
737:
738: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating SERVICE AND MAINTENANCE EVERGREEN Streams');
739: Okl_Streams_Pub.create_streams(
740: p_api_version => p_api_version,
741: p_init_msg_list => p_init_msg_list,
742: x_return_status => x_return_status,
743: x_msg_count => x_msg_count,

Line 807: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id

803: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for ESTIMATED PROPERTY TAX: ' || l_primary_sty_id);
804:
805:
806: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
807: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
808: ,p_primary_sty_id => l_primary_sty_id
809: ,p_dependent_sty_purpose => cns_ept_evergreen
810: ,x_return_status => l_return_status
811: ,x_dependent_sty_id => l_sty_id);

Line 842: Okl_Streams_Pub.create_streams(

838: l_stmv_rec.comments := 'Evergreen Billing';
839:
840: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating ESTIMATED PERSONAL PROPERTY TAX EVERGREEN Streams');
841:
842: Okl_Streams_Pub.create_streams(
843: p_api_version => p_api_version,
844: p_init_msg_list => p_init_msg_list,
845: x_return_status => x_return_status,
846: x_msg_count => x_msg_count,

Line 906: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id

902: CLOSE get_prim_sty_id_csr;
903: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for FEE: ' || l_primary_sty_id);
904:
905: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
906: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
907: ,p_primary_sty_id => l_primary_sty_id
908: ,p_dependent_sty_purpose => cns_fee_evergreen
909: ,x_return_status => l_return_status
910: ,x_dependent_sty_id => l_sty_id);

Line 941: Okl_Streams_Pub.create_streams(

937: l_stmv_rec.comments := 'Evergreen Billing';
938:
939:
940: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating FEE EVERGREEN Streams');
941: Okl_Streams_Pub.create_streams(
942: p_api_version => p_api_version,
943: p_init_msg_list => p_init_msg_list,
944: x_return_status => x_return_status,
945: x_msg_count => x_msg_count,

Line 1335: OKL_STREAMS_UTIL.get_primary_stream_type(p_khr_id => l_investor_agrmt_id

1331: CLOSE get_prim_sty_id_csr;
1332: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for ' || l_evrgrn_prim_strm_purpose || ': ' || l_primary_sty_id); */
1333:
1334: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
1335: OKL_STREAMS_UTIL.get_primary_stream_type(p_khr_id => l_investor_agrmt_id
1336: ,p_primary_sty_purpose => l_evrgrn_strm_purpose
1337: ,x_return_status => l_return_status
1338: ,x_primary_sty_id => l_sty_id);
1339:

Line 1384: Okl_Streams_Pub.create_streams(

1380: END IF;
1381:
1382: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating ' || l_evrgrn_strm_purpose || ' Stream');
1383:
1384: Okl_Streams_Pub.create_streams(
1385: p_api_version => p_api_version,
1386: p_init_msg_list => p_init_msg_list,
1387: x_return_status => x_return_status,
1388: x_msg_count => x_msg_count,