APPS.WSH_MBOLS_PVT SQL Statements

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

Line: 21

  SELECT
  wt.name,
  wc.freight_code
  FROM
  wsh_trips wt,
  wsh_carrier_services wcs,
  wsh_carriers wc
  WHERE
  wt.ship_method_code = wcs.ship_method_code(+) AND
  wcs.carrier_id = wc.carrier_id(+) AND
  trip_id = l_trip_id;

Line: 34

  SELECT sequence_number
  FROM   wsh_document_instances
  WHERE  entity_name = 'WSH_TRIPS'
  AND    entity_id   = l_trip_id
  AND    status     <> 'CANCELLED';

Line: 249

  SELECT  del.delivery_id,
          dlg.delivery_leg_id,
          wt.ship_method_code,
          del.initial_pickup_location_id,
          wt.name
  FROM    wsh_new_deliveries del,
          wsh_delivery_legs dlg,
          wsh_trip_stops st,
          wsh_trips wt
  WHERE   del.delivery_id = dlg.delivery_id
  AND     dlg.pick_up_stop_id = st.stop_id
  AND     dlg.parent_delivery_leg_id IS NULL
  AND     st.trip_id = wt.trip_id
  AND     del.initial_pickup_location_id = st.stop_location_id
  AND     wt.trip_id = l_trip_id;

Line: 266

  SELECT  ood.set_of_books_id
  FROM    org_organization_definitions ood,
          wsh_new_deliveries del
  WHERE   ood.organization_id = del.organization_id
  AND     del.delivery_id = p_delivery_id;

Line: 321

    SELECT count(*)
    INTO   l_bol_count
    FROM   wsh_document_instances
    WHERE  entity_name = 'WSH_DELIVERY_LEGS'
    AND    entity_id   = l_delivery_leg_id
    AND    status     <> 'CANCELLED';

Line: 443

  SELECT concurrent_program_id,
         output_print_style,
         save_output_flag,
         print_flag,
         printer_name
  FROM   fnd_concurrent_programs_vl
  WHERE  application_id = 665
  AND    concurrent_program_name = p_conc_prog_name;

Line: 656

  SELECT concurrent_program_id,
         output_print_style,
         save_output_flag,
         print_flag,
         printer_name
  FROM   fnd_concurrent_programs_vl
  WHERE  application_id = 665
  AND    concurrent_program_name = p_conc_prog_name;

Line: 845

select document_instance_id
   from    wsh_document_instances
   where   entity_id = p_trip_id
     AND document_type = 'MBOL'
     AND status in ('OPEN', 'PLANNED');

Line: 907

		   select  1 into l_tmp
		   from    wsh_document_instances
		   where   document_instance_id = l_mbol_num_tab(i).document_instance_id
		   FOR UPDATE NOWAIT;

Line: 1000

        select shipments_type_flag
	from wsh_trips
	where trip_id = p_trip_id;

Line: 1005

	select stop_location_id into l_location_id
	from
	wsh_trip_stops
	where trip_id = p_trip_id
	order by stop_sequence_number desc;

Line: 1012

	select organization_id
	from hr_all_organization_units
	where location_id = p_location_id;

Line: 1067

		select min(delivery_id)
		into l_first_delivery_id
		from wsh_trip_stops wts, wsh_delivery_legs wdl
		where wts.trip_id = p_trip_id
		and wts.stop_id = wdl.pick_up_stop_id;

Line: 1076

		select organization_id
		into l_organization_id
		from wsh_new_deliveries
		where delivery_id = l_first_delivery_id;