APPS.MRP_FLOW_SCHEDULE_PUB SQL Statements

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

Line: 621

,   p_update                        IN NUMBER
)
IS
l_api_version_number          CONSTANT NUMBER := 1.0;

Line: 647

                     p_update           ,
		     2			,
                     x_return_status    ,
                     x_msg_count        ,
                     x_msg_data         );

Line: 863

  SELECT line_id
  INTO l_line_id
  FROM BOM_OPERATIONAL_ROUTINGS
  WHERE ROUTING_SEQUENCE_ID = p_routing_sequence_id
    AND ASSEMBLY_ITEM_ID = p_assembly_item_id
    AND ORGANIZATION_ID = p_org_id;

Line: 879

  SELECT count(*)
  INTO l_cnt
  FROM BOM_OPERATION_SEQUENCES
  WHERE OPERATION_SEQUENCE_ID = p_operation_sequence_id
    AND ROUTING_SEQUENCE_ID = p_routing_sequence_id;

Line: 1006

    select inventory_item_id
    into l_item_id
    from oe_order_lines_all
    where line_id = p_line_id;

Line: 1026

  update wip_flow_schedules
  set demand_source_header_id = null,
      demand_source_line = null,
      demand_source_type = null,
      demand_source_delivery = null
  where demand_source_line = to_char(p_line_id)
    and primary_item_id = p_assembly_item_id
    and demand_source_type = 2 ;