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 282: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT

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

Line 311: okl_ae_tmpt_Sets aes,

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

Line 852: okl_ae_tmpt_Sets aes,

848: CURSOR okl_new_version_date_csr( p_gtt_id IN OKL_ST_GEN_TEMPLATES.id%type) IS
849: select max(chr.start_date) MAX_START_DATE
850: from okc_k_headers_b chr,
851: okl_k_headers khr,
852: okl_ae_tmpt_Sets aes,
853: okl_st_gen_templates gtt,
854: okl_products pdt
855: where pdt.id = khr.pdt_id
856: and pdt.aes_id = aes.id

Line 4596: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT

4592: IS
4593: SELECT PDT.ID PDT_ID
4594: ,PRODUCT_STATUS_CODE
4595: FROM OKL_PRODUCTS PDT,
4596: OKL_AE_TMPT_SETS ATS, OKL_ST_GEN_TMPT_SETS SGT
4597: WHERE PDT.AES_ID = ATS.ID
4598: AND ATS.GTS_ID = SGT.ID
4599: AND SGT.ID = p_gts_id;
4600:

Line 4881: OKL_AE_TMPT_SETS ATS,

4877: IS
4878: SELECT PDT.ID PDT_ID
4879: ,PRODUCT_STATUS_CODE
4880: FROM OKL_PRODUCTS PDT,
4881: OKL_AE_TMPT_SETS ATS,
4882: OKL_ST_GEN_TMPT_SETS SGT
4883: WHERE PDT.AES_ID = ATS.ID
4884: AND ATS.GTS_ID = SGT.ID
4885: AND SGT.ID = p_gts_id;