APPS.MRP_LINE_SCHEDULE_ALGORITHM dependencies on MRP_SCHEDULING_RULES

Line 497: FROM mrp_scheduling_rules

493: i NUMBER;
494:
495: CURSOR criteria_select IS
496: SELECT usage_code
497: FROM mrp_scheduling_rules
498: WHERE rule_id = p_rule_id
499: AND NVL(user_defined,C_USER_DEFINE_NO) = C_USER_DEFINE_NO
500: ORDER BY sequence_number;
501:

Line 4280: FROM mrp_scheduling_rules

4276: --Check the algorithm associated with the scheduling rule
4277:
4278: SELECT DISTINCT heuristic_code
4279: INTO v_algorithm
4280: FROM mrp_scheduling_rules
4281: WHERE rule_id = p_rule_id
4282: AND NVL(user_defined,C_USER_DEFINE_NO) = C_USER_DEFINE_NO ;
4283:
4284: V_ERROR_LINE := 2;