APPS.RLM_MANAGE_DEMAND_SV dependencies on MRP_SOURCING_RULES

Line 2002: FROM mrp_sourcing_rules

1998: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397
1999: AND mislv.rank = x_rank
2000: AND mislv.ship_to_site_id = x_ship_to_site_id
2001: AND exists (SELECT null
2002: FROM mrp_sourcing_rules
2003: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2004: AND planning_active = k_PLANNING_ACTIVE)
2005: ORDER BY mislv.allocation_percent;
2006: --

Line 2029: FROM mrp_sourcing_rules

2025: AND (SYSDATE BETWEEN mislv.effective_date
2026: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397
2027: AND mislv.ship_to_site_id = x_Group_rec.ship_to_site_use_id
2028: AND exists (SELECT null
2029: FROM mrp_sourcing_rules
2030: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2031: AND planning_active = k_PLANNING_ACTIVE);
2032: --
2033: -- below are original cursors but names of cursors are changed for clarity

Line 2079: FROM mrp_sourcing_rules

2075: AND (SYSDATE BETWEEN mislv.effective_date AND
2076: NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397
2077: AND mislv.rank = x_rank
2078: AND exists (SELECT null
2079: FROM mrp_sourcing_rules
2080: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2081: AND planning_active = k_PLANNING_ACTIVE)
2082: ORDER BY mislv.allocation_percent;
2083: --

Line 2108: FROM mrp_sourcing_rules

2104: AND mislv.source_type IN (1,2)
2105: AND (SYSDATE BETWEEN mislv.effective_date
2106: AND NVL(mislv.disable_date, TO_DATE('31/12/4712','dd/mm/yyyy')) OR SYSDATE < mislv.effective_date) --Bugfix 6051397
2107: AND exists (SELECT null
2108: FROM mrp_sourcing_rules
2109: WHERE sourcing_rule_id = mislv.sourcing_rule_id
2110: AND planning_active = k_PLANNING_ACTIVE);
2111: --
2112: