APPS.OKS_EXTWAR_UTIL_PVT dependencies on OKC_K_LINES_V

Line 255: FROM okc_k_lines_v

251: */
252: CURSOR l_serv_csr
253: IS
254: SELECT ID
255: FROM okc_k_lines_v
256: WHERE cle_id = p_service_line_id;
257:
258: --ERROR ADD LSL ID TO LIMIT THE QUERY
259:

Line 2178: FROM okc_k_items_v ot, okc_k_lines_v ol

2174: -- Extwarranty cascading
2175: CURSOR get_warr_dates_csr
2176: IS
2177: SELECT MAX (ol.end_date)
2178: FROM okc_k_items_v ot, okc_k_lines_v ol
2179: WHERE ot.object1_id1 = TO_CHAR (p_cp_id)
2180: AND ol.ID = ot.cle_id
2181: AND ol.lse_id = 18;
2182:

Line 2869: okc_k_lines_v kl,

2865: party.object1_id1 party_id
2866: FROM okc_k_items_v ki,
2867: okc_k_headers_b kh,
2868: oks_k_headers_b ks,
2869: okc_k_lines_v kl,
2870: oks_k_lines_b okl,
2871: okc_statuses_v st,
2872: okc_k_party_roles_b party
2873: WHERE ki.object1_id1 = p_id

Line 2912: FROM okc_k_lines_v ol, oks_k_lines_b kl, okc_k_headers_b oh

2908: -- ,OL.unit_price
2909: --,OL.cle_id_renewed
2910: , ol.sts_code, oh.contract_number_modifier, kl.acct_rule_id,
2911: kl.tax_code --Bug#4121175
2912: FROM okc_k_lines_v ol, oks_k_lines_b kl, okc_k_headers_b oh
2913: WHERE ol.dnz_chr_id = p_hdr_id
2914: AND oh.ID = ol.dnz_chr_id
2915: AND kl.cle_id(+) = ol.ID -- Vigandhi 06-Jan-2004
2916: AND oh.scs_code IN ('WARRANTY', 'SERVICE', 'SUBSCRIPTION')

Line 2919: FROM okc_k_lines_v okl

2915: AND kl.cle_id(+) = ol.ID -- Vigandhi 06-Jan-2004
2916: AND oh.scs_code IN ('WARRANTY', 'SERVICE', 'SUBSCRIPTION')
2917: -- support to subscription category contracts
2918: AND ol.ID IN (SELECT okl.cle_id
2919: FROM okc_k_lines_v okl
2920: WHERE okl.ID = p_line_id AND okl.cle_id IS NOT NULL);
2921:
2922: /*Cursor l_serv_Csr(p_serv_id NUMBER) is
2923: Select COVERAGE_SCHEDULE_ID coverage_template_id