eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_STRM_GEN_TEMPLATE_PVT dependencies on OKL_AE_TMPT_SETS

Line 281: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT

277: IS
278: SELECT PDT.ID PDT_ID
279: ,PRODUCT_STATUS_CODE
280: FROM OKL_PRODUCTS PDT,
281: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT
282: WHERE PDT.AES_ID = ATS.ID
283: AND ATS.GTS_ID = SGT.ID
284: AND SGT.ID = p_gts_id;
285:

Line 310: okl_ae_tmpt_Sets aes,

306: CURSOR okl_new_version_date_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
307: select max(chr.start_date) MAX_START_DATE
308: from okc_k_headers_b chr,
309: okl_k_headers khr,
310: okl_ae_tmpt_Sets aes,
311: okl_st_gen_templates gtt,
312: okl_products pdt
313: where pdt.id = khr.pdt_id
314: and pdt.aes_id = aes.id

Line 838: okl_ae_tmpt_Sets aes,

834: CURSOR okl_new_version_date_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
835: select max(chr.start_date) MAX_START_DATE
836: from okc_k_headers_b chr,
837: okl_k_headers khr,
838: okl_ae_tmpt_Sets aes,
839: okl_st_gen_templates gtt,
840: okl_products pdt
841: where pdt.id = khr.pdt_id
842: and pdt.aes_id = aes.id

Line 4581: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT

4577: IS
4578: SELECT PDT.ID PDT_ID
4579: ,PRODUCT_STATUS_CODE
4580: FROM OKL_PRODUCTS PDT,
4581: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT
4582: WHERE PDT.AES_ID = ATS.ID
4583: AND ATS.GTS_ID = SGT.ID
4584: AND SGT.ID = p_gts_id;
4585:

Line 4866: OKL_AE_TMPT_SETS ATS,

4862: IS
4863: SELECT PDT.ID PDT_ID
4864: ,PRODUCT_STATUS_CODE
4865: FROM OKL_PRODUCTS PDT,
4866: OKL_AE_TMPT_SETS ATS,
4867: OKL_ST_GEN_TMPT_SETS SGT
4868: WHERE PDT.AES_ID = ATS.ID
4869: AND ATS.GTS_ID = SGT.ID
4870: AND SGT.ID = p_gts_id;