APPS.CN_SCA_DENORM_RULES_PVT dependencies on CN_SCA_RULE_COND_VALS_MV

Line 42: FROM cn_sca_rule_cond_vals_mv mv,

38:
39: CURSOR rule_attr_cur IS
40: SELECT mv.sca_rule_attribute_id,
41: ra.src_column_name
42: FROM cn_sca_rule_cond_vals_mv mv,
43: cn_sca_rule_attributes ra
44: WHERE mv.sca_rule_attribute_id = ra.sca_rule_attribute_id
45: AND mv.transaction_source = p_transaction_source
46: AND EXISTS(

Line 63: FROM cn_sca_rule_cond_vals_mv mv

59: GROUP BY rule_attr_comb_value;
60: --
61: CURSOR operator_cur(l_rule_attr_id NUMBER) IS
62: SELECT mv.operator_id
63: FROM cn_sca_rule_cond_vals_mv mv
64: WHERE mv.sca_rule_attribute_id = l_rule_attr_id
65: GROUP BY mv.operator_id;
66:
67: --+

Line 193: FROM cn_sca_rule_cond_vals_mv mv

189: fnd_global.user_id,
190: SYSDATE,
191: fnd_global.login_id,
192: p_org_id
193: FROM cn_sca_rule_cond_vals_mv mv
194: WHERE mv.sca_credit_rule_id IN (
195: SELECT sca_credit_rule_id
196: FROM cn_sca_denorm_rules dr
197: WHERE rule_attr_comb_value = get_attr_rec.rule_attr_comb_value

Line 341: DBMS_MVIEW.REFRESH('CN_SCA_RULE_COND_VALS_MV','C','',TRUE,FALSE,0,4,0,TRUE);

337: WHERE transaction_source = p_txn_src
338: AND org_id = p_org_id;
339: debugmsg('Rules Sync : Deleted denorm rule count : '||SQL%ROWCOUNT);
340: debugmsg('Rules Sync : Refreshing MV');
341: DBMS_MVIEW.REFRESH('CN_SCA_RULE_COND_VALS_MV','C','',TRUE,FALSE,0,4,0,TRUE);
342: debugmsg('Rules Sync : Refreshing MV completed');
343: COMMIT;
344: EXCEPTION
345: WHEN OTHERS THEN

Line 515: DBMS_MVIEW.REFRESH('CN_SCA_RULE_COND_VALS_MV','C','',TRUE,FALSE,0,4,0,TRUE);

511:
512: debugmsg('Rules Sync : Start of the MV Refresh');
513:
514: BEGIN
515: DBMS_MVIEW.REFRESH('CN_SCA_RULE_COND_VALS_MV','C','',TRUE,FALSE,0,4,0,TRUE);
516: EXCEPTION
517: WHEN OTHERS THEN
518: debugmsg('Results Transfer : Unexpected exception');
519: RAISE;