441: SELECT to_char(pdt.id) pid,
442: chr.scs_code
443: FROM okc_k_headers_v chr,
444: okl_k_headers khr,
445: okl_products_v pdt
446: WHERE khr.id = chr.id
447: AND chr.id = p_khr_id
448: AND khr.pdt_id = pdt.id(+);
449:
446: WHERE khr.id = chr.id
447: AND chr.id = p_khr_id
448: AND khr.pdt_id = pdt.id(+);
449:
450: l_pdt_id okl_products.id%type;
451: l_scs_code okc_k_headers_all_b.scs_code%type;
452: -- gboomina added for Bug 6763287 - End
453:
454: BEGIN