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 3939: FROM okc_operation_lines ol, okc_operation_instances oi, okc_class_operations oo

3935: FROM okc_k_lines_b kl
3936: WHERE kl.dnz_chr_id = cp_chr_id AND kl.lse_id IN (7, 8, 9, 10, 11, 13, 25, 35, 46)
3937: AND kl.id NOT IN(
3938: SELECT ol.object_cle_id
3939: FROM okc_operation_lines ol, okc_operation_instances oi, okc_class_operations oo
3940: WHERE oo.cls_code = 'SERVICE' AND oo.opn_code = 'REN_CON' AND oo.id = oi.cop_id
3941: AND ol.oie_id = oi.id AND ol.object_chr_id = cp_chr_id
3942: AND ol.subject_chr_id IS NOT NULL
3943: AND ol.process_flag = 'P' AND ol.active_yn = 'Y');

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

3947: --we order by active_yn desc, as for cancelled renewed contracts
3948: --active_yn = 'N'. So we want to get the active renewals (such as entered/signed status etc) first
3949: CURSOR c_check_hdr_renew (cp_chr_id IN NUMBER) IS
3950: SELECT k.contract_number, k.contract_number_modifier, st.ste_code
3951: FROM okc_operation_lines ol, okc_operation_instances oi, okc_class_operations oo,
3952: okc_statuses_b st, okc_k_headers_all_b k
3953: WHERE oo.cls_code = 'SERVICE' AND oo.opn_code = 'RENEWAL'
3954: AND oo.id = oi.cop_id
3955: AND ol.oie_id = oi.id AND ol.object_chr_id = cp_chr_id