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_SUBCLASSES_B

Line 3472: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_k_headers_all_b c, OKC_SUBCLASSES_B SCS

3468: a.conversion_euro_rate, b.renewal_po_number, b.trxn_extension_id,
3469: b.grace_period, b.grace_duration, c.date_renewed, -- added for bug 6086893
3470: a.start_date, a.end_date, c.scs_code, c.sts_code, c.estimated_amount,
3471: c.start_date, c.end_date, scs.cls_code, c.id
3472: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_k_headers_all_b c, OKC_SUBCLASSES_B SCS
3473: WHERE a.id = b.chr_id
3474: AND a.id = cp_chr_id
3475: AND c.id = a.orig_system_id1
3476: AND c.scs_code = scs.code;

Line 3486: l_cls_code okc_subclasses_b.cls_code%TYPE;

3482: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3483: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3484: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3485: l_old_end_date okc_k_headers_all_b.end_date%TYPE;
3486: l_cls_code okc_subclasses_b.cls_code%TYPE;
3487: l_old_k_id okc_k_headers_all_b.id%TYPE;
3488: -- end added for bug 6086893
3489:
3490: l_k_num VARCHAR2(120);