DBA Data[Home] [Help]

APPS.OKL_STREAMS_UTIL dependencies on OKL_ST_GEN_TMPT_SETS_ALL

Line 2895: ,okl_st_gen_tmpt_sets_all gts

2891: ,okc_k_headers_all_b chr
2892: ,okl_k_headers khr
2893: ,okl_products pdt
2894: ,okl_ae_tmpt_sets_all aes
2895: ,okl_st_gen_tmpt_sets_all gts
2896: Where sao.org_id = chr.authoring_org_id
2897: and chr.id = osi.khr_id
2898: and osi.transaction_number = p_trx_number
2899: and chr.id = khr.id

Line 3029: ,okl_st_gen_tmpt_sets_all gts

3025: from okc_k_headers_all_b chr
3026: ,okl_k_headers khr
3027: ,okl_products pdt
3028: ,okl_ae_tmpt_sets_all aes
3029: ,okl_st_gen_tmpt_sets_all gts
3030: Where chr.id = p_khr_id
3031: and chr.id = khr.id
3032: and khr.pdt_id = pdt.id
3033: and pdt.aes_id = aes.id

Line 3152: ,okl_st_gen_tmpt_sets_all gts

3148: ,okc_k_headers_all_b chr
3149: ,okl_k_headers khr
3150: ,okl_products pdt
3151: ,okl_ae_tmpt_sets_all aes
3152: ,okl_st_gen_tmpt_sets_all gts
3153: WHERE osi.transaction_number = p_trx_id
3154: AND siyb.sif_id = osi.id
3155: AND siyb.target_value IS NOT NULL
3156: AND chr.id = osi.khr_id