469: , okc_operation_instances oip
470: , okc_operation_lines ol
471: , okc_operations_v Op
472: , Okc_k_headers_b Kh
473: , Okc_k_lines_b Kl
474: ,Okc_k_lines_b Tl
475: WHERE ol.subject_cle_id = p_cle_id --"Subline ID"
476: AND oip.cop_id = cl.Id
477: AND cl.cls_code = 'SERVICE'
470: , okc_operation_lines ol
471: , okc_operations_v Op
472: , Okc_k_headers_b Kh
473: , Okc_k_lines_b Kl
474: ,Okc_k_lines_b Tl
475: WHERE ol.subject_cle_id = p_cle_id --"Subline ID"
476: AND oip.cop_id = cl.Id
477: AND cl.cls_code = 'SERVICE'
478: AND ol.oie_id = oip.id