APPS.RLM_MANAGE_DEMAND_SV dependencies on MSC_SOURCING_RULES

Line 1988: FROM msc_sourcing_rules

1984: --Bugfix 10053830 End
1985: AND mislv.rank = x_rank
1986: AND mislv.ship_to_site_id = x_ship_to_site_id
1987: AND exists (SELECT null
1988: FROM msc_sourcing_rules
1989: WHERE sourcing_rule_id = mislv.sourcing_rule_id
1990: AND planning_active = k_PLANNING_ACTIVE)
1991: ORDER BY mislv.allocation_percent;
1992: --

Line 2034: FROM msc_sourcing_rules

2030: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2031: --Bugfix 10053830 End
2032: AND mislv.ship_to_site_id = x_Group_rec.ship_to_site_use_id
2033: AND exists (SELECT null
2034: FROM msc_sourcing_rules
2035: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2036: AND planning_active = k_PLANNING_ACTIVE);
2037: --
2038: CURSOR c_MRP_site IS

Line 2081: FROM msc_sourcing_rules

2077: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2078: --Bugfix 10053830 End
2079: AND mislv.rank = x_rank
2080: AND exists (SELECT null
2081: FROM msc_sourcing_rules
2082: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2083: AND planning_active = k_PLANNING_ACTIVE)
2084: ORDER BY mislv.allocation_percent;
2085: --

Line 2128: FROM msc_sourcing_rules

2124: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date
2125: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR rlm_dp_sv.g_dsp_start_time < mislv.effective_date) --Bugfix 6051397
2126: --Bugfix 10053830 End
2127: AND exists (SELECT null
2128: FROM msc_sourcing_rules
2129: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2130: AND planning_active = k_PLANNING_ACTIVE);
2131: --
2132: --perf changes

Line 2275: ELSIF v_count_msc = 0 THEN /* No msc sourcing rules setup at the site level */

2271: v_assign_set_id := TO_NUMBER(SUBSTR(v_assign_set,4));
2272: -- Bug 3534969 jckwok
2273: v_source_level := 'PRFL';
2274: --
2275: ELSIF v_count_msc = 0 THEN /* No msc sourcing rules setup at the site level */
2276: --
2277: OPEN c_MSC_item; -- second level of hierarchy: MSC ITEM
2278: --
2279: LOOP