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_BILL_MIGRATION dependencies on OKC_STATUSES_B

Line 267: from okc_statuses_b sta,

263:
264: cursor l_header_agg_csr is
265: select min(id) minid, max(id) maxid, count(*) total,
266: avg(id) avgid, stddev(id) stdid
267: from okc_statuses_b sta,
268: okc_k_headers_b hdr
269: where hdr.id not in (-2,-1)
270: and sta.ste_code not in ('TERMINATED','ENTERED','CANCELLED')
271: and sta.code = hdr.sts_code

Line 358: from okc_statuses_b sta,

354:
355: cursor l_header_agg_csr is
356: select min(id) minid, max(id) maxid, count(*) total,
357: avg(id) avgid, stddev(id) stdid
358: from okc_statuses_b sta,
359: okc_k_headers_b hdr
360: where hdr.id not in (-2,-1)
361: and sta.ste_code not in ('TERMINATED','ENTERED','CANCELLED')
362: and sta.code = hdr.sts_code

Line 1267: okc_statuses_b sta

1263: lines.date_terminated date_terminated,lines.upg_orig_system_ref upg_orig_system_ref,
1264: lines.upg_orig_system_ref_id upg_orig_system_ref_id
1265: FROM okc_k_lines_b lines,
1266: okc_k_headers_b hdr,
1267: okc_statuses_b sta
1268: where hdr.id BETWEEN p_chr_id_lo AND p_chr_id_hi
1269: and sta.ste_code not in ('TERMINATED','ENTERED','CANCELLED')
1270: and sta.code = hdr.sts_code
1271: and hdr.scs_code = 'WARRANTY'