APPS.OKS_BILL_MIGRATION dependencies on OKC_K_HEADERS_B

Line 268: okc_k_headers_b hdr

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
272: and hdr.scs_code in ('SERVICE','WARRANTY');

Line 359: okc_k_headers_b hdr

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
363: and hdr.scs_code = 'WARRANTY';

Line 485: From OKC_K_HEADERS_B hdr

481: Select hdr.ID
482: ,hdr.CONTRACT_NUMBER
483: ,hdr.CURRENCY_CODE
484: ,hdr.AUTHORING_ORG_ID
485: From OKC_K_HEADERS_B hdr
486: Where exists (Select 1
487: From okc_k_lines_b ln
488: ,oks_bill_cont_lines bcl
489: Where hdr.id = ln.dnz_chr_id

Line 1266: okc_k_headers_b hdr,

1262: lines.start_date start_date,NVL(lines.date_terminated,lines.end_date) end_date,
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