APPS.OKS_MASS_UPDATE_PVT dependencies on OKS_K_LINES_V

Line 3286: oks_k_lines_v ks,

3282:
3283: FROM oks_instance_k_dtls_temp temp,
3284: okc_k_lines_b kl,
3285: okc_k_items itm,
3286: oks_k_lines_v ks,
3287: okc_statuses_b st,
3288: okc_k_headers_all_b kh
3289: WHERE temp.topline_id = kl.ID
3290: AND temp.new_serviceline_id IS NOT NULL

Line 3816: oks_k_lines_v ks,

3812: FROM oks_instance_k_dtls_temp temp,
3813: okc_k_lines_b kl,
3814: okc_k_lines_b kl1,
3815: okc_k_items itm,
3816: oks_k_lines_v ks,
3817: okc_statuses_b st,
3818: oks_k_headers_b kh
3819: WHERE temp.subline_id = kl.ID
3820: AND temp.new_subline_id IS NOT NULL

Line 6429: oks_k_lines_v ksl,

6425: okc_k_lines_b kl,
6426: okc_statuses_b st,
6427: oks_instance_temp tmp,
6428: okc_k_lines_b tl,
6429: oks_k_lines_v ksl,
6430: oks_k_lines_b ks11
6431: WHERE tmp.idc = 'Y'
6432: AND NVL(tmp.trm, 'N') = 'N'
6433: AND ki.object1_id1 = to_char(tmp.old_customer_product_id)

Line 6592: ,Oks_k_lines_v Ksl

6588: Cursor l_subline_invtext_csr Is
6589: Select Kl.Id
6590: ,(substr(ksl.invoice_text,1,instr(ksl.invoice_text,':',1,3))||kl.start_date||' - '|| kl.end_date)
6591: From Okc_k_lines_b Kl
6592: ,Oks_k_lines_v Ksl
6593: ,OKs_instance_k_dtls_temp temp
6594: Where kl.id = temp.subline_id
6595: And Ksl.cle_id = Kl.id;
6596:

Line 6612: ,Oks_k_lines_v Ksl

6608: Cursor l_invoice_text_csr Is
6609: Select distinct Kl.Id
6610: ,(substr(ksl.invoice_text,1,instr(ksl.invoice_text,':',1,1))||kl.start_date||' - '|| kl.end_date)
6611: From Okc_k_lines_b Kl
6612: ,Oks_k_lines_v Ksl
6613: ,OKs_instance_k_dtls_temp temp
6614: Where kl.id = temp.topline_id
6615: And Ksl.cle_id = Kl.id;
6616:

Line 8034: UPDATE oks_k_lines_v

8030: inv_text;
8031: Close l_subline_invtext_csr;
8032:
8033: Forall i in 1..sub_line_id.count
8034: UPDATE oks_k_lines_v
8035: SET invoice_text = inv_text(i)
8036: WHERE id = (select id from oks_k_lines_b
8037: where cle_id = sub_line_id(i));
8038: