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_ACCRUAL_SEC_PVT dependencies on OKL_STRM_TYPE_B

Line 90: okl_strm_type_b stytl

86: okl_pools op,
87: okl_k_headers khr,
88: -- Changed for User Defined Streams
89: --okl_strm_type_tl stytl
90: okl_strm_type_b stytl
91: WHERE op.khr_id = p_inv_id
92: AND opc.khr_id = p_khr_id
93: AND op.id = opc.pol_id
94: AND opc.khr_id = khr.id

Line 107: okl_strm_type_b sty

103: IS
104: SELECT opc.kle_id kle_id,
105: MIN(opc.streams_from_date) start_date
106: FROM okl_pool_contents opc,
107: okl_strm_type_b sty
108: WHERE opc.khr_id = p_khr_id
109: AND opc.sty_id = sty.id
110: --AND sty.code = 'RENT'
111: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')

Line 134: okl_strm_type_b stytl

130: okl_pools op,
131: okl_k_headers khr,
132: -- Changed for User Defined Streams
133: --okl_strm_type_tl stytl
134: okl_strm_type_b stytl
135: WHERE op.khr_id = p_inv_id
136: AND opc.khr_id = p_khr_id
137: AND op.id = opc.pol_id
138: AND opc.khr_id = khr.id

Line 152: okl_strm_type_b sty

148: IS
149: SELECT opc.kle_id kle_id,
150: MIN(opc.streams_from_date) start_date
151: FROM okl_pool_contents opc,
152: okl_strm_type_b sty
153: WHERE opc.khr_id = p_khr_id
154: AND opc.sty_id = sty.id
155: --AND sty.code = 'RENT'
156: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')

Line 166: okl_strm_type_b sty

162: IS
163: SELECT DISTINCT op.khr_id
164: FROM okl_pool_contents opc,
165: okl_pools op,
166: okl_strm_type_b sty
167: WHERE op.id = opc.pol_id
168: AND opc.khr_id = p_khr_id
169: AND opc.sty_id = sty.id
170: --AND sty.code = 'RENT';

Line 186: okl_strm_type_b strm

182: FROM okc_k_headers_b k,
183: okc_rule_groups_b rg,
184: okc_rules_b slh,
185: okc_rules_b sll,
186: okl_strm_type_b strm
187: WHERE slh.rule_information_category = 'LASLH'
188: AND slh.rgp_id = rg.id
189: AND sll.object2_id1 = to_char(slh.id)
190: AND sll.rgp_id = rg.id

Line 241: okl_strm_type_b sty

237: IS
238: SELECT DISTINCT op.khr_id
239: FROM okl_pool_contents opc,
240: okl_pools op,
241: okl_strm_type_b sty
242: WHERE op.id = opc.pol_id
243: AND opc.khr_id = p_khr_id
244: AND opc.sty_id = sty.id
245: --AND sty.code = 'RENT';

Line 276: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste

272: cp_end_date DATE,
273: cp_stream_type_purpose VARCHAR2)
274: IS
275: select ste.stream_element_date stream_element_date,ste.amount amount
276: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
277: WHERE
278: stm.sty_id = sty.id
279: AND ste.stm_id = stm.id
280: AND stm.active_yn = 'Y'

Line 296: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste

292: p_sty_id NUMBER,
293: cp_stream_type_purpose VARCHAR2 )
294: IS
295: select ste.stream_element_date stream_element_date,ste.amount amount
296: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
297:
298: WHERE
299: stm.sty_id = sty.id
300: AND ste.stm_id = stm.id

Line 307: FROM okl_strm_type_b sty1, okl_streams stm1, okl_strm_elements ste1

303: AND stm.khr_id = cp_khr_id
304: AND sty.stream_type_purpose = cp_stream_type_purpose
305: and exists (
306: select '1'
307: FROM okl_strm_type_b sty1, okl_streams stm1, okl_strm_elements ste1
308: where stm1.sty_id = sty1.id
309: AND ste1.stm_id = stm1.id
310: AND stm1.active_yn = 'Y'
311: AND stm1.say_code = 'CURR'

Line 328: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste

324: cp_end_date DATE,
325: cp_stream_type_purpose VARCHAR2)
326: IS
327: select ste.stream_element_date stream_element_date,ste.amount amount
328: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
329: WHERE
330: stm.sty_id = sty.id
331: AND ste.stm_id = stm.id
332: AND stm.active_yn = 'N'

Line 348: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste

344: p_rep_sty_id NUMBER,
345: cp_stream_type_purpose VARCHAR2)
346: IS
347: select ste.stream_element_date stream_element_date,ste.amount amount
348: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
349: WHERE
350: stm.sty_id = sty.id
351: AND ste.stm_id = stm.id
352: AND stm.active_yn = 'N'

Line 359: FROM okl_strm_type_b sty1, okl_streams stm1, okl_strm_elements ste1

355: AND stm.khr_id = cp_khr_id
356: AND sty.stream_type_purpose = cp_stream_type_purpose
357: and exists (
358: select '1'
359: FROM okl_strm_type_b sty1, okl_streams stm1, okl_strm_elements ste1
360: where stm1.sty_id = sty1.id
361: AND ste1.stm_id = stm1.id
362: AND stm1.active_yn = 'N'
363: AND stm1.say_code = 'CURR'

Line 605: FROM okl_strm_type_b sty,

601: --IF l_contracts_csr.deal_type IN ('LEASEOP','LEASEDF','LEASEST') THEN
602: -- Commented for SQL Literals on 12-09-2006
603: /* l_stmt := 'SELECT ste.stream_element_date stream_element_date,
604: ste.amount amount
605: FROM okl_strm_type_b sty,
606: okl_streams stm,
607: okl_strm_elements ste
608: WHERE 1 = 1
609: AND stm.sty_id = sty.id

Line 1448: OKL_STRM_TYPE_B stytl

1444: khr.deal_type deal_type
1445: FROM OKL_POOL_CONTENTS opc,
1446: OKL_POOLS op,
1447: OKL_K_HEADERS khr,
1448: OKL_STRM_TYPE_B stytl
1449: WHERE op.khr_id = p_inv_id
1450: AND op.id = opc.pol_id
1451: AND opc.khr_id = khr.id
1452: AND opc.sty_id = stytl.id

Line 1464: OKL_STRM_TYPE_B sty

1460: IS
1461: SELECT opc.kle_id kle_id,
1462: MIN(opc.streams_from_date) start_date
1463: FROM OKL_POOL_CONTENTS opc,
1464: OKL_STRM_TYPE_B sty
1465: WHERE opc.khr_id = p_khr_id
1466: AND opc.sty_id = sty.id
1467: --AND sty.code = 'RENT'
1468: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')

Line 1486: OKL_STRM_TYPE_B stytl

1482: khr.deal_type deal_type
1483: FROM OKL_POOL_CONTENTS opc,
1484: OKL_POOLS op,
1485: OKL_K_HEADERS khr,
1486: OKL_STRM_TYPE_B stytl
1487: WHERE op.khr_id = p_inv_id
1488: AND op.id = opc.pol_id
1489: AND opc.khr_id = khr.id
1490: AND opc.sty_id = stytl.id

Line 1502: OKL_STRM_TYPE_B sty

1498: IS
1499: SELECT opc.kle_id kle_id,
1500: MIN(opc.streams_from_date) start_date
1501: FROM OKL_POOL_CONTENTS opc,
1502: OKL_STRM_TYPE_B sty
1503: WHERE opc.khr_id = p_khr_id
1504: AND opc.sty_id = sty.id
1505: --AND sty.code = 'RENT'
1506: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')

Line 1522: OKL_STRM_TYPE_B STRM

1518: FROM OKC_K_HEADERS_B K,
1519: OKC_RULE_GROUPS_B RG,
1520: OKC_RULES_B SLH,
1521: OKC_RULES_B SLL,
1522: OKL_STRM_TYPE_B STRM
1523: WHERE slh.rule_information_category = 'LASLH'
1524: AND slh.rgp_id = rg.id
1525: AND sll.object2_id1 = to_char(slh.id)
1526: AND sll.rgp_id = rg.id

Line 1540: FROM OKL_STRM_TYPE_B

1536: -- cursor to get stream type id
1537: CURSOR get_sty_id_csr (p_sty_name VARCHAR2)
1538: IS
1539: SELECT id
1540: FROM OKL_STRM_TYPE_B
1541: WHERE code = p_sty_name;
1542:
1543: -- list of all investors for the agreement
1544: CURSOR get_investors_csr(p_khr_id IN NUMBER)

Line 1601: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste

1597: p_end_date DATE,
1598: p_stream_type_purpose VARCHAR2)
1599: IS
1600: select ste.stream_element_date stream_element_date,ste.amount amount
1601: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
1602: WHERE
1603: stm.sty_id = sty.id
1604: AND ste.stm_id = stm.id
1605: AND stm.active_yn = 'Y'

Line 1619: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste

1615: p_end_date DATE,
1616: p_rep_stream_type_purpose VARCHAR2)
1617: IS
1618: select ste.stream_element_date stream_element_date,ste.amount amount
1619: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
1620: WHERE
1621: stm.sty_id = sty.id
1622: AND ste.stm_id = stm.id
1623: AND stm.active_yn = 'N'

Line 1824: FROM OKL_STRM_TYPE_B sty

1820:
1821: -- SQL Literals Change on 12/09/2006
1822: /*l_stmt := 'SELECT ste.stream_element_date stream_element_date
1823: ,ste.amount amount
1824: FROM OKL_STRM_TYPE_B sty
1825: ,OKL_STREAMS stm
1826: ,OKL_STRM_ELEMENTS ste
1827: WHERE 1 = 1
1828: AND stm.sty_id = sty.id

Line 2932: FROM OKL_STRM_TYPE_B sty,

2928: WHERE id = p_khr_id;
2929:
2930: CURSOR non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
2931: SELECT ste.id
2932: FROM OKL_STRM_TYPE_B sty,
2933: OKL_STREAMS stm,
2934: OKL_STRM_ELEMENTS ste
2935: WHERE stm.khr_id = p_khr_id
2936: AND stm.sty_id = sty.id

Line 2948: FROM OKL_STRM_TYPE_B sty,

2944:
2945: --sechawla 10-mar-09 MG Impact
2946: CURSOR rep_non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
2947: SELECT ste.id
2948: FROM OKL_STRM_TYPE_B sty,
2949: OKL_STREAMS stm,
2950: OKL_STRM_ELEMENTS ste
2951: WHERE stm.khr_id = p_khr_id
2952: AND stm.sty_id = sty.id

Line 2970: FROM OKL_STRM_TYPE_B sty,

2966:
2967:
2968: CURSOR accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
2969: SELECT ste.id
2970: FROM OKL_STRM_TYPE_B sty,
2971: OKL_STREAMS stm,
2972: OKL_STRM_ELEMENTS ste
2973: WHERE stm.khr_id = p_khr_id
2974: AND stm.sty_id = sty.id

Line 3306: okl_strm_type_b sty

3302: SELECT
3303: str.sty_id sty_id
3304: --FROM okl_streams str,
3305: FROM okl_streams_rep_v str, -- Bug# 10091594
3306: okl_strm_type_b sty
3307: WHERE str.sty_id = sty.id
3308: AND str.say_code = 'CURR'
3309: AND str.khr_id = chrid
3310: AND str.kle_id = kleid;

Line 3321: okl_strm_type_b sty

3317: str.sty_id sty_id
3318: --FROM okl_streams str,
3319: FROM okl_streams_rep_v str, -- MGAAP 7263041
3320: okl_strm_elements ste,
3321: okl_strm_type_b sty
3322: WHERE ste.stm_id = str.id
3323: AND str.sty_id = sty.id
3324: AND str.say_code = 'CURR'
3325: AND str.khr_id = chrid

Line 3339: okl_strm_type_b sty

3335: str.sty_id sty_id
3336: --FROM okl_streams str,
3337: FROM okl_streams_rep_v str, -- MGAAP 7263041
3338: okl_strm_elements ste,
3339: okl_strm_type_b sty
3340: WHERE ste.stm_id = str.id
3341: AND str.sty_id = sty.id
3342: AND str.say_code = 'CURR'
3343: AND str.khr_id = chrid

Line 3357: okl_strm_type_b sty

3353: sum(ste.amount)
3354: --FROM okl_streams str,
3355: FROM okl_streams_rep_v str, -- MGAAP 7263041
3356: okl_strm_elements ste,
3357: okl_strm_type_b sty
3358: WHERE ste.stm_id = str.id
3359: AND str.sty_id = sty.id
3360: AND str.say_code = 'CURR'
3361: AND str.khr_id = chrid

Line 3373: okl_strm_type_b sty

3369: sum(ste.amount)
3370: --FROM okl_streams str,
3371: FROM okl_streams_rep_v str, -- MGAAP 7263041
3372: okl_strm_elements ste,
3373: okl_strm_type_b sty
3374: WHERE ste.stm_id = str.id
3375: AND str.sty_id = sty.id
3376: AND str.say_code = 'CURR'
3377: AND str.khr_id = chrid

Line 3426: FROM OKL_STRM_TYPE_B sty,

3422:
3423: CURSOR l_pdt_accrual_csr(chrId NUMBER)
3424: IS
3425: SELECT sty.id sty_id
3426: FROM OKL_STRM_TYPE_B sty,
3427: OKL_PROD_STRM_TYPES psty,
3428: OKL_K_HEADERS khr
3429: WHERE khr.id = chrId
3430: --AND khr.pdt_id = psty.pdt_id

Line 3445: okl_strm_type_b sty

3441: str.sty_id sty_id
3442: --FROM okl_streams str,
3443: FROM okl_streams_rep_v str, -- MGAAP 7263041
3444: okl_strm_elements ste,
3445: okl_strm_type_b sty
3446: WHERE ste.stm_id = str.id
3447: AND str.sty_id = sty.id
3448: AND str.say_code = 'CURR'
3449: AND str.khr_id = chrid

Line 3467: sty_id OKL_STRM_TYPE_B.ID%TYPE);

3463: l_abs_amt_rec l_abs_amt_csr%rowtype;
3464:
3465:
3466: TYPE p_pdt_accrual_rec_type IS RECORD(
3467: sty_id OKL_STRM_TYPE_B.ID%TYPE);
3468:
3469: TYPE p_pdt_accrual_tbl_type IS TABLE OF p_pdt_accrual_rec_type
3470: INDEX BY BINARY_INTEGER;
3471:

Line 4101: FROM OKL_STRM_TYPE_B sty,

4097:
4098: CURSOR non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE)
4099: IS
4100: SELECT ste.id
4101: FROM OKL_STRM_TYPE_B sty,
4102: OKL_STREAMS stm,
4103: OKL_STRM_ELEMENTS ste
4104: WHERE stm.khr_id = p_khr_id
4105: AND stm.sty_id = sty.id

Line 4119: FROM OKL_STRM_TYPE_B sty,

4115: --sechawla 10-mar-09 MG Impact
4116: CURSOR rep_non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE)
4117: IS
4118: SELECT ste.id
4119: FROM OKL_STRM_TYPE_B sty,
4120: OKL_STREAMS stm,
4121: OKL_STRM_ELEMENTS ste
4122: WHERE stm.khr_id = p_khr_id
4123: AND stm.sty_id = sty.id

Line 4141: FROM OKL_STRM_TYPE_B sty,

4137: SELECT secondary_rep_method FROM okl_sys_acct_opts;
4138: CURSOR accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE)
4139: IS
4140: SELECT ste.id
4141: FROM OKL_STRM_TYPE_B sty,
4142: OKL_STREAMS stm,
4143: OKL_STRM_ELEMENTS ste
4144: WHERE stm.khr_id = p_khr_id
4145: AND stm.sty_id = sty.id

Line 4161: OKL_STRM_TYPE_B sty

4157: IS
4158: SELECT opc.kle_id kle_id,
4159: MIN(opc.streams_from_date) start_date
4160: FROM OKL_POOL_CONTENTS opc,
4161: OKL_STRM_TYPE_B sty
4162: WHERE opc.khr_id = p_khr_id
4163: AND opc.sty_id = sty.id
4164: --AND sty.code = 'RENT'
4165: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')

Line 4180: OKL_STRM_TYPE_B STRM

4176: FROM OKC_K_HEADERS_B K,
4177: OKC_RULE_GROUPS_B RG,
4178: OKC_RULES_B SLH,
4179: OKC_RULES_B SLL,
4180: OKL_STRM_TYPE_B STRM
4181: WHERE slh.rule_information_category = 'LASLH'
4182: AND slh.rgp_id = rg.id
4183: AND sll.object2_id1 = TO_CHAR(slh.id)
4184: AND sll.rgp_id = rg.id

Line 4198: FROM OKL_STRM_TYPE_B sty,

4194: -- To get the earliest billable stream
4195: CURSOR get_ear_billable_stream_csr (p_khr_id NUMBER)
4196: IS
4197: SELECT MIN(ste.stream_element_date)
4198: FROM OKL_STRM_TYPE_B sty,
4199: OKL_STREAMS stm,
4200: OKL_STRM_ELEMENTS ste
4201: WHERE stm.khr_id = p_khr_id
4202: AND stm.sty_id = sty.id