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.CN_FORMULA_GEN_PKG dependencies on CN_CALC_SQL_EXPS_ALL

Line 161: FROM cn_calc_sql_exps_all cse,(SELECT 'PRF' exp_type_name,perf_measure_id exp_id

157: SELECT formula_exps.exp_type_name exp_type_name,
158: dbms_lob.substr(piped_sql_from) sql_from,
159: dbms_lob.substr(piped_sql_select) sql_select,
160: cse.CALC_SQL_EXP_ID CALC_SQL_EXP_ID
161: FROM cn_calc_sql_exps_all cse,(SELECT 'PRF' exp_type_name,perf_measure_id exp_id
162: FROM cn_calc_formulas_all
163: WHERE calc_formula_id = p_formula_id
164: AND org_id = g_org_id
165: UNION ALL

Line 680: FROM cn_calc_sql_exps_all

676: p2 pls_integer; -- temporary position pointer
677:
678: CURSOR exprs IS
679: SELECT dbms_lob.substr(piped_sql_select) sql_select
680: FROM cn_calc_sql_exps_all
681: WHERE calc_sql_exp_id IN (SELECT perf_measure_id
682: FROM cn_calc_formulas_all
683: WHERE calc_formula_id = p_formula_id
684: AND org_id = g_org_id

Line 697: FROM cn_calc_sql_exps_all

693: WHERE calc_formula_id = p_formula_id
694: AND org_id = g_org_id);
695: CURSOR exprs2 IS
696: SELECT dbms_lob.substr(piped_sql_select) sql_select
697: FROM cn_calc_sql_exps_all
698: WHERE calc_sql_exp_id IN (SELECT output_exp_id
699: FROM cn_calc_formulas_all
700: WHERE calc_formula_id = p_formula_id
701: AND org_id = g_org_id

Line 1659: FROM cn_calc_sql_exps_all

1655: AND ROWNUM = 1));
1656:
1657: CURSOR l_sql_select_from_csr (l_calc_sql_exp_id NUMBER) IS
1658: SELECT sql_select input_sql_select, sql_from input_sql_from
1659: FROM cn_calc_sql_exps_all
1660: WHERE calc_sql_exp_id = l_calc_sql_exp_id;
1661:
1662: BEGIN
1663: procedure_name := 'get_input';

Line 2015: FROM cn_calc_sql_exps_all

2011: CURSOR l_sql_select_from_csr IS
2012: SELECT calc_sql_exp_id,
2013: sql_select output_sql_select,
2014: sql_from output_sql_from
2015: FROM cn_calc_sql_exps_all
2016: WHERE calc_sql_exp_id = (SELECT output_exp_id
2017: FROM cn_calc_formulas_all
2018: WHERE calc_formula_id = g_formula_id
2019: AND org_id = g_org_id);

Line 2253: from cn_calc_sql_exps_all

2249: l_input_sql_exp_id cn_calc_sql_exps.calc_sql_exp_id%TYPE;
2250:
2251: CURSOR l_perf_select_from_csr IS
2252: select sql_select, sql_from
2253: from cn_calc_sql_exps_all
2254: where calc_sql_exp_id = g_perf_measure_id;
2255:
2256: CURSOR l_input_select_from_csr IS
2257: SELECT calc_sql_exp_id,

Line 2260: FROM cn_calc_sql_exps_all

2256: CURSOR l_input_select_from_csr IS
2257: SELECT calc_sql_exp_id,
2258: sql_select input_sql_select,
2259: sql_from input_sql_from
2260: FROM cn_calc_sql_exps_all
2261: WHERE calc_sql_exp_id = (SELECT calc_sql_exp_id
2262: FROM cn_formula_inputs_all
2263: WHERE calc_formula_id = g_formula_id
2264: AND org_id = g_org_id

Line 2530: FROM cn_calc_sql_exps_all

2526: l_sql_select VARCHAR2(8000);
2527:
2528: CURSOR exps IS
2529: SELECT dbms_lob.substr(sql_select) sql_select
2530: FROM cn_calc_sql_exps_all
2531: WHERE calc_sql_exp_id = (SELECT calc_sql_exp_id
2532: FROM cn_formula_inputs_all
2533: WHERE calc_formula_id = g_formula_id
2534: AND org_id = g_org_id

Line 2974: FROM cn_calc_sql_exps_all

2970: || itd_input.rate_dim_sequence || ';' );
2971:
2972: SELECT sql_select input_sql_select, sql_from input_sql_from
2973: INTO l_input_sql_select_clob, l_input_sql_from_clob
2974: FROM cn_calc_sql_exps_all
2975: WHERE calc_sql_exp_id = itd_input.calc_sql_exp_id
2976: AND org_id = g_org_id;
2977:
2978: convert_clob_to_string( l_input_sql_select_clob, l_input_sql_select );

Line 3059: FROM cn_calc_sql_exps_all

3055: cn_utils.appendcr(body_code);
3056: IF g_itd_flag = 'Y' THEN
3057: SELECT sql_select output_sql_select
3058: INTO l_output_sql_select_clob
3059: FROM cn_calc_sql_exps_all
3060: WHERE org_id = g_org_id
3061: AND calc_sql_exp_id = (SELECT output_exp_id
3062: FROM cn_calc_formulas_all
3063: WHERE calc_formula_id = g_formula_id

Line 3078: FROM cn_calc_sql_exps_all

3074: END IF;
3075:
3076: SELECT sql_select input_sql_select, sql_from input_sql_from
3077: INTO l_input_sql_select_clob, l_input_sql_from_clob
3078: FROM cn_calc_sql_exps_all
3079: WHERE org_id = g_org_id
3080: AND calc_sql_exp_id = (SELECT output_exp_id
3081: FROM cn_calc_formulas_all
3082: WHERE calc_formula_id = g_formula_id

Line 3732: from cn_calc_sql_exps_all

3728:
3729: IF g_perf_measure_id IS NOT NULL THEN
3730: select sql_select, sql_from
3731: into l_input_sql_select_clob, l_input_sql_from_clob
3732: from cn_calc_sql_exps_all
3733: where calc_sql_exp_id = g_perf_measure_id
3734: and org_id = g_org_id;
3735:
3736: convert_clob_to_string(l_input_sql_select_clob, l_input_sql_select);

Line 3744: FROM cn_calc_sql_exps_all

3740:
3741: ELSE /* default to be the input with the lowest input_sequence */
3742: SELECT sql_select input_sql_select, sql_from input_sql_from
3743: INTO l_input_sql_select_clob, l_input_sql_from_clob
3744: FROM cn_calc_sql_exps_all
3745: WHERE org_id = g_org_id
3746: AND calc_sql_exp_id = (SELECT calc_sql_exp_id
3747: FROM cn_formula_inputs_all
3748: WHERE calc_formula_id = g_formula_id

Line 3871: FROM cn_calc_sql_exps_all

3867: AND ROWNUM = 1));
3868:
3869: CURSOR l_input_sql_select_from_csr (l_calc_sql_exp_id NUMBER) IS
3870: SELECT sql_select input_sql_select, sql_from input_sql_from
3871: FROM cn_calc_sql_exps_all
3872: WHERE calc_sql_exp_id = l_calc_sql_exp_id
3873: AND org_id = g_org_id;
3874:
3875: l_output_sql_select varchar2(8000);

Line 3884: FROM cn_calc_sql_exps_all

3880: l_output_sql_where varchar2(4000) := 'WHERE 1=1 ';
3881:
3882: CURSOR l_output_select_from_csr IS
3883: SELECT sql_select output_sql_select, sql_from output_sql_from
3884: FROM cn_calc_sql_exps_all
3885: WHERE calc_sql_exp_id = (SELECT output_exp_id
3886: FROM cn_calc_formulas_all
3887: WHERE calc_formula_id = g_formula_id
3888: AND org_id = g_org_id);

Line 3892: from cn_calc_sql_exps_all

3888: AND org_id = g_org_id);
3889:
3890: CURSOR l_perf_select_from_csr IS
3891: select sql_select, sql_from
3892: from cn_calc_sql_exps_all
3893: where calc_sql_exp_id = g_perf_measure_id;
3894:
3895: CURSOR l_inp_perf_select_from_csr IS
3896: SELECT sql_select input_sql_select, sql_from input_sql_from

Line 3897: FROM cn_calc_sql_exps_all

3893: where calc_sql_exp_id = g_perf_measure_id;
3894:
3895: CURSOR l_inp_perf_select_from_csr IS
3896: SELECT sql_select input_sql_select, sql_from input_sql_from
3897: FROM cn_calc_sql_exps_all
3898: WHERE calc_sql_exp_id = (SELECT calc_sql_exp_id
3899: FROM cn_formula_inputs_all
3900: WHERE calc_formula_id = g_formula_id
3901: AND org_id = g_org_id

Line 4339: FROM cn_calc_sql_exps_all

4335: AND ROWNUM = 1));
4336:
4337: CURSOR sql_statement(p_calc_sql_exp_id NUMBER) IS
4338: SELECT dbms_lob.substr(sql_select), dbms_lob.substr(sql_from)
4339: FROM cn_calc_sql_exps_all
4340: WHERE calc_sql_exp_id = p_calc_sql_exp_id;
4341: BEGIN
4342: OPEN f_output;
4343: FETCH f_output INTO l_output_exp_id;

Line 4717: FROM cn_calc_sql_exps_all

4713: AND org_id = g_org_id;
4714:
4715: CURSOR sql_statement(p_calc_sql_exp_id NUMBER) IS
4716: SELECT dbms_lob.substr(piped_sql_select), dbms_lob.substr(sql_select), dbms_lob.substr(sql_from)
4717: FROM cn_calc_sql_exps_all
4718: WHERE calc_sql_exp_id = p_calc_sql_exp_id;
4719: BEGIN
4720: OPEN output;
4721: FETCH output INTO l_output_exp_id, l_modeling_flag;