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.OKS_RENCON_PVT dependencies on OKC_K_LINES_B

Line 199: okc_k_lines_b cle

195: ------------------------------------------------------------------
196: CURSOR operation_lines(p_target_id IN NUMBER) IS
197: SELECT opl.id, oie_id, object_chr_id, object_cle_id, parent_ole_id, select_yn, cle.cle_id
198: FROM okc_operation_lines OPL,
199: okc_k_lines_b cle
200: WHERE OPL.subject_chr_id = p_target_id
201: AND EXISTS (SELECT 'X'
202: FROM okc_operation_instances OPI
203: WHERE OPI.id = OPL.oie_id

Line 217: (SELECT 1 from okc_k_lines_b cle1

213: and NVL(line_renewal_type_code,'FUL') not in ('KEP','DNR') -- bug 5078797
214: and date_terminated is null
215: and cle_id is not null
216: AND exists
217: (SELECT 1 from okc_k_lines_b cle1
218: WHERE cle1.id = cle.cle_id
219: AND NVL(cle1.line_renewal_type_code,'FUL') not in ('DNR', 'KEP'))
220: /*
221: MINUS

Line 251: , okc_k_lines_b s

247: SELECT h.id
248: FROM okc_K_Headers_all_b h, --mmadhavi MOAC - changed to _ALL_B for performance
249: okc_k_party_roles_b pr,
250: okc_statuses_b st
251: , okc_k_lines_b s
252: WHERE h.id = l_source_chr_id
253: AND h.scs_code IN ('WARRANTY', x_scs_code)
254: AND h.chr_type = x_chr_type
255: AND h.template_yn = x_template_yn

Line 299: okc_k_lines_b KLN

295:
296: CURSOR get_terminated_opl(cp_opl_id IN NUMBER) IS
297: SELECT 1
298: FROM okc_operation_lines OPL,
299: okc_k_lines_b KLN
300: WHERE OPL.id = cp_opl_id
301: AND OPL.object_cle_id = KLN.id
302: AND KLN.date_terminated IS NOT NULL;
303:

Line 549: FROM okc_k_lines_b s

545:
546: CURSOR valid_subline_sources(p_chr_id IN NUMBER , p_target_chr_id IN NUMBER) IS
547: SELECT s.id,
548: s.cle_id
549: FROM okc_k_lines_b s
550: WHERE s.dnz_chr_id = p_chr_id
551: AND s.end_date BETWEEN x_start_date AND x_end_date
552: --AND s.date_renewed is NULL
553: AND s.date_terminated IS NULL

Line 558: (SELECT 1 from okc_k_lines_b cle

554: AND s.date_cancelled IS NULL
555: AND s.lse_id IN (35, 7, 8, 9, 10, 11, 25)
556: AND NVL(s.line_renewal_type_code,'FUL') not in ('DNR', 'KEP') -- Added by MKS
557: AND exists
558: (SELECT 1 from okc_k_lines_b cle
559: WHERE cle.id = s.cle_id
560: AND NVL(cle.line_renewal_type_code,'FUL') not in ('DNR', 'KEP')) -- Added by MKS
561: -- Added following code for bug#5981381 i.e. removed looping of function call of is_laready_in_ol
562: -- and moved the entire code from that function to here

Line 1403: FROM OKC_K_LINES_B

1399:
1400: FUNCTION GET_LRT_RULE(p_line_id IN NUMBER) RETURN VARCHAR2 IS
1401: CURSOR GET_RULE IS
1402: SELECT NVL(LINE_RENEWAL_TYPE_CODE,'FUL') LINE_RENEWAL_TYPE_CODE
1403: FROM OKC_K_LINES_B
1404: WHERE ID = p_line_id;
1405: x_return VARCHAR2(200) := 'NOLRTRULE';
1406: BEGIN
1407: FOR cur_get_rule IN get_rule LOOP

Line 1427: FROM OKC_K_LINES_B

1423: WHERE cle_id = p_line_id;
1424:
1425: CURSOR get_lrt_bto IS
1426: SELECT NVL(LINE_RENEWAL_TYPE_CODE,'FUL') LINE_RENEWAL_TYPE_CODE, BILL_TO_SITE_USE_ID, START_DATE, END_DATE
1427: FROM OKC_K_LINES_B
1428: WHERE ID = p_line_id;
1429:
1430:
1431: BEGIN

Line 1637: FROM okc_k_lines_b

1633: l_mod_name VARCHAR2(256) := lower(G_OKS_APP_NAME) || '.plsql.' || G_PROGRAM_NAME || '.' || l_api_name;
1634:
1635: CURSOR target_line_id IS
1636: SELECT id
1637: FROM okc_k_lines_b
1638: WHERE dnz_chr_id = p_target_contract_id
1639: AND cle_id IS NULL
1640: AND lse_id IN (1, 12, 14, 19);
1641:

Line 1707: SELECT object_cle_id FROM okc_operation_lines ol, okc_k_lines_b cle

1703: l_mod_name VARCHAR2(256) := lower(G_OKS_APP_NAME) || '.plsql.' || G_PROGRAM_NAME || '.' || l_api_name;
1704:
1705:
1706: CURSOR get_oper_sub_lines(p_id IN NUMBER) IS
1707: SELECT object_cle_id FROM okc_operation_lines ol, okc_k_lines_b cle
1708: WHERE ol.parent_ole_id = p_id
1709: and ol.process_flag IN ('A','E')
1710: and ol.select_yn = 'Y'
1711: and cle.id = ol.object_cle_id

Line 1843: okc_k_lines_b cle,

1839: chr.inv_organization_id,
1840: chr.authoring_org_id,
1841: chr.currency_code
1842: FROM okc_operation_lines b,
1843: okc_k_lines_b cle,
1844: okc_k_headers_all_b chr,
1845: okc_statuses_b st
1846: WHERE b.oie_id = p_oie_id
1847: and cle.id = b.object_cle_id

Line 1867: okc_k_lines_b cle

1863: AND select_yn = 'Y';
1864: */
1865: CURSOR get_oper_sub_lines(p_id IN NUMBER) IS
1866: SELECT ol.*, lse_id, start_date, end_date FROM okc_operation_lines ol,
1867: okc_k_lines_b cle
1868: WHERE parent_ole_id = p_id
1869: and process_flag IN ('A','E')
1870: and select_yn = 'Y'
1871: and cle.id = ol.object_cle_id

Line 1894: from okc_k_lines_b

1890: -- anyway
1891:
1892: CURSOR get_subline_details(p_subline_id in NUMBER) IS
1893: select lse_id,start_date,end_date
1894: from okc_k_lines_b
1895: where id =p_subline_id;
1896:
1897: -- The following cursor was added by MSENGUPT 11/07
1898: -- Need to check that target is valid as by the time the CP picks this up the target contract may not be in valid status

Line 2646: UPDATE okc_k_lines_b SET

2642: END IF;
2643:
2644: l_date_renewed := sysdate;
2645: FORALL i IN l_src_sub_line_id_tbl.FIRST..l_src_sub_line_id_tbl.LAST
2646: UPDATE okc_k_lines_b SET
2647: date_renewed = l_date_renewed,
2648: object_version_number = object_version_number + 1,
2649: last_updated_by = l_user_id,
2650: last_update_date = l_update_date,

Line 2664: UPDATE okc_k_lines_b tl SET

2660: IF(FND_LOG.level_statement >= FND_LOG.g_current_runtime_level)THEN
2661: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.update_top_lines','updating date_renewed for source toplines');
2662: END IF;
2663:
2664: UPDATE okc_k_lines_b tl SET
2665: tl.date_renewed = l_date_renewed,
2666: tl.object_version_number = tl.object_version_number + 1,
2667: tl.last_updated_by = l_user_id,
2668: tl.last_update_date = l_update_date,

Line 2682: (SELECT 1 FROM okc_k_lines_b sl

2678: AND a.id = b.parent_ole_id
2679: AND a.parent_ole_id IS NULL
2680: AND b.select_yn = 'Y')
2681: AND NOT EXISTS
2682: (SELECT 1 FROM okc_k_lines_b sl
2683: WHERE sl.cle_id = tl.id
2684: AND sl.date_terminated IS NULL
2685: AND sl.date_cancelled IS NULL
2686: AND sl.date_renewed IS NULL);

Line 2711: (SELECT 1 FROM okc_k_lines_b tl

2707: AND a.object_cle_id IS NULL
2708: AND a.subject_cle_id IS NULL
2709: AND a.select_yn = 'Y')
2710: AND NOT EXISTS
2711: (SELECT 1 FROM okc_k_lines_b tl
2712: WHERE tl.dnz_chr_id = h.id
2713: AND tl.cle_id IS NULL
2714: AND tl.lse_id IN (1,12,14,19)
2715: AND tl.date_terminated IS NULL

Line 2923: FROM okc_k_lines_b c, oks_k_lines_b s

2919: l_error_text VARCHAR2(512);
2920:
2921: CURSOR c_top_lines(cp_chr_id IN NUMBER) IS
2922: SELECT c.cle_id, SUM(nvl(c.price_negotiated, 0)), SUM(nvl(s.tax_amount, 0))
2923: FROM okc_k_lines_b c, oks_k_lines_b s
2924: WHERE c.dnz_chr_id = cp_chr_id
2925: --get only sublines for 1,12,19 (14:no renewal, 46:no sublines)
2926: AND c.lse_id IN (7, 8, 9, 10, 11, 35, 13, 25)
2927: AND s.cle_id = c.id

Line 2974: UPDATE okc_k_lines_b

2970:
2971: EXIT WHEN (l_id_tbl.COUNT = 0);
2972:
2973: FORALL i IN l_id_tbl.first..l_id_tbl.last
2974: UPDATE okc_k_lines_b
2975: SET price_negotiated = l_price_tbl(i),
2976: object_version_number = object_version_number + 1,
2977: last_updated_by = l_user_id,
2978: last_update_date = l_update_date,

Line 3010: (SELECT SUM(price_negotiated) FROM okc_k_lines_b tl

3006:
3007: --update the header
3008: UPDATE okc_k_headers_all_b h
3009: SET h.estimated_amount =
3010: (SELECT SUM(price_negotiated) FROM okc_k_lines_b tl
3011: WHERE tl.dnz_chr_id = p_header_id AND tl.cle_id IS NULL
3012: AND tl.lse_id IN (1, 12, 19, 46)
3013: /* Added by sjanakir for Bug# 8287971 */
3014: AND tl.date_cancelled IS NULL),

Line 3027: (SELECT SUM(stl.tax_amount) FROM okc_k_lines_b ctl, oks_k_lines_b stl

3023: WHERE h.id = p_header_id;
3024:
3025: UPDATE oks_k_headers_b h
3026: SET h.tax_amount =
3027: (SELECT SUM(stl.tax_amount) FROM okc_k_lines_b ctl, oks_k_lines_b stl
3028: WHERE ctl.dnz_chr_id = p_header_id AND ctl.cle_id IS NULL
3029: AND ctl.lse_id IN (1, 12, 19, 46) AND stl.cle_id = ctl.id
3030: /* Added by sjanakir for Bug# 8287971 */
3031: AND ctl.date_cancelled IS NULL),