APPS.WIP_DEFAULT_REPSCHEDULE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 108

      SELECT minimum_rate, maximum_rate, fixed_throughput
        INTO l_min_rate, l_max_rate, l_fixed_thruput
        FROM wip_lines
        WHERE line_id = g_RepSchedule_rec.line_id
        AND organization_id = g_RepSchedule_rec.organization_id;

Line: 204

      SELECT line_schedule_type INTO l_line_sch_type
	FROM wip_lines
	WHERE line_id = g_RepSchedule_rec.line_id;

Line: 218

      SELECT 1 INTO l_rout_exists
	FROM dual
	WHERE exists(
		     SELECT routing_sequence_id
		     FROM bom_operational_routings
		     WHERE assembly_item_id = g_RepSchedule_rec.primary_item_id
		     AND organization_id = g_RepSchedule_rec.organization_id);

Line: 255

      SELECT line_schedule_type INTO l_line_sch_type
	FROM wip_lines
	WHERE line_id = g_RepSchedule_rec.line_id;

Line: 268

      SELECT 1 INTO l_rout_exists
	FROM dual
	WHERE exists(
		     SELECT routing_sequence_id
		     FROM bom_operational_routings
		     WHERE assembly_item_id = g_RepSchedule_rec.primary_item_id
		     AND organization_id = g_RepSchedule_rec.organization_id);

Line: 300

      SELECT line_schedule_type INTO l_line_sch_type
	FROM wip_lines
	WHERE line_id = g_RepSchedule_rec.line_id;

Line: 314

      SELECT 1 INTO l_rout_exists
	FROM dual
	WHERE exists(
		     SELECT routing_sequence_id
		     FROM bom_operational_routings
		     WHERE assembly_item_id = g_RepSchedule_rec.primary_item_id
		     AND organization_id = g_RepSchedule_rec.organization_id);

Line: 349

      SELECT line_schedule_type INTO l_line_sch_type
	FROM wip_lines
	WHERE line_id = g_RepSchedule_rec.line_id;

Line: 363

      SELECT 1 INTO l_rout_exists
	FROM dual
	WHERE exists(
		     SELECT routing_sequence_id
		     FROM bom_operational_routings
		     WHERE assembly_item_id = g_RepSchedule_rec.primary_item_id
		     AND organization_id = g_RepSchedule_rec.organization_id);

Line: 630

   Select wip_entities_s.nextval into l_wip_entity_id FROM dual;