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 125: FROM OKL_STRM_TMPT_LINES_UV STL

121: WHERE id = l_khr_id;
122:
123: CURSOR pry_prc_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
124: SELECT PRICING_NAME
125: FROM OKL_STRM_TMPT_LINES_UV STL
126: WHERE STL.PRIMARY_YN = 'Y'
127: AND STL.PDT_ID = l_pdt_id
128: AND (STL.START_DATE <= l_contract_start_date)
129: 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 341: FROM OKL_STRM_TMPT_LINES_UV STL

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

Line 446: FROM OKL_STRM_TMPT_LINES_UV STL

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

Line 550: FROM OKL_STRM_TMPT_LINES_UV STL

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

Line 657: FROM OKL_STRM_TMPT_LINES_UV STL

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

Line 763: FROM OKL_STRM_TMPT_LINES_UV STL

759: WHERE id = l_khr_id;
760:
761: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
762: SELECT DEPENDENT_STY_ID,PRICING_NAME
763: FROM OKL_STRM_TMPT_LINES_UV STL
764: WHERE PRIMARY_YN = 'N'
765: AND STL.PDT_ID = l_product_id
766: AND (STL.START_DATE <= l_contract_start_date)
767: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 872: FROM OKL_STRM_TMPT_LINES_UV STL

868: WHERE id = l_khr_id;
869:
870: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
871: SELECT PRIMARY_STY_ID,PRICING_NAME
872: FROM OKL_STRM_TMPT_LINES_UV STL
873: WHERE STL.PRIMARY_YN = 'Y'
874: AND STL.PDT_ID = l_pdt_id
875: AND (STL.START_DATE <= l_contract_start_date)
876: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 975: FROM OKL_STRM_TMPT_LINES_UV STL

971: WHERE id = l_khr_id;
972:
973: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS
974: SELECT PRIMARY_STY_ID,PRICING_NAME
975: FROM OKL_STRM_TMPT_LINES_UV STL
976: WHERE STL.PRIMARY_YN = 'Y'
977: AND STL.PDT_ID = l_pdt_id
978: AND (STL.START_DATE <= l_contract_start_date)
979: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1078: FROM OKL_STRM_TMPT_LINES_UV STL

1074: WHERE id = l_khr_id;
1075:
1076: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1077: SELECT DEPENDENT_STY_ID,PRICING_NAME
1078: FROM OKL_STRM_TMPT_LINES_UV STL
1079: WHERE PRIMARY_YN = 'N'
1080: AND STL.PDT_ID = l_product_id
1081: AND (STL.START_DATE <= l_contract_start_date)
1082: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1182: FROM OKL_STRM_TMPT_LINES_UV STL

1178: WHERE id = l_khr_id;
1179:
1180: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1181: SELECT DEPENDENT_STY_ID,PRICING_NAME
1182: FROM OKL_STRM_TMPT_LINES_UV STL
1183: WHERE PRIMARY_YN = 'N'
1184: AND STL.PDT_ID = l_product_id
1185: AND (STL.START_DATE <= l_contract_start_date)
1186: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1284: FROM OKL_STRM_TMPT_LINES_UV STL

1280: WHERE id = l_khr_id;
1281:
1282: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1283: SELECT DEPENDENT_STY_ID,PRICING_NAME
1284: FROM OKL_STRM_TMPT_LINES_UV STL
1285: WHERE PRIMARY_YN = 'N'
1286: AND STL.PDT_ID = l_product_id
1287: AND (STL.START_DATE <= l_contract_start_date)
1288: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1384: FROM OKL_STRM_TMPT_LINES_UV STL

1380: WHERE id = l_khr_id;
1381:
1382: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1383: SELECT DEPENDENT_STY_ID, PRICING_NAME
1384: FROM OKL_STRM_TMPT_LINES_UV STL
1385: WHERE PRIMARY_YN = 'N'
1386: AND STL.PDT_ID = l_product_id
1387: AND (STL.START_DATE <= l_contract_start_date)
1388: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1484: FROM OKL_STRM_TMPT_LINES_UV STL

1480: WHERE id = l_khr_id;
1481:
1482: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1483: SELECT DEPENDENT_STY_ID,PRICING_NAME
1484: FROM OKL_STRM_TMPT_LINES_UV STL
1485: WHERE PRIMARY_YN = 'N'
1486: AND STL.PDT_ID = l_product_id
1487: AND (STL.START_DATE <= l_contract_start_date)
1488: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 1592: FROM OKL_STRM_TMPT_LINES_UV STL

1588: WHERE id = l_khr_id;
1589:
1590: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1591: SELECT DEPENDENT_STY_ID,PRICING_NAME
1592: FROM OKL_STRM_TMPT_LINES_UV STL
1593: WHERE PRIMARY_YN = 'N'
1594: AND STL.PDT_ID = l_product_id
1595: AND (STL.START_DATE <= l_contract_start_date)
1596: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)

Line 2715: FROM OKL_STRM_TMPT_LINES_UV where primary_sty_id = payment_type_id

2711: -- Added for user defined streams HKPATEL
2712: Cursor dependent_sty_csr (payment_type_id NUMBER, p_purpose VARCHAR2)
2713: IS
2714: Select dependent_sty_id,dependent_sty_name
2715: FROM OKL_STRM_TMPT_LINES_UV where primary_sty_id = payment_type_id
2716: and pdt_id = (select pdt_id from okl_k_headers where id = p_chr_id)
2717: and dependent_sty_purpose = p_purpose
2718: and dependent_sty_id is not null;
2719:

Line 5786: OKL_STRM_TMPT_LINES_UV sty,

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,
5788: okc_line_styles_b lse,
5789: okc_statuses_b sts
5790: Where ele.stm_id = str.id

Line 8687: FROM OKL_STRM_TMPT_LINES_UV stl,

8683: SELECT stl.ST_GEN_TMPT_SET_NAME strm_name,
8684: stl.pricing_name pricing_name,
8685: kle.id line_id,
8686: stl.id styp_id
8687: FROM OKL_STRM_TMPT_LINES_UV stl,
8688: okc_k_items cim,
8689: okl_k_lines_full_v kle,
8690: okc_line_styles_b ls
8691: WHERE cim.cle_id = kle.id

Line 17792: FROM OKL_STRM_TMPT_LINES_UV STL

17788: --To get the styid for primary stream purpose Residual Value
17789: CURSOR get_residual_primary_sty_id (l_pdt_id NUMBER, l_contract_start_date DATE)
17790: IS
17791: SELECT PRIMARY_STY_ID
17792: FROM OKL_STRM_TMPT_LINES_UV STL
17793: WHERE STL.PRIMARY_YN = 'Y'
17794: AND STL.PDT_ID = l_pdt_id
17795: AND (STL.START_DATE <= l_contract_start_date)
17796: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)