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_PDT_PQY_VALS_UV

Line 2215: okl_pdt_pqy_vals_uv q1,

2211: q1.value deal_type,
2212: q2.value tax_owner
2213: FROM
2214: okl_products_v p,
2215: okl_pdt_pqy_vals_uv q1,
2216: okl_pdt_pqy_vals_uv q2
2217: WHERE
2218: p.id = q1.pdt_id AND q1.name = 'LEASE' AND q1.value IS NOT NULL AND
2219: p.id = q2.pdt_id AND q2.name = 'TAXOWNER' AND q2.value IS NOT NULL

Line 2216: okl_pdt_pqy_vals_uv q2

2212: q2.value tax_owner
2213: FROM
2214: okl_products_v p,
2215: okl_pdt_pqy_vals_uv q1,
2216: okl_pdt_pqy_vals_uv q2
2217: WHERE
2218: p.id = q1.pdt_id AND q1.name = 'LEASE' AND q1.value IS NOT NULL AND
2219: p.id = q2.pdt_id AND q2.name = 'TAXOWNER' AND q2.value IS NOT NULL
2220: UNION

Line 2227: okl_pdt_pqy_vals_uv q1

2223: q1.value deal_type,
2224: 'LESSEE' tax_owner
2225: FROM
2226: okl_products_v p,
2227: okl_pdt_pqy_vals_uv q1
2228: WHERE
2229: p.id = q1.pdt_id AND q1.name = 'INVESTOR' AND q1.value IS NOT NULL;
2230:
2231:

Line 2277: okl_pdt_pqy_vals_uv q1,

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
2281: p.id = q1.pdt_id AND q1.name = 'LEASE' AND q1.value = l_deal_type AND

Line 2278: okl_pdt_pqy_vals_uv q2

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
2281: p.id = q1.pdt_id AND q1.name = 'LEASE' AND q1.value = l_deal_type AND
2282: p.id = q2.pdt_id AND q2.name = 'TAXOWNER' AND q2.value = l_tax_owner

Line 2288: okl_pdt_pqy_vals_uv q1,

2284: SELECT
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;

Line 2686: okl_pdt_pqy_vals_uv q1,

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
2690: aes.gts_id IS NULL AND

Line 2687: okl_pdt_pqy_vals_uv q2

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
2690: aes.gts_id IS NULL AND
2691: p.id = q1.pdt_id AND q1.name = 'LEASE' AND q1.value IS NOT NULL AND

Line 2705: okl_pdt_pqy_vals_uv q1

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
2709: p.id = q1.pdt_id AND q1.name = 'INVESTOR' AND q1.value IS NOT NULL

Line 2859: l_deal_type okl_pdt_pqy_vals_uv.value%TYPE;

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;
2863: l_template_id okl_ae_templates.id%TYPE;

Line 2860: l_tax_owner okl_pdt_pqy_vals_uv.value%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;
2863: l_template_id okl_ae_templates.id%TYPE;
2864: l_new_template_id okl_ae_templates.id%TYPE;

Line 2886: l_prev_deal_type okl_pdt_pqy_vals_uv.value%TYPE;

2882: l_api_name VARCHAR2(100);
2883:
2884:
2885: l_error_msg_rec Okl_Accounting_Util.ERROR_MESSAGE_TYPE;
2886: l_prev_deal_type okl_pdt_pqy_vals_uv.value%TYPE;
2887: l_prev_aes_id NUMBER;
2888: -- Bug 4938066
2889: l_prev_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;
2890: l_aes_deal_type okl_pdt_pqy_vals_uv.value%TYPE;

Line 2889: l_prev_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;

2885: l_error_msg_rec Okl_Accounting_Util.ERROR_MESSAGE_TYPE;
2886: l_prev_deal_type okl_pdt_pqy_vals_uv.value%TYPE;
2887: l_prev_aes_id NUMBER;
2888: -- Bug 4938066
2889: l_prev_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;
2890: l_aes_deal_type okl_pdt_pqy_vals_uv.value%TYPE;
2891: l_aes_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;
2892:
2893:

Line 2890: l_aes_deal_type okl_pdt_pqy_vals_uv.value%TYPE;

2886: l_prev_deal_type okl_pdt_pqy_vals_uv.value%TYPE;
2887: l_prev_aes_id NUMBER;
2888: -- Bug 4938066
2889: l_prev_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;
2890: l_aes_deal_type okl_pdt_pqy_vals_uv.value%TYPE;
2891: l_aes_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;
2892:
2893:
2894: BEGIN

Line 2891: l_aes_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;

2887: l_prev_aes_id NUMBER;
2888: -- Bug 4938066
2889: l_prev_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;
2890: l_aes_deal_type okl_pdt_pqy_vals_uv.value%TYPE;
2891: l_aes_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;
2892:
2893:
2894: BEGIN
2895: x_return_status := Okl_Api.START_ACTIVITY (