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 37: okl_streams stm

33: nvl(stm.kle_id, -99) kle_id
34: FROM okl_k_headers oklh,
35: okc_k_headers_b okch,
36: okc_statuses_b khs,
37: okl_streams stm
38: WHERE oklh.id = okch.id
39: AND okch.contract_number = NVL (p_contract_number, okch.contract_number)
40: AND okch.scs_code IN ('LEASE', 'LOAN')
41: AND okch.sts_code = 'EVERGREEN'

Line 69: okl_streams stm,

65: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bkrpcy_sts
66: FROM okl_k_headers oklh,
67: okc_k_headers_b okch,
68: okc_statuses_b khs,
69: okl_streams stm,
70: hz_cust_accounts hca
71: WHERE oklh.id = okch.id
72: AND okch.contract_number = NVL (p_contract_number, okch.contract_number)
73: AND okch.cust_acct_id = hca.cust_account_id

Line 103: okl_streams stm,

99: stm.kle_id, --added by pgomes
100: stm.id stm_id,
101: sty.stream_type_purpose sty_name
102: FROM okl_k_headers_full_v khr,
103: okl_streams stm,
104: okl_strm_type_v sty
105: WHERE khr.id = p_khr_id
106: AND stm.khr_id = khr.id
107: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)

Line 120: FROM okl_streams stm,

116: -- Get Count of all streams
117: ------------------------------------------------------------
118: CURSOR c_stm_count_csr ( p_khr_id NUMBER, p_kle_id NUMBER) IS
119: SELECT count(*)
120: FROM okl_streams stm,
121: okl_strm_type_v sty
122: WHERE stm.khr_id = p_khr_id
123: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
124: AND stm.sty_id = sty.id

Line 136: FROM okl_streams stm,

132: -- Get Count of specific stream type
133: ------------------------------------------------------------
134: CURSOR c_sty_count_csr ( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_purpose VARCHAR2 ) IS
135: SELECT count(*)
136: FROM okl_streams stm,
137: okl_strm_type_v sty
138: WHERE stm.khr_id = p_khr_id
139: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
140: AND stm.sty_id = sty.id

Line 150: FROM okl_streams stm,

146: -- Get Copy parameters
147: ------------------------------------------------------------
148: /*CURSOR c_copy_params_csr ( p_khr_id NUMBER) IS
149: SELECT stm.kle_id, stm.say_code, stm.active_yn
150: FROM okl_streams stm,
151: okl_strm_type_v sty
152: WHERE stm.khr_id = p_khr_id
153: AND stm.sty_id = sty.id
154: AND stm.say_code = 'CURR'

Line 171: FROM okl_streams stm,

167: -- Get Sty Id for a line and purpose
168: ------------------------------------------------------------
169: CURSOR get_prim_sty_id_csr( p_khr_id NUMBER, p_kle_id NUMBER, p_sty_purpose VARCHAR2 ) IS
170: SELECT stm.sty_id
171: FROM okl_streams stm,
172: okl_strm_type_v sty
173: WHERE stm.khr_id = p_khr_id
174: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
175: AND stm.sty_id = sty.id

Line 185: FROM okl_streams stm,

181: -- Get Stm attributes
182: ------------------------------------------------------------
183: /*CURSOR get_stm_attrs_csr ( p_khr_id NUMBER, p_sty_name VARCHAR2 ) IS
184: SELECT stm.kle_id
185: FROM okl_streams stm,
186: okl_strm_type_v sty
187: WHERE stm.khr_id = p_khr_id
188: AND stm.sty_id = sty.id
189: AND stm.say_code = 'CURR'

Line 201: FROM okl_streams stm,

197: SELECT TRUNC(MAX( ste.STREAM_ELEMENT_DATE )) upper_stream_date
198: FROM okl_strm_elements ste
199: WHERE ste.stm_id IN (
200: SELECT stm.id
201: FROM okl_streams stm,
202: okl_strm_type_v sty
203: WHERE stm.khr_id = p_khr_id
204: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
205: AND stm.sty_id = sty.id

Line 219: FROM okl_streams stm,

215: FROM okl_strm_elements ste
216: WHERE ste.stream_element_date <= p_max_date
217: AND ste.stm_id IN (
218: SELECT stm.id
219: FROM okl_streams stm,
220: okl_strm_type_v sty
221: WHERE stm.khr_id = p_khr_id
222: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
223: AND stm.sty_id = sty.id

Line 243: okl_streams stm,

239: (
240: SELECT stm.id, to_number(rule_information6) amt
241: FROM okc_rules_b a,
242: okc_rule_groups_b b,
243: okl_streams stm,
244: okl_strm_type_v sty
245: WHERE a.dnz_chr_id = p_khr_id
246: AND a.rgp_id = b.id
247: AND b.rgd_code = 'LALEVL'

Line 268: FROM okl_streams stm,

264: SELECT MIN (ste.amount) amount
265: FROM okl_strm_elements ste
266: WHERE ste.stm_id IN (
267: SELECT stm.id
268: FROM okl_streams stm,
269: okl_strm_type_v sty
270: WHERE stm.khr_id = p_khr_id
271: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
272: AND stm.sty_id = sty.id

Line 286: FROM okl_streams stm,

282: SELECT MAX( ste.STREAM_ELEMENT_DATE ) evergreen_element_date
283: FROM okl_strm_elements ste
284: WHERE ste.stm_id IN (
285: SELECT stm.id
286: FROM okl_streams stm,
287: okl_strm_type_v sty
288: WHERE stm.khr_id = p_khr_id
289: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)
290: AND stm.sty_id = sty.id

Line 355: ,okl_streams_v stm

351: ,stm.khr_id
352: ,stm.kle_id
353: ,stm.sty_id
354: FROM okl_strm_elements_v ste
355: ,okl_streams_v stm
356: ,okl_strm_type_v sty
357: WHERE ste.stm_id = stm.id
358: AND stm.khr_id = p_khr_id
359: AND NVL(stm.kle_id, -99) = NVL(p_kle_id, -99)

Line 389: FROM okl_streams_v stm

385: CURSOR l_stream_csr(cp_khr_id IN NUMBER
386: ,cp_kle_id IN NUMBER
387: ,cp_sty_id IN NUMBER) IS
388: SELECT stm.id
389: FROM okl_streams_v stm
390: WHERE stm.khr_id = cp_khr_id
391: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, -99)
392: AND stm.sty_id = cp_sty_id
393: AND stm.say_code = 'CURR'

Line 443: p_selv_rec Okl_Streams_Pub.selv_rec_type;

439: cns_fee_evergreen constant varchar2(50) := 'FEE_RENEWAL';
440: cns_fee constant varchar2(50) := 'FEE_PAYMENT';
441:
442: -- Stream elements
443: p_selv_rec Okl_Streams_Pub.selv_rec_type;
444: x_selv_rec Okl_Streams_Pub.selv_rec_type;
445:
446: l_selv_rec Okl_Sel_Pvt.selv_rec_type;
447: lx_selv_rec Okl_Sel_Pvt.selv_rec_type;

Line 444: x_selv_rec Okl_Streams_Pub.selv_rec_type;

440: cns_fee constant varchar2(50) := 'FEE_PAYMENT';
441:
442: -- Stream elements
443: p_selv_rec Okl_Streams_Pub.selv_rec_type;
444: x_selv_rec Okl_Streams_Pub.selv_rec_type;
445:
446: l_selv_rec Okl_Sel_Pvt.selv_rec_type;
447: lx_selv_rec Okl_Sel_Pvt.selv_rec_type;
448: l_init_selv_rec Okl_Sel_Pvt.selv_rec_type;

Line 455: l_kle_id okl_streams.kle_id%TYPE;

451: -- Declare local variables used in the program
452: ------------------------------------------------------------
453:
454: l_khr_id okl_k_headers.id%TYPE;
455: l_kle_id okl_streams.kle_id%TYPE;
456: l_sty_id okl_strm_type_v.id%TYPE;
457: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
458: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
459: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;

Line 460: l_stm_id OKL_STREAMS_V.ID%TYPE;

456: l_sty_id okl_strm_type_v.id%TYPE;
457: l_evrgrn_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
458: l_evrgrn_prim_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
459: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
460: l_stm_id OKL_STREAMS_V.ID%TYPE;
461: l_sel_id Okl_strm_elements_v.sel_id%TYPE;
462:
463: l_amount NUMBER;
464:

Line 487: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

483: l_api_name CONSTANT VARCHAR2(30) := 'BILL_EVERGREEN_STREAMS';
484: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
485:
486: -- Streams Record
487: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
488: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
489: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
490:
491: -- Temporary variables

Line 488: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;

484: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
485:
486: -- Streams Record
487: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
488: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
489: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
490:
491: -- Temporary variables
492: l_evergreen_rent_count NUMBER;

Line 489: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;

485:
486: -- Streams Record
487: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
488: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
489: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
490:
491: -- Temporary variables
492: l_evergreen_rent_count NUMBER;
493: l_contract_rent_count NUMBER;

Line 657: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id

653: CLOSE get_prim_sty_id_csr;
654: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for RENT: ' || l_primary_sty_id);
655:
656: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
657: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
658: ,p_primary_sty_id => l_primary_sty_id
659: ,p_dependent_sty_purpose => cns_evergreen_rent
660: ,x_return_status => l_return_status
661: ,x_dependent_sty_id => l_sty_id);

Line 700: Okl_Streams_Pub.create_streams(

696: l_stmv_rec.comments := 'Evergreen Billing';
697:
698: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating EVERGREEN RENT Streams');
699:
700: Okl_Streams_Pub.create_streams(
701: p_api_version => p_api_version,
702: p_init_msg_list => p_init_msg_list,
703: x_return_status => x_return_status,
704: x_msg_count => x_msg_count,

Line 768: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id

764: CLOSE get_prim_sty_id_csr;
765: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for SERVICE AND MAINTENANCE: ' || l_primary_sty_id);
766:
767: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
768: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
769: ,p_primary_sty_id => l_primary_sty_id
770: ,p_dependent_sty_purpose => cns_sm_evergreen
771: ,x_return_status => l_return_status
772: ,x_dependent_sty_id => l_sty_id);

Line 811: Okl_Streams_Pub.create_streams(

807: l_stmv_rec.comments := 'Evergreen Billing';
808:
809:
810: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating SERVICE AND MAINTENANCE EVERGREEN Streams');
811: Okl_Streams_Pub.create_streams(
812: p_api_version => p_api_version,
813: p_init_msg_list => p_init_msg_list,
814: x_return_status => x_return_status,
815: x_msg_count => x_msg_count,

Line 879: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id

875: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for ESTIMATED PROPERTY TAX: ' || l_primary_sty_id);
876:
877:
878: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
879: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
880: ,p_primary_sty_id => l_primary_sty_id
881: ,p_dependent_sty_purpose => cns_ept_evergreen
882: ,x_return_status => l_return_status
883: ,x_dependent_sty_id => l_sty_id);

Line 914: Okl_Streams_Pub.create_streams(

910: l_stmv_rec.comments := 'Evergreen Billing';
911:
912: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating ESTIMATED PERSONAL PROPERTY TAX EVERGREEN Streams');
913:
914: Okl_Streams_Pub.create_streams(
915: p_api_version => p_api_version,
916: p_init_msg_list => p_init_msg_list,
917: x_return_status => x_return_status,
918: x_msg_count => x_msg_count,

Line 994: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id

990: CLOSE get_prim_sty_id_csr;
991: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for FEE: ' || l_primary_sty_id);
992:
993: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
994: OKL_STREAMS_UTIL.get_dependent_stream_type(p_khr_id => l_khr_id
995: ,p_primary_sty_id => l_primary_sty_id
996: ,p_dependent_sty_purpose => cns_fee_evergreen
997: ,x_return_status => l_return_status
998: ,x_dependent_sty_id => l_sty_id);

Line 1029: Okl_Streams_Pub.create_streams(

1025: l_stmv_rec.comments := 'Evergreen Billing';
1026:
1027:
1028: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating FEE EVERGREEN Streams');
1029: Okl_Streams_Pub.create_streams(
1030: p_api_version => p_api_version,
1031: p_init_msg_list => p_init_msg_list,
1032: x_return_status => x_return_status,
1033: x_msg_count => x_msg_count,

Line 1426: OKL_STREAMS_UTIL.get_primary_stream_type(p_khr_id => l_investor_agrmt_id

1422: CLOSE get_prim_sty_id_csr;
1423: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Sty id for ' || l_evrgrn_prim_strm_purpose || ': ' || l_primary_sty_id); */
1424:
1425: --change for User Defined Streams, by pjgomes, on 18 Oct 2004
1426: OKL_STREAMS_UTIL.get_primary_stream_type(p_khr_id => l_investor_agrmt_id
1427: ,p_primary_sty_purpose => l_evrgrn_strm_purpose
1428: ,x_return_status => l_return_status
1429: ,x_primary_sty_id => l_sty_id);
1430:

Line 1475: Okl_Streams_Pub.create_streams(

1471: END IF;
1472:
1473: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -- Creating ' || l_evrgrn_strm_purpose || ' Stream');
1474:
1475: Okl_Streams_Pub.create_streams(
1476: p_api_version => p_api_version,
1477: p_init_msg_list => p_init_msg_list,
1478: x_return_status => x_return_status,
1479: x_msg_count => x_msg_count,