APPS.FTE_SOURCE_LINE_CONSOLIDATION SQL Statements

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

Line: 26

  SELECT a.generic_flag
  FROM   wsh_carriers a, wsh_carrier_services b
  WHERE a.carrier_id = b.carrier_id
    AND b.ship_method_code = c_ship_method_code;

Line: 352

  SELECT  WSH_WV_UTILS.convert_uom(weight_uom_code,
				   p_weight_uom,
				   nvl(unit_weight, 0) * WSH_WV_UTILS.convert_uom(p_source_qty_uom,
										  primary_uom_code,
										  p_source_qty, p_inv_id), p_inv_id),
	  WSH_WV_UTILS.convert_uom(volume_uom_code,
				   p_volume_uom,
				   nvl(unit_volume, 0) * WSH_WV_UTILS.convert_uom(p_source_qty_uom,
										  primary_uom_code,
										  p_source_qty,p_inv_id),p_inv_id)
  FROM  mtl_system_items
  WHERE organization_id = p_org_id
	AND inventory_item_id = p_inv_id;

Line: 395

	g_source_header_hash_tab.DELETE;