APPS.WSH_BOLS_UTIL_PKG SQL Statements

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

Line: 153

     SELECT description
     FROM mtl_system_items_vl
     WHERE organization_id = p_organization_id
     AND inventory_item_id = p_inventory_item_id;

Line: 294

	SELECT container_name,
	  container_type_code,
	  item_description,
	  inventory_item_id,
	  gross_weight,
	  weight_uom_code,
	  volume,
	  volume_uom_code
	  FROM wsh_delivery_details
	  WHERE delivery_detail_id = x_master_inst_id
	  AND container_flag = 'Y';

Line: 307

	SELECT wdd.item_description,
	  wdd.inventory_item_id,
	  wdd.hazard_class_id,
	  wdd.shipped_quantity,
	  wdd.requested_quantity_uom,
	  wdd.classification
	  FROM wsh_delivery_details wdd,
	  wsh_delivery_assignments_v wda
	  WHERE wda.parent_delivery_detail_id = x_master_inst_id
	  AND wda.delivery_detail_id = wdd.delivery_detail_id
	  AND wdd.container_flag = 'N';

Line: 320

	SELECT wdd.delivery_detail_id
	  FROM wsh_delivery_details     wdd,
	  wsh_delivery_assignments_v wda
	  WHERE wda.delivery_detail_id = wdd.delivery_detail_id
	  AND wdd.container_flag = 'Y'
	  AND wda.delivery_assignment_id IN
	  (SELECT wda1.delivery_assignment_id
	   FROM wsh_delivery_assignments_v wda1
	   START WITH wda1.parent_delivery_detail_id =  x_container_id
	   CONNECT BY PRIOR wda1.delivery_detail_id = wda1.parent_delivery_detail_id);

Line: 332

	SELECT wdd.item_description,
	  wdd.inventory_item_id,
	  wdd.hazard_class_id,
	  wdd.shipped_quantity,
	  wdd.requested_quantity_uom,
	  wdd.classification
	  FROM wsh_delivery_details wdd,
	  wsh_delivery_assignments_v wda
	  WHERE wda.parent_delivery_detail_id = x_cont_inst_id
	  AND wda.delivery_detail_id = wdd.delivery_detail_id
	  AND wdd.container_flag = 'N';

Line: 345

	SELECT wdd.delivery_detail_id
	  FROM wsh_delivery_assignments_v wda,
	  wsh_delivery_details     wdd
	  WHERE wda.parent_delivery_detail_id = x_master_inst_id
	  AND wda.delivery_detail_id = wdd.delivery_detail_id
	  AND wdd.container_flag = 'Y';

Line: 353

	SELECT container_name
	  FROM wsh_delivery_details
	  WHERE delivery_detail_id = x_cont_id
	  AND container_flag = 'Y';

Line: 360

     SELECT description
     FROM mtl_system_items_vl
     WHERE organization_id = p_organization_id
     AND inventory_item_id = p_inventory_item_id;