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: /* bug 13504898 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 : 12.2 - MV is converted to view - no refresh process');
341: /* bug 13504898 DBMS_MVIEW.REFRESH('CN_SCA_RULE_COND_VALS_MV','C','',TRUE,FALSE,0,4,0,TRUE);
342: debugmsg('Rules Sync : Refreshing MV completed');
343: */
344: COMMIT;
345: EXCEPTION

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

515: /* Check introduced for bug14374323 */
516:
517: IF (ad_zd.get_edition('PATCH') IS NULL) THEN
518: BEGIN
519: DBMS_MVIEW.REFRESH('CN_SCA_RULE_COND_VALS_MV','C','',TRUE,FALSE,0,4,0,TRUE);
520: EXCEPTION
521: WHEN OTHERS THEN
522: debugmsg('Results Transfer : Unexpected exception');
523: RAISE;