APPS.WIP_DEFAULT_DISCRETEJOB SQL Statements

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

Line: 103

      SELECT default_discrete_class INTO l_acct_class
	FROM wip_parameters
	WHERE organization_id = g_DiscreteJob_rec.organization_id;

Line: 680

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

Line: 721

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

Line: 855

   Select wip_entities_s.nextval into l_wip_entity_id FROM dual;