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_RENEW_CONTRACT_PVT dependencies on OKC_CLASS_OPERATIONS

Line 3974: FROM okc_operation_lines ol, okc_operation_instances oi, okc_class_operations oo

3970: FROM okc_k_lines_b kl
3971: WHERE kl.dnz_chr_id = cp_chr_id AND kl.lse_id IN (7, 8, 9, 10, 11, 13, 25, 35, 46)
3972: AND kl.id NOT IN(
3973: SELECT ol.object_cle_id
3974: FROM okc_operation_lines ol, okc_operation_instances oi, okc_class_operations oo
3975: WHERE oo.cls_code = 'SERVICE' AND oo.opn_code = 'REN_CON' AND oo.id = oi.cop_id
3976: AND ol.oie_id = oi.id AND ol.object_chr_id = cp_chr_id
3977: AND ol.subject_chr_id IS NOT NULL
3978: AND ol.process_flag = 'P' AND ol.active_yn = 'Y');

Line 3986: FROM okc_operation_lines ol, okc_operation_instances oi, okc_class_operations oo,

3982: --we order by active_yn desc, as for cancelled renewed contracts
3983: --active_yn = 'N'. So we want to get the active renewals (such as entered/signed status etc) first
3984: CURSOR c_check_hdr_renew (cp_chr_id IN NUMBER) IS
3985: SELECT k.contract_number, k.contract_number_modifier, st.ste_code
3986: FROM okc_operation_lines ol, okc_operation_instances oi, okc_class_operations oo,
3987: okc_statuses_b st, okc_k_headers_all_b k
3988: WHERE oo.cls_code = 'SERVICE' AND oo.opn_code = 'RENEWAL'
3989: AND oo.id = oi.cop_id
3990: AND ol.oie_id = oi.id AND ol.object_chr_id = cp_chr_id