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_STREAM_MIGRATION_PVT dependencies on OKL_AE_TMPT_SETS

Line 2276: okl_ae_tmpt_sets aes,

2272: SELECT
2273: DISTINCT aes.org_id
2274: FROM
2275: okl_products_v p,
2276: okl_ae_tmpt_sets aes,
2277: okl_pdt_pqy_vals_uv q1,
2278: okl_pdt_pqy_vals_uv q2
2279: WHERE
2280: p.aes_id = aes.id AND

Line 2289: okl_ae_tmpt_sets aes

2285: DISTINCT aes.org_id
2286: FROM
2287: okl_products_v p,
2288: okl_pdt_pqy_vals_uv q1,
2289: okl_ae_tmpt_sets aes
2290: WHERE
2291: p.aes_id = aes.id AND
2292: p.id = q1.pdt_id AND q1.name = 'INVESTOR' AND q1.value = l_deal_type;
2293:

Line 2305: FROM okl_ae_tmpt_sets aes;

2301:
2302:
2303: CURSOR gtt_start_date_csr IS
2304: SELECT MIN(aes.start_date)
2305: FROM okl_ae_tmpt_sets aes;
2306:
2307: j NUMBER;
2308: l_new_gts_name VARCHAR2(100);
2309: l_org_name VARCHAR2(150);

Line 2670: FROM okl_ae_tmpt_sets;

2666: -- Cursor to select all existing org from template sets
2667:
2668: CURSOR aes_org_csr IS
2669: SELECT DISTINCT org_id
2670: FROM okl_ae_tmpt_sets;
2671:
2672:
2673: -- Cursor to select all existing products and its values
2674: CURSOR pdt_csr IS

Line 2685: okl_ae_tmpt_sets_v aes,

2681: q2.value tax_owner,
2682: aes.name aes_name
2683: FROM
2684: okl_products_v p,
2685: okl_ae_tmpt_sets_v aes,
2686: okl_pdt_pqy_vals_uv q1,
2687: okl_pdt_pqy_vals_uv q2
2688: WHERE
2689: p.aes_id = aes.id AND

Line 2704: okl_ae_tmpt_sets_v aes,

2700: 'LESSEE' tax_owner,
2701: aes.name aes_name
2702: FROM
2703: okl_products_v p,
2704: okl_ae_tmpt_sets_v aes,
2705: okl_pdt_pqy_vals_uv q1
2706: WHERE
2707: p.aes_id = aes.id AND
2708: aes.gts_id IS NULL AND

Line 2746: FROM okl_ae_tmpt_sets_v

2742: last_updated_by,
2743: last_update_date,
2744: last_update_login,
2745: gts_id
2746: FROM okl_ae_tmpt_sets_v
2747: WHERE okl_ae_tmpt_sets_v.id = p_id;
2748:
2749: -- Cursor to get all the templates for a template set.
2750:

Line 2747: WHERE okl_ae_tmpt_sets_v.id = p_id;

2743: last_update_date,
2744: last_update_login,
2745: gts_id
2746: FROM okl_ae_tmpt_sets_v
2747: WHERE okl_ae_tmpt_sets_v.id = p_id;
2748:
2749: -- Cursor to get all the templates for a template set.
2750:
2751: CURSOR avlv_pk_csr (p_aes_id IN NUMBER) IS

Line 2858: l_aes_id okl_ae_tmpt_sets.id%TYPE;

2854:
2855: l_product_name okl_products_v.name%TYPE;
2856: l_product_id okl_products_v.id%TYPE;
2857: l_ptl_id okl_products_v.ptl_id%TYPE;
2858: l_aes_id okl_ae_tmpt_sets.id%TYPE;
2859: l_deal_type okl_pdt_pqy_vals_uv.value%TYPE;
2860: l_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;
2861:
2862: l_new_aes_id okl_ae_tmpt_sets.id%TYPE;

Line 2862: l_new_aes_id okl_ae_tmpt_sets.id%TYPE;

2858: l_aes_id okl_ae_tmpt_sets.id%TYPE;
2859: l_deal_type okl_pdt_pqy_vals_uv.value%TYPE;
2860: l_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;
2861:
2862: l_new_aes_id okl_ae_tmpt_sets.id%TYPE;
2863: l_template_id okl_ae_templates.id%TYPE;
2864: l_new_template_id okl_ae_templates.id%TYPE;
2865:
2866: l_gts_id OKL_ST_GEN_TMPT_SETS.id%TYPE;

Line 2868: l_old_aes_name okl_ae_tmpt_sets_v.name%TYPE;

2864: l_new_template_id okl_ae_templates.id%TYPE;
2865:
2866: l_gts_id OKL_ST_GEN_TMPT_SETS.id%TYPE;
2867: l_gts_name OKL_ST_GEN_TMPT_SETS.name%TYPE;
2868: l_old_aes_name okl_ae_tmpt_sets_v.name%TYPE;
2869:
2870: l_row_found VARCHAR2(1000);
2871: l_template_set_found VARCHAR2(1);
2872: l_templates_found VARCHAR2(1);