APPS.OKL_PRB_UPGRADE_PVT dependencies on OKL_PRODUCTS

Line 446: ,( SELECT name from okl_products where id = p_pdt_id ) pdt_id

442: WHERE legal_entity_id = p_le_id
443: AND rownum <= 1 ) le_id
444: ,( SELECT contract_number FROM OKC_K_HEADERS_B WHERE id = p_khr_id ) khr_id
445: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_BOOK_CLASS',p_book_classification) book_classification
446: ,( SELECT name from okl_products where id = p_pdt_id ) pdt_id
447: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_INTEREST_CALCULATION_BASIS',p_int_calc_method) int_calc_method
448: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_REVENUE_RECOGNITION_METHOD',p_rev_rec_method) rev_rec_method
449: ,p_start_date_low start_date_low
450: ,p_start_date_high start_date_high

Line 474: ,okl_products pdt

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
478: ,fnd_lookups lkup

Line 657: ' ,okl_products pdt ,okl_ae_tmpt_sets aes , okl_st_gen_tmpt_sets gts ' ;

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
661: || ' AND chr.scs_code = ''LEASE'' AND chr.template_yn = ''N'' AND chr.orig_system_source_code <> ''OKL_REBOOK'' '