DBA Data[Home] [Help]

APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_ST_GEN_TMPT_SETS

Line 157: OKL_ST_GEN_TMPT_SETS gts

153: FROM
154: okl_k_headers khr,
155: okl_products_v pdt,
156: okl_ae_tmpt_sets_v aes,
157: OKL_ST_GEN_TMPT_SETS gts
158: WHERE
159: khr.pdt_id = pdt.id AND
160: pdt.aes_id = aes.id AND
161: aes.gts_id = gts.id AND

Line 960: ,okl_st_gen_tmpt_sets gts

956: ,okl_fe_eo_term_vers eov
957: ,okl_quick_quotes_b qqh
958: ,okl_products pdt
959: ,okl_ae_tmpt_sets aes
960: ,okl_st_gen_tmpt_sets gts
961: WHERE qqh.end_of_term_option_id = eov.end_of_term_ver_id
962: AND eov.end_of_term_id = eot.end_of_term_id
963: AND eot.product_id = pdt.id
964: AND pdt.aes_id = aes.id

Line 1071: ,okl_st_gen_tmpt_sets gts

1067: pdt.id pdt_id
1068: FROM okl_lease_quotes_b lqh
1069: ,okl_products pdt
1070: ,okl_ae_tmpt_sets aes
1071: ,okl_st_gen_tmpt_sets gts
1072: WHERE lqh.product_id = pdt.id
1073: AND pdt.aes_id = aes.id
1074: AND aes.gts_id = gts.id
1075: AND lqh.id = p_lq_id;