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_TMPT_LINES_UV

Line 124: FROM OKL_STRM_TMPT_LINES_UV STL

120: WHERE id = l_khr_id;
121:
122: CURSOR pry_prc_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
123: SELECT PRICING_NAME
124: FROM OKL_STRM_TMPT_LINES_UV STL
125: WHERE STL.PRIMARY_YN = 'Y'
126: AND STL.PDT_ID = l_pdt_id
127: AND (STL.START_DATE <= l_contract_start_date)
128: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 232: FROM OKL_STRM_TMPT_LINES_UV STL

228: WHERE id = l_khr_id;
229:
230: CURSOR pry_prc_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
231: SELECT PRICING_NAME
232: FROM OKL_STRM_TMPT_LINES_UV STL
233: WHERE STL.PRIMARY_YN = 'N'
234: AND STL.PDT_ID = l_pdt_id
235: AND (STL.START_DATE <= l_contract_start_date)
236: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 342: FROM OKL_STRM_TMPT_LINES_UV STL

338: WHERE id = l_khr_id;
339:
340: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
341: SELECT PRIMARY_STY_ID, PRICING_NAME
342: FROM OKL_STRM_TMPT_LINES_UV STL
343: WHERE STL.PRIMARY_YN = 'Y'
344: AND STL.PDT_ID = l_pdt_id
345: AND (STL.START_DATE <= l_contract_start_date)
346: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 447: FROM OKL_STRM_TMPT_LINES_UV STL

443: WHERE id = l_khr_id;
444:
445: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
446: SELECT PRIMARY_STY_ID,PRICING_NAME
447: FROM OKL_STRM_TMPT_LINES_UV STL
448: WHERE STL.PRIMARY_YN = 'Y'
449: AND STL.PDT_ID = l_pdt_id
450: AND (STL.START_DATE <= l_contract_start_date)
451: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 551: FROM OKL_STRM_TMPT_LINES_UV STL

547: WHERE id = l_khr_id;
548:
549: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
550: SELECT DEPENDENT_STY_ID,PRICING_NAME
551: FROM OKL_STRM_TMPT_LINES_UV STL
552: WHERE PRIMARY_YN = 'N'
553: AND STL.PDT_ID = l_product_id
554: AND (STL.START_DATE <= l_contract_start_date)
555: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 655: FROM OKL_STRM_TMPT_LINES_UV STL

651: WHERE id = l_khr_id;
652:
653: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
654: SELECT DEPENDENT_STY_ID,PRICING_NAME
655: FROM OKL_STRM_TMPT_LINES_UV STL
656: WHERE PRIMARY_YN = 'N'
657: AND STL.PDT_ID = l_product_id
658: AND (STL.START_DATE <= l_contract_start_date)
659: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 756: FROM OKL_STRM_TMPT_LINES_UV STL

752: WHERE id = l_khr_id;
753:
754: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
755: SELECT DEPENDENT_STY_ID,PRICING_NAME
756: FROM OKL_STRM_TMPT_LINES_UV STL
757: WHERE PRIMARY_YN = 'N'
758: AND STL.PDT_ID = l_product_id
759: AND (STL.START_DATE <= l_contract_start_date)
760: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 860: FROM OKL_STRM_TMPT_LINES_UV STL

856: WHERE id = l_khr_id;
857:
858: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
859: SELECT PRIMARY_STY_ID,PRICING_NAME
860: FROM OKL_STRM_TMPT_LINES_UV STL
861: WHERE STL.PRIMARY_YN = 'Y'
862: AND STL.PDT_ID = l_pdt_id
863: AND (STL.START_DATE <= l_contract_start_date)
864: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 969: FROM OKL_STRM_TMPT_LINES_UV STL

965: WHERE id = l_khr_id;
966:
967: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
968: SELECT PRIMARY_STY_ID,PRICING_NAME
969: FROM OKL_STRM_TMPT_LINES_UV STL
970: WHERE STL.PRIMARY_YN = 'Y'
971: AND STL.PDT_ID = l_pdt_id
972: AND (STL.START_DATE <= l_contract_start_date)
973: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1072: FROM OKL_STRM_TMPT_LINES_UV STL

1068: WHERE id = l_khr_id;
1069:
1070: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1071: SELECT DEPENDENT_STY_ID,PRICING_NAME
1072: FROM OKL_STRM_TMPT_LINES_UV STL
1073: WHERE PRIMARY_YN = 'N'
1074: AND STL.PDT_ID = l_product_id
1075: AND (STL.START_DATE <= l_contract_start_date)
1076: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1171: FROM OKL_STRM_TMPT_LINES_UV STL

1167: WHERE id = l_khr_id;
1168:
1169: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1170: SELECT DEPENDENT_STY_ID,PRICING_NAME
1171: FROM OKL_STRM_TMPT_LINES_UV STL
1172: WHERE PRIMARY_YN = 'N'
1173: AND STL.PDT_ID = l_product_id
1174: AND (STL.START_DATE <= l_contract_start_date)
1175: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1268: FROM OKL_STRM_TMPT_LINES_UV STL

1264: WHERE id = l_khr_id;
1265:
1266: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1267: SELECT DEPENDENT_STY_ID,PRICING_NAME
1268: FROM OKL_STRM_TMPT_LINES_UV STL
1269: WHERE PRIMARY_YN = 'N'
1270: AND STL.PDT_ID = l_product_id
1271: AND (STL.START_DATE <= l_contract_start_date)
1272: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1363: FROM OKL_STRM_TMPT_LINES_UV STL

1359: WHERE id = l_khr_id;
1360:
1361: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1362: SELECT DEPENDENT_STY_ID, PRICING_NAME
1363: FROM OKL_STRM_TMPT_LINES_UV STL
1364: WHERE PRIMARY_YN = 'N'
1365: AND STL.PDT_ID = l_product_id
1366: AND (STL.START_DATE <= l_contract_start_date)
1367: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1458: FROM OKL_STRM_TMPT_LINES_UV STL

1454: WHERE id = l_khr_id;
1455:
1456: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1457: SELECT DEPENDENT_STY_ID,PRICING_NAME
1458: FROM OKL_STRM_TMPT_LINES_UV STL
1459: WHERE PRIMARY_YN = 'N'
1460: AND STL.PDT_ID = l_product_id
1461: AND (STL.START_DATE <= l_contract_start_date)
1462: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1568: FROM OKL_STRM_TMPT_LINES_UV STL

1564: WHERE id = l_khr_id;
1565:
1566: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1567: SELECT DEPENDENT_STY_ID,PRICING_NAME
1568: FROM OKL_STRM_TMPT_LINES_UV STL
1569: WHERE PRIMARY_YN = 'N'
1570: AND STL.PDT_ID = l_product_id
1571: AND (STL.START_DATE <= l_contract_start_date)
1572: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 3131: FROM OKL_STRM_TMPT_LINES_UV where primary_sty_id = payment_type_id

3127: -- Added for user defined streams HKPATEL
3128: Cursor dependent_sty_csr (payment_type_id NUMBER, p_purpose VARCHAR2)
3129: IS
3130: Select dependent_sty_id,dependent_sty_name
3131: FROM OKL_STRM_TMPT_LINES_UV where primary_sty_id = payment_type_id
3132: and pdt_id = (select pdt_id from okl_k_headers where id = p_chr_id)
3133: and dependent_sty_purpose = p_purpose
3134: and dependent_sty_id is not null;
3135:

Line 7202: OKL_STRM_TMPT_LINES_UV sty,

7198: Select ele.id
7199: From okl_strm_elements ele,
7200: okl_streams str,
7201: --okl_strm_type_v sty,
7202: OKL_STRM_TMPT_LINES_UV sty,
7203: okl_k_lines_full_v kle,
7204: okc_line_styles_b lse,
7205: okc_statuses_b sts
7206: Where ele.stm_id = str.id

Line 10209: FROM OKL_STRM_TMPT_LINES_UV stl,

10205: SELECT stl.ST_GEN_TMPT_SET_NAME strm_name,
10206: stl.pricing_name pricing_name,
10207: kle.id line_id,
10208: stl.id styp_id
10209: FROM OKL_STRM_TMPT_LINES_UV stl,
10210: okc_k_items cim,
10211: okl_k_lines_full_v kle,
10212: okc_line_styles_b ls
10213: WHERE cim.cle_id = kle.id

Line 20430: FROM OKL_STRM_TMPT_LINES_UV STL

20426: --To get the styid for primary stream purpose Residual Value
20427: CURSOR get_residual_primary_sty_id (l_pdt_id NUMBER, l_contract_start_date DATE)
20428: IS
20429: SELECT PRIMARY_STY_ID
20430: FROM OKL_STRM_TMPT_LINES_UV STL
20431: WHERE STL.PRIMARY_YN = 'Y'
20432: AND STL.PDT_ID = l_pdt_id
20433: AND (STL.START_DATE <= l_contract_start_date)
20434: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)