APPS.RLM_MANAGE_DEMAND_SV dependencies on MSC_SOURCING_RULES

Line 1978: FROM msc_sourcing_rules

1974: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397
1975: AND mislv.rank = x_rank
1976: AND mislv.ship_to_site_id = x_ship_to_site_id
1977: AND exists (SELECT null
1978: FROM msc_sourcing_rules
1979: WHERE sourcing_rule_id = mislv.sourcing_rule_id
1980: AND planning_active = k_PLANNING_ACTIVE)
1981: ORDER BY mislv.allocation_percent;
1982: --

Line 2016: FROM msc_sourcing_rules

2012: AND (SYSDATE BETWEEN mislv.effective_date
2013: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397
2014: AND mislv.ship_to_site_id = x_Group_rec.ship_to_site_use_id
2015: AND exists (SELECT null
2016: FROM msc_sourcing_rules
2017: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2018: AND planning_active = k_PLANNING_ACTIVE);
2019: --
2020: CURSOR c_MRP_site IS

Line 2055: FROM msc_sourcing_rules

2051: AND (SYSDATE BETWEEN mislv.effective_date AND
2052: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397
2053: AND mislv.rank = x_rank
2054: AND exists (SELECT null
2055: FROM msc_sourcing_rules
2056: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2057: AND planning_active = k_PLANNING_ACTIVE)
2058: ORDER BY mislv.allocation_percent;
2059: --

Line 2094: FROM msc_sourcing_rules

2090: AND mislv.source_type IN (1,2)
2091: AND (SYSDATE BETWEEN mislv.effective_date
2092: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397
2093: AND exists (SELECT null
2094: FROM msc_sourcing_rules
2095: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2096: AND planning_active = k_PLANNING_ACTIVE);
2097: --
2098: --perf changes

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

2233: v_assign_set_id := TO_NUMBER(SUBSTR(v_assign_set,4));
2234: -- Bug 3534969 jckwok
2235: v_source_level := 'PRFL';
2236: --
2237: ELSIF v_count_msc = 0 THEN /* No msc sourcing rules setup at the site level */
2238: --
2239: OPEN c_MSC_item; -- second level of hierarchy: MSC ITEM
2240: --
2241: LOOP