APPS.RLM_MANAGE_DEMAND_SV dependencies on MRP_SOURCING_RULES

Line 2016: FROM mrp_sourcing_rules

2012: --Bugfix 10053830 End
2013: AND mislv.rank = x_rank
2014: AND mislv.ship_to_site_id = x_ship_to_site_id
2015: AND exists (SELECT null
2016: FROM mrp_sourcing_rules
2017: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2018: AND planning_active = k_PLANNING_ACTIVE)
2019: ORDER BY mislv.allocation_percent;
2020: --

Line 2051: FROM mrp_sourcing_rules

2047: 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
2048: --Bugfix 10053830 End
2049: AND mislv.ship_to_site_id = x_Group_rec.ship_to_site_use_id
2050: AND exists (SELECT null
2051: FROM mrp_sourcing_rules
2052: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2053: AND planning_active = k_PLANNING_ACTIVE);
2054: --
2055: -- below are original cursors but names of cursors are changed for clarity

Line 2109: FROM mrp_sourcing_rules

2105: 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
2106: --Bugfix 10053830 End
2107: AND mislv.rank = x_rank
2108: AND exists (SELECT null
2109: FROM mrp_sourcing_rules
2110: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2111: AND planning_active = k_PLANNING_ACTIVE)
2112: ORDER BY mislv.allocation_percent;
2113: --

Line 2146: FROM mrp_sourcing_rules

2142: AND (rlm_dp_sv.g_dsp_start_time BETWEEN mislv.effective_date
2143: 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
2144: --Bugfix 10053830 End
2145: AND exists (SELECT null
2146: FROM mrp_sourcing_rules
2147: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2148: AND planning_active = k_PLANNING_ACTIVE);
2149: --
2150: