APPS.OKL_PRB_UPGRADE_PVT dependencies on OKL_K_HEADERS

Line 473: ,okl_k_headers khr

469: 'PROCESS_ABORTED', 2,
470: 'TIME_OUT', 3,
471: 'SERVER_NA', 4, 100) pricing_error_level
472: FROM okc_k_headers_b chr -- Org Specific
473: ,okl_k_headers khr
474: ,okl_products pdt
475: ,okl_ae_tmpt_sets_all aes
476: ,okl_st_gen_tmpt_sets_all gts
477: ,okl_stream_interfaces sif

Line 656: ' FROM okc_k_headers_b chr, okl_k_headers khr, okc_k_lines_b cle ' ||

652: ' ,''PENDING_ASSIGNMENT'' ' || -- PROCESS_STATUS
653: ' ,SYSDATE ' || -- CREATION_DATE
654: ' ,chr.id ' || -- KHR_ID
655: ' ,COUNT(cle.id) ' || -- VOLUME = Number of Assets
656: ' FROM okc_k_headers_b chr, okl_k_headers khr, okc_k_lines_b cle ' ||
657: ' ,okl_products pdt ,okl_ae_tmpt_sets aes , okl_st_gen_tmpt_sets gts ' ;
658: -- Appending the Where Caluse including the Mandatory Predicates
659: l_query_string := l_query_string
660: || ' WHERE chr.id = khr.id AND chr.id = cle.dnz_chr_id AND cle.lse_id = 33 ' -- FREE_FORM1 for Assets