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_FORMULA_INPUTS_ALL

Line 172: FROM cn_formula_inputs_all

168: WHERE calc_formula_id = p_formula_id
169: AND org_id = g_org_id
170: UNION ALL
171: SELECT 'INP' exp_type_name,calc_sql_exp_id exp_id
172: FROM cn_formula_inputs_all
173: WHERE calc_formula_id = p_formula_id
174: AND org_id = g_org_id) formula_exps
175: WHERE cse.CALC_SQL_EXP_ID = formula_exps.exp_id;
176:

Line 692: FROM cn_formula_inputs_all

688: WHERE calc_formula_id = p_formula_id
689: AND org_id = g_org_id
690: UNION ALL
691: SELECT calc_sql_exp_id
692: FROM cn_formula_inputs_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

Line 704: FROM cn_formula_inputs_all

700: WHERE calc_formula_id = p_formula_id
701: AND org_id = g_org_id
702: UNION ALL
703: SELECT calc_sql_exp_id
704: FROM cn_formula_inputs_all
705: WHERE calc_formula_id = p_formula_id
706: AND org_id = g_org_id);
707:
708: -- Added for 11.5.10 Performance Enhancments

Line 711: FROM cn_formula_inputs_all

707:
708: -- Added for 11.5.10 Performance Enhancments
709: CURSOR perf_measure_input_seq_cur IS
710: SELECT rate_dim_sequence
711: FROM cn_formula_inputs_all
712: WHERE calc_formula_id = p_formula_id
713: AND calc_sql_exp_id = g_perf_measure_id;
714: BEGIN
715: SELECT calc_formula_id, trx_group_code, itd_flag, cumulative_flag, perf_measure_id, split_flag,

Line 1632: FROM cn_formula_inputs_all

1628: l_dim_unit_code VARCHAR2(30);
1629:
1630: CURSOR l_mul_inputs_csr IS
1631: SELECT rate_dim_sequence, calc_sql_exp_id, nvl(split_flag, 'N') split_flag, nvl(cumulative_flag, 'N') cumulative_flag
1632: FROM cn_formula_inputs_all
1633: WHERE calc_formula_id = g_formula_id
1634: AND org_id = g_org_id
1635: ORDER BY rate_dim_sequence;
1636:

Line 2249: FROM cn_formula_inputs_all

2245: sql_select input_sql_select,
2246: sql_from input_sql_from
2247: FROM cn_calc_sql_exps_all
2248: WHERE calc_sql_exp_id = (SELECT calc_sql_exp_id
2249: FROM cn_formula_inputs_all
2250: WHERE calc_formula_id = g_formula_id
2251: AND org_id = g_org_id
2252: AND rate_dim_sequence = 1);
2253:

Line 2519: FROM cn_formula_inputs_all

2515: CURSOR exps IS
2516: SELECT dbms_lob.substr(sql_select) sql_select
2517: FROM cn_calc_sql_exps_all
2518: WHERE calc_sql_exp_id = (SELECT calc_sql_exp_id
2519: FROM cn_formula_inputs_all
2520: WHERE calc_formula_id = g_formula_id
2521: AND org_id = g_org_id
2522: AND rate_dim_sequence = (SELECT MIN(rate_dim_sequence)
2523: FROM cn_formula_inputs_all

Line 2523: FROM cn_formula_inputs_all

2519: FROM cn_formula_inputs_all
2520: WHERE calc_formula_id = g_formula_id
2521: AND org_id = g_org_id
2522: AND rate_dim_sequence = (SELECT MIN(rate_dim_sequence)
2523: FROM cn_formula_inputs_all
2524: WHERE calc_formula_id = g_formula_id
2525: AND org_id = g_org_id
2526: AND cumulative_flag = 'Y'));
2527: BEGIN

Line 2696: FROM cn_formula_inputs_all

2692: l_table_object_id cn_objects.object_id%type;
2693:
2694: CURSOR itd_inputs IS
2695: SELECT calc_sql_exp_id, rate_dim_sequence, split_flag, cumulative_flag
2696: FROM cn_formula_inputs_all
2697: WHERE calc_formula_id = g_formula_id
2698: AND org_id = g_org_id
2699: ORDER BY rate_dim_sequence;
2700: BEGIN

Line 3734: FROM cn_formula_inputs_all

3730: INTO l_input_sql_select_clob, l_input_sql_from_clob
3731: FROM cn_calc_sql_exps_all
3732: WHERE org_id = g_org_id
3733: AND calc_sql_exp_id = (SELECT calc_sql_exp_id
3734: FROM cn_formula_inputs_all
3735: WHERE calc_formula_id = g_formula_id
3736: AND org_id = g_org_id
3737: AND rate_dim_sequence = 1);
3738:

Line 3838: FROM cn_formula_inputs_all

3834: l_dim_unit_code VARCHAR2(30);
3835:
3836: CURSOR l_mul_inputs_csr IS
3837: SELECT calc_sql_exp_id, rate_dim_sequence, nvl(split_flag, 'N') split_flag
3838: FROM cn_formula_inputs_all
3839: WHERE calc_formula_id = g_formula_id
3840: AND org_id = g_org_id
3841: ORDER BY rate_dim_sequence;
3842:

Line 3886: FROM cn_formula_inputs_all

3882: CURSOR l_inp_perf_select_from_csr IS
3883: SELECT sql_select input_sql_select, sql_from input_sql_from
3884: FROM cn_calc_sql_exps_all
3885: WHERE calc_sql_exp_id = (SELECT calc_sql_exp_id
3886: FROM cn_formula_inputs_all
3887: WHERE calc_formula_id = g_formula_id
3888: AND org_id = g_org_id
3889: AND rate_dim_sequence = 1);
3890:

Line 4308: FROM cn_formula_inputs_all

4304: AND org_id = g_org_id;
4305:
4306: CURSOR f_inputs IS
4307: SELECT rate_dim_sequence, f_calc_sql_exp_id, cumulative_flag, split_flag
4308: FROM cn_formula_inputs_all
4309: WHERE calc_formula_id = g_formula_id
4310: AND org_id = g_org_id;
4311:
4312: CURSOR dim_type(p_rate_dim_sequence NUMBER) IS

Line 4698: FROM cn_formula_inputs_all

4694: AND org_id = g_org_id;
4695:
4696: CURSOR input IS
4697: SELECT calc_sql_exp_id
4698: FROM cn_formula_inputs_all
4699: WHERE calc_formula_id = g_formula_id
4700: AND org_id = g_org_id;
4701:
4702: CURSOR sql_statement(p_calc_sql_exp_id NUMBER) IS