APPS.MRP_CRP_HORIZONTAL_PLAN dependencies on WIP_LINES

Line 459: wip_lines lines,

455: sched.daily_production_rate*lines.maximum_rate/
456: rep_items.PRODUCTION_LINE_RATE
457: FROM wip_repetitive_items rep_items,
458: wip_repetitive_schedules sched,
459: wip_lines lines,
460: mrp_form_query list
461: WHERE rep_items.organization_id = sched.organization_id
462: AND rep_items.line_id = sched.line_id
463: AND rep_items.wip_entity_id = sched.wip_entity_id

Line 491: FROM wip_lines line,

487: nvl(line.maximum_rate, 0) *
488: (decode(least(line.start_time, line.stop_time),
489: line.stop_time, (line.stop_time + (24 *3600)),
490: line.stop_time) - line.start_time) / 3600
491: FROM wip_lines line,
492: mrp_form_query list
493: WHERE nvl(line.disable_date, sysdate + 1) > sysdate
494: AND line.organization_id = list.number1
495: AND line.line_id = list.number2

Line 1471: FROM wip_lines line

1467: ELSE
1468: -- NUM_OF_TYPES := 9;
1469: SELECT line.line_code
1470: INTO v_line_code
1471: FROM wip_lines line
1472: WHERE line.line_id = p_line_id;
1473: END IF;
1474:
1475: g_error_stmt := 'Debug - flush_crp_plan - 10';