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 1639: FROM cn_formula_inputs_all

1635: l_dim_unit_code VARCHAR2(30);
1636:
1637: CURSOR l_mul_inputs_csr IS
1638: SELECT rate_dim_sequence, calc_sql_exp_id, nvl(split_flag, 'N') split_flag, nvl(cumulative_flag, 'N') cumulative_flag
1639: FROM cn_formula_inputs_all
1640: WHERE calc_formula_id = g_formula_id
1641: AND org_id = g_org_id
1642: ORDER BY rate_dim_sequence;
1643:

Line 2262: FROM cn_formula_inputs_all

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
2265: AND rate_dim_sequence = 1);
2266:

Line 2532: FROM cn_formula_inputs_all

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
2535: AND rate_dim_sequence = (SELECT MIN(rate_dim_sequence)
2536: FROM cn_formula_inputs_all

Line 2536: FROM cn_formula_inputs_all

2532: FROM cn_formula_inputs_all
2533: WHERE calc_formula_id = g_formula_id
2534: AND org_id = g_org_id
2535: AND rate_dim_sequence = (SELECT MIN(rate_dim_sequence)
2536: FROM cn_formula_inputs_all
2537: WHERE calc_formula_id = g_formula_id
2538: AND org_id = g_org_id
2539: AND cumulative_flag = 'Y'));
2540: BEGIN

Line 2709: FROM cn_formula_inputs_all

2705: l_table_object_id cn_objects.object_id%type;
2706:
2707: CURSOR itd_inputs IS
2708: SELECT calc_sql_exp_id, rate_dim_sequence, split_flag, cumulative_flag
2709: FROM cn_formula_inputs_all
2710: WHERE calc_formula_id = g_formula_id
2711: AND org_id = g_org_id
2712: ORDER BY rate_dim_sequence;
2713: BEGIN

Line 3747: FROM cn_formula_inputs_all

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
3749: AND org_id = g_org_id
3750: AND rate_dim_sequence = 1);
3751:

Line 3851: FROM cn_formula_inputs_all

3847: l_dim_unit_code VARCHAR2(30);
3848:
3849: CURSOR l_mul_inputs_csr IS
3850: SELECT calc_sql_exp_id, rate_dim_sequence, nvl(split_flag, 'N') split_flag
3851: FROM cn_formula_inputs_all
3852: WHERE calc_formula_id = g_formula_id
3853: AND org_id = g_org_id
3854: ORDER BY rate_dim_sequence;
3855:

Line 3899: FROM cn_formula_inputs_all

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
3902: AND rate_dim_sequence = 1);
3903:

Line 4321: FROM cn_formula_inputs_all

4317: AND org_id = g_org_id;
4318:
4319: CURSOR f_inputs IS
4320: SELECT rate_dim_sequence, f_calc_sql_exp_id, cumulative_flag, split_flag
4321: FROM cn_formula_inputs_all
4322: WHERE calc_formula_id = g_formula_id
4323: AND org_id = g_org_id;
4324:
4325: CURSOR dim_type(p_rate_dim_sequence NUMBER) IS

Line 4711: FROM cn_formula_inputs_all

4707: AND org_id = g_org_id;
4708:
4709: CURSOR input IS
4710: SELECT calc_sql_exp_id
4711: FROM cn_formula_inputs_all
4712: WHERE calc_formula_id = g_formula_id
4713: AND org_id = g_org_id;
4714:
4715: CURSOR sql_statement(p_calc_sql_exp_id NUMBER) IS