APPS.CTO_FLOW_SCHEDULE SQL Statements

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

Line: 111

	    SELECT  ENABLE_LOWER_LEVEL_SUPPLY,oel.created_by
	    INTO l_mlsupply_parameter,l_created_by --bugfix 2803881
	    FROM bom_parameters bp,
	         oe_order_lines_all oel
	    WHERE oel.line_id = p_config_line_id
	    AND   oel.ship_from_org_id 	= bp.organization_id;

Line: 238

  select inventory_item_id, ship_from_org_id
  into   l_config_item_id, l_org_id
  from   oe_order_lines_all oel
  where  oel.line_id = p_config_line_id;

Line: 248

  SELECT wl.LINE_ID
  INTO   l_flow_schedule_rec.line_id
  FROM BOM_OPERATIONAL_ROUTINGS BOR,
       wip_lines wl
  WHERE BOR.ASSEMBLY_ITEM_ID = l_config_item_id
  AND BOR.ORGANIZATION_ID = l_org_id
  AND BOR.CFM_ROUTING_FLAG = 1
  AND BOR.alternate_routing_designator IS NULL
  AND wl.line_id = bor.line_id
  AND wl.organization_id = bor.organization_id;

Line: 265

  SELECT INV_SALESORDER.GET_SALESORDER_FOR_OEHEADER(HEADER_ID),
         line_id,
	 to_char(NULL),
	 2,
	 inventory_item_id,
	 INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(SHIP_FROM_ORG_ID ,INVENTORY_ITEM_ID,ORDER_QUANTITY_UOM ,ORDERED_QUANTITY),
	 ship_from_org_id,
	 project_id,
	 schedule_ship_date,
	 task_id
  INTO   l_flow_schedule_rec.demand_source_header_id,
         l_flow_schedule_rec.demand_source_line,
         l_flow_schedule_rec.demand_source_delivery,
         l_flow_schedule_rec.demand_source_type,
         l_flow_schedule_rec.primary_item_id,
         l_flow_schedule_rec.planned_quantity,
         l_flow_schedule_rec.organization_id,
         l_flow_schedule_rec.project_id,
         l_flow_schedule_rec.scheduled_completion_date,
         l_flow_schedule_rec.task_id
  FROM    oe_order_lines_all
  WHERE   line_id = p_config_line_id;

Line: 326

      since the above select will raise no-data-found
      if no rows are selected.

  -- if (SQL%ROWCOUNT <= 0) then
  --    raise FND_API.G_EXC_ERROR;

Line: 476

   select wfs.line_id, wfs.organization_id, oel.schedule_ship_date,
          wfs.primary_item_id, wfs.planned_quantity
   into   l_line_id, l_org_id, l_ship_date, l_config_item_id, l_planned_qty
   from   wip_flow_schedules wfs,
          oe_order_lines_all oel
   where  oel.line_id = to_number(p_config_line_id)
   and    wfs.organization_id = oel.ship_from_org_id
   and    wfs.wip_entity_id = p_wip_entity_id
   and    scheduled_flag = 3;

Line: 493

     select rule_id
     into   l_rule_id
     from   mrp_scheduling_rules
     where  default_flag = 'Y'
     and    rownum = 1;

Line: 578

                             p_update             => 1.0);