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 3483: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_k_headers_all_b c, OKC_SUBCLASSES_B SCS

3479: a.conversion_euro_rate, b.renewal_po_number, b.trxn_extension_id,
3480: b.grace_period, b.grace_duration, c.date_renewed, -- added for bug 6086893
3481: a.start_date, a.end_date, c.scs_code, c.sts_code, c.estimated_amount,
3482: c.start_date, c.end_date, scs.cls_code, c.id
3483: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_k_headers_all_b c, OKC_SUBCLASSES_B SCS
3484: WHERE a.id = b.chr_id
3485: AND a.id = cp_chr_id
3486: AND c.id = a.orig_system_id1
3487: AND c.scs_code = scs.code;

Line 3504: l_cls_code okc_subclasses_b.cls_code%TYPE;

3500: l_old_sts_code okc_k_headers_all_b.sts_code%TYPE;
3501: l_old_estimated_amount okc_k_headers_all_b.estimated_amount%TYPE;
3502: l_old_start_date okc_k_headers_all_b.start_date%TYPE;
3503: l_old_end_date okc_k_headers_all_b.end_date%TYPE;
3504: l_cls_code okc_subclasses_b.cls_code%TYPE;
3505: l_old_k_id okc_k_headers_all_b.id%TYPE;
3506: -- end added for bug 6086893
3507:
3508: l_k_num VARCHAR2(120);